Sep 09: 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

Lecture Slides: ER Models

• [10 min] Conceptual data models, entities, attributes
• [5 min] Introduction to draw.io
• [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 [20 min]

• Project 1 (due Sep 15) specification
  • README.md from last year's profs repo
  • This year's profs repo coming soon…
  • Markdown reference
• Brainstorm ideas and begin working on proposal
• Has everyone cloned their team's repository?

Your To-Do List

• Start reading sections 2.1 and 2.2 in the book
• Start working on GP1 (due Monday)