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 20 | Introduction | 1 | 1, 2.1-2, 3.3.1 |
| January 22 | Relational model, E-R diagrams | 3.1, 3.6.1-2, 2, 3.2 | 4.1-6 |
| January 23 | Functional dependencies | 2, 3.2-5 | 3.1-2, 3.3.1-3 |
| January 27 | Normalization, BCNF, 3NF | 3.6.3-, 3.7 | 3.3.3-4, 3.4.1, 3.4.4, 3.5.1 |
| January 30 | Independencies, 4NF | 3.6.3-, 3.7 | 3.6 |
| February 3 | SQL DDL, Queries, Relational Algebra | 6.5-6, 7.1-3, 5.1-2, 6.1.1-2, 6.2.1 | 2.3, 7.1-3, 6.5, 2.4, 6.1.1-2, 6.2.1, 5.1.1 |
| February 6 | 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, 6.4.4, 8.1 |
| February 10 | SQL queries and Relational Algebra cont. | rest of 5 & 6 except 6.7 | 6.1.8, 5.1, 5.2, 6.2.5, 6.3.8, 6.4, 2.5 |
| February 13 | SQL DDL, Assertions, Triggers | 6.7, 7.1.5, 7.4- | 8.1, 8.2, 7.1.2, 7.4-7.5 |
| February 17 | SQL/PSM, Embedded SQL, JDBC | 8.1-5 | 9.2-6 |
| February 20 | Transactions, Authorization | 8.6-7 | 6.6, 10.1 |
| February 24 | Indexes; Optimization | 6.6.5-6,13.1-2 | 8.3-4, (14.1) |
| February 27 | XML | 4.6-7 | 11, 12.1-2 |
| March 3 | Real world outlook; NoSQL | ||
| March 6 | Course Summary, Assignment retrospective | ||
| March 7 | Guest Lecture by Marcus Better: Using Cassandra at Spotify |