Lecture: Relational Model

Content: Principle for storing data in tables in an SQL database, instructions on converting E-R diagram into tables (relational model).

Covered terms: Relational model - schema of database, schema of table, integrity constraints; rules on how to convert ERD into tables.

Slides cover Chapter 2 in the book Database Systems Concepts.

Tutorial: Conversion of ERD to tables (and back)

Approach: Work independently or in pairs/groups; slide-by-slide is important here (later slides may reveal a solution to the preceding ones).

Mid-term assignment (10 points in total, deadline Dec. 20, 2024):

The deadline is Dec. 20, 2024. 

The score is up to 5 points in each.