November 12, 2025

Wednesday of Week 12

Topics of the day

SQL cont'd
Entity-relationship models

| Reading | Online | Assignments |

Suggested readings

Sections 3.3, 3.4 from Ramez Elmasri and Shamkant Navathe, Fundamentals of database systems, 4e
Sections 7.3, 7.4 from Ramez Elmasri and Shamkant Navathe, Fundamentals of database systems, 6e
Sections 2.1, 2.2 from Jeffrey Ullman and Jennifer Widom, A first course in database systems, 2e

Online reference

E-R model (en.wikipedia.org)

Assignments

Today

Project 4: Database prep due
Project 3: A* followup

Upcoming

Project 4: Database design due (17 Nov)
Homework 7 due (17 Nov)
Homework 6 revision (17 Nov)
Homework 5 revision (17 Nov)