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) |
|---|---|---|---|
| October 24 | Introduction | 1 | 1 |
| October 26 | Relational model, E-R diagrams | 3.1, 3.6.1-2, 2, 3.2 | 2.2, 3.3.1-2, 4.1-6 |
| October 31 | E-R diagrams cont., Functional dependencies | 2, 3.2-5 | 4.1-6, 3.1-2 |
| November 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 |
| November 7 | SQL DDL, Queries, Relational Algebra | 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 |
| November 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 |
| November 14 | 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 |
| November 16 | SQL DDL, Assertions, Triggers | 6.7, 7.1.5, 7.4- | 8.1, 8.2, 7.1.2, 7.4-7.5 |
| November 21 | SQL/PSM, Embedded SQL, JDBC | 8.1-5 | 9.2-6 |
| November 23 | Transactions, Authorization | 8.6-7 | 6.6, 10.1 |
| November 28 | XML, Data integration | 4.6-7 | 11.1-2 |
| November 30 | Indexes | 6.6.5-6,13.1-2 | 8.3-4, 14.1 |
| December 5 or 7 | Revision |