Database Systems I
Actual info
Summary of main documents
Test on SQL
- Data model of the RVVI database: pdf
- Sample SQL queries for the RVVI database.
Semestral Project
| Week | Lecture | Exercise |
| 1. | Lecture slides: Introduction, Relational data model  | Tasks: SQL Basics Script: Sakila DB |
| 2. | Lecture slides: Relational algebra, SQL: Join Script: Student study subject | Tasks: Join Solutions: Join |
| 3. | Lecture slides: SQL: Aggregate functions, Group by | Tasks: Aggregate Functions and Group By Solutions: Aggregate Functions and Group By |
| 4. | Lecture slides: SQL: subqueries | Tasks: Set Operations and Quantifiers Solutions: Set Operations and Quantifiers |
| 5. | Lecture slides: Complex SQL Select Queries | Tasks: Subqueries Solutions: Subqueries |
| 6. | Lecture slides: Conceptual modeling | RVVI database examples |
| 8. | Lecture slides: Conceptual modeling, patterns, antipatterns | Test on SQL |
| 9. | Lecture slides: DDL & DML SQL | Project consultation |
| 10. | Lecture slides: Indexing | Tasks: DML&DDL Solutions: DML&DDL |
| 11. | Lecture slides: Functional dependencies | DML/DDL Test |
| 12. | Lecture slides: Normal Forms | Tasks: Functional Dependencies |
| 13. | Tasks: Normal Forms |