Sep 24: Relational Mapping
Learning Objectives
After today's class, you should be able to:
- Map an EER diagram to a set of relations with primary and foreign keys.
- Read and draw relational diagrams using database markup language (DBML).
Lesson Outline
Notifications [5 min]
- GitHub Notification Settings – see also watched/ignored
- Gradescope Email Filter – can be used for GitHub too
DBML Intro [10 min]
- dbdiagram.io – "Draw ER Diagrams, Painlessly 😎"
- DBML - Database Markup Language documentation
Lecture Slides [20 min]
- EER to Relational
- EER Modeling Review
- EER to Relational Mapping
Group Activity [40 min]
Your To-Do List
- Revise GP1 and approve PR ← due Friday
- Submit HW3 on Gradescope ← due Monday