Asignatura: Bases de Datos · UAH GII · Curso 2025-26
Relational database design and implementation: ER modelling, SQL querying, PL/SQL programming, triggers, user management and Python database connectivity.
| Topic | Content |
|---|---|
| Relational model | ER design, normalisation (1NF, 2NF, 3NF, BCNF) |
| SQL | SELECT, JOIN, subqueries, aggregations, window functions |
| PL/SQL | Procedures, functions, cursors, exception handling |
| Triggers | BEFORE/AFTER, row-level, audit triggers, business logic |
| Users and security | RBAC, GRANT/REVOKE, role hierarchy |
| Transactions | COMMIT, ROLLBACK, isolation levels, ACID properties |
| Python connector | cx_Oracle, parameterised queries, connection pooling |
| # | Name | Description |
|---|---|---|
| PL1 | ER design | Relational model design and DDL creation |
| PECL2 | f1-database | F1 relational DB with 589K lap records, 11 tables, complex queries, audit triggers, RBAC roles and Python connector |
| Table | Records |
|---|---|
| circuitos | 77 |
| temporadas | 75 |
| escuderias | 212 |
| pilotos | 861 |
| gps | 1,125 |
| pilotos_corren_gps | 26,685 |
| pilotos_califican_gps | 10,494 |
| vueltas | 589,081 |
| pit_stops | 11,371 |
| Role | Permissions |
|---|---|
| admin | Full DDL + DML |
| gestor | DML only (no DDL) |
| analista | SELECT all tables |
| invitado | SELECT results, pilots, circuits — no lap times, no pit stops |
Bases de Datos · UAH GII · 2025-26