Data Models & Design
A 16-module path through data models & design, in study order from foundations to the frontier.
Modules
- The Database and the DBMS
- Data Abstraction and Schemas
- The Relational Model
- Relations, Attributes, and Keys
- Integrity Constraints
- Entity-Relationship Modeling
- ER Diagrams
- Mapping ER to Relations
- The Relational Algebra
- Relational Calculus
- Functional Dependencies
- Normalization Motivation and Anomalies
- First Normal Form
- 2NF and 3NF
- Boyce-Codd Normal Form
- Lossless-Join Decomposition