Sep 17: EER-Relational Mapping

Learning Objectives

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

• Apply the rules for translating an EER model into a relational model.
• Use the ER Model tool in MySQL Workbench to semi-automatically translate an EER model into a relational model.

Lesson Outline

Week 4 Debrief [10 min]

• HW2 solution in Canvas Files
• Reading EER Diagrams solution in Canvas Files

GP1 Peer Review [10 min]

• Skim through all 13 proposals in Canvas for context
• Carefully read the proposal assigned to your group
  • Add markings, suggestions, corrections, etc.
  • Look for ways to help the other team improve
• Complete the provided GP1 Peer Review Form twice:
  • One form about the proposal you are reviewing
  • One form about your own proposal (self assess)

Lecture Slides [15 min]

• EER to Relational Mapping

Group Activity [40 min]

• EER to Relational Mapping using MySQL Workbench

Your To-Do List

• Read zyBook sections 3.7 – 3.9 (ideally before Thursday)
• Complete GP1 peer review process – due Thursday in class
• Start working on HW3 (due Monday)