| Lecture | Date | Topics | Text Chapters | Links |
|---|---|---|---|---|
| 1.1 | 1 April | Course overview. DBMS architecture and purpose. Data Models. DDL & DML. | 1, 2 | |
| 1.2 | 3 April | ER Model. | 3 | |
| 2.1 | 8 April | Relational Model. Constraints. Referential integrity. | 5 | |
| 2.2 | 10 April | ER -> Relational translation. | 7 | |
| 3.1 | 15 April | Relational algebra and calculus (domain and tuple) | 6 | |
| 3.2 | 17 April | Relational algebra and calculus. | 6 | |
| 4.1 | 22 April | SQL | 8 | |
| 4.2 | 24 April | SQL. Views. Aggregation. Triggers | 8 | |
| 5.1 | 29 April | Functional Dependencies. | 10 | |
| 5.2 | 1 May | MIDTERM TEST | 1 - 3, 5 - 8 | |
| 6.1 | 6 May | Armstrong's Axioms. FDs and normalization. Mid-course review. | 10 | |
| 6.2 | 8 May | Decomposition. Normal forms: 2NF, 3NF, BCNF. | 11 | |
| 7.1 | 13 May | Web DB and PHP. | 26 | examples |
| 7.2 | 15 May | More Web DB and PHP | 26 | |
| 8.1 | 20 May | Physical Data Organization: Disk anatomy, B+-trees. Query Optimization. | 13, 14, 15 | |
| 8.2 | 22 May | More query optimization. | 15 | |
| 9.1 | 27 May | More query optimization. | 13 | |
| 9.2 | 29 May | Transaction Processing | 17 | |
| 10.1 | 3 June | FINAL TEST | all of the above |
There will NOTbe an exam during exam week.