Sep 23: EER-Relational Mapping; DBML
Learning Objectives
After today's class, you should be able to:
- Demonstrate your knowledge of EER and relational model concepts.
- Develop a relational model given an EER model.
Lesson Outline¶
Lecture Slides: EER to Relational Mapping
[5 min]
GP2 feedback activity[15 min]
Slides[10 min]
Introduction to dbdiagram and DBML- dbdiagram.io – "Draw ER Diagrams, Painlessly 😎"
- DBML - Database Markup Language documentation
[45 min]
Group Activity: EER to Relational Mapping
Due Thursday at 12:00 noon
Each student must individually review two other teams' EER models and submit written feedback. Submit the GP2 Review (n+2) and GP2 Review (n-2) assignments on Gradescope. In Thursday’s class, you will share your feedback verbally. After class, the instructors will add your written feedback to the teams' repositories.
Your To-Do List¶
- GP1 peer evaluation – see cs374f25 repositories
- Begin reading section 1.9 and 3.4 in the book
- GP3 Relational model – read the spec and get started