Sep 10: Entity-Relationship Model

Learning Objectives

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

• Define the following terms: relationship, cardinality, participation.
• Draw and explain an ER diagram from abstract data requirements.

Lesson Outline

HW2 Q&A [10 min]

• Editing and running hw2.sql
• Testing with hw2.py script

Lecture Slides: ER Models

• [10 min] Conceptual data models, entities, attributes
• [15 min] Group Activity: Abstract ER Model, Part 1
• [10 min] Relationships, cardinality, and participation
• [15 min] Group Activity: Abstract ER Model, Part 2

Group Project [15 min]

• Project 1 (due Sep 16) specification
• Finalize groups and brainstorm ideas

Your To-Do List

• Finish and submit HW2 (due tonight)
• Read zyBook sections 3.1 – 3.6
  • Ideally before Thursday's class
• Start working on GP1 (due Monday)