The course will contain:
Lectures:
| Date | Subject | Book sections ("Database Systems: The Complete Book", first edition) | Book sections ("Database Systems: The Complete Book", second edition) |
|---|---|---|---|
| January 19 | Introduction | 1 | 1 |
| January 21 | Relational model, E-R diagrams | 3.1, 3.6.1-2, 2, 3.2 | 2.2, 3.3.1-2, 4.1-6 |
| January 22 | E-R diagrams cont., Functional dependencies | 2, 3.2-5 | 4.1-6, 3.1-2 |
| February 2 | Normalization, BCNF, Multivalued dependencies, 3NF, 4 NF | 3.6.3-, 3.7 | 3.3.3-4, 3.4.1, 3.5.1, 3.6 |
| February 5 | SQL DDL, Queries, Relational Algebra (by Jonas Almström Duregård) | 6.5-6, 7.1-3, 5.1-2, 6.1.1-2, 6.2.1 | 6.5, 2.3, 7.1-3, 2.4, 6.1.1-2, 6.2.1 |
| February 9 | SQL queries and Relational Algebra cont. | 5.2.9-, 6.1.3 -6, 6.2.2-4, 6.3.1-7, 6.7.1-2 | 2.4.11-, 6.1.3-7, 6.2.2-4, 6.3.1-7, 8.1 |
| February 12 | SQL queries and Relational Algebra cont. | rest of 5 & 6 except 6.7 | 6.1.8, 6.2.5, 6.3.8, 6.4, 5.1, 5.2, 2.5 |
| February 16 | SQL DDL, Assertions, Triggers | 6.7, 7.1.5, 7.4- | 8.1, 8.2, 7.1.2, 7.4-7.5 |
| February 19 | SQL/PSM, Embedded SQL, JDBC | 8.1-5 | 9.2-6 |
| February 23 | Transactions, Authorization, Indexes | 8.6-7; 6.6.5-6,13.1-2 | 6.6, 10.1, 18.1; 8.3-4, 14.1 | March 2 | XML | 4.6-7 | 11.1-2 |
| March 2 | Guest lecture by Marcus Better from Spotify | ||
| March 5 | Revision: going through old exams |