All readings are from Database Design (2nd Edition) by Watt and Eng.
Date | Reading |
---|---|
Jan 15 | 1 — Before the advent of database systems |
Jan 16 | 2 — Fundamental concepts 3 — Characteristics and benefits of a database |
Jan 21 | 4 — Types of data models 5 — Data modeling |
Jan 22 | 6 — Classification of DBMS’s |
Jan 23 | 7 — The Relational Model |
Jan 30 | Skim 8 — The ER model (skim only; we’re using UML instead) 9 — Integrity rules and constraints |
Feb 4 | 11 — Functional dependencies |
Feb 5 | 12 — Normalization |
Feb 6 | 15 — SQL part 1 |
Feb 11 | 16 — SQL part 2 |