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 17 | Introduction | 1 | 1, 2.1-2, 3.3.1 |
January 20 | Relational model, E-R diagrams | 3.1, 3.6.1-2, 2, 3.2 | 4.1-6 |
January 24 | 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 31 | 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 7 | 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 14 | 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 21 | Transactions, Authorization | 8.6-7 | 6.6, 10.1 |
February 24 | Indexes; NoSQL | 6.6.5-6,13.1-2 | 8.3-4, (14.1) |
February 28 | XML | 4.6-7 | 11, 12.1-2 |
March 3 | Course Summary | ||
March 7 | Guest lecture by Graham Kemp: Case studies, index implementation, and everything | ||
March 10 | Programming assignment retrospective |