Week 2 - Relational Databases

Learning Objectives

After today's class, you should be able to:

Develop a strong foundation in database theory, including the history of database models, the relational model, keys (primary and foreign), referential integrity, and normalization principles.
Apply conceptual knowledge by converting entity-relationship models into logical database designs and understanding the rules that guide relational structures.
Gain practical skills in database implementation by creating databases and writing SQL to define tables, constraints, and relationships.