Feb 17: EER Modeling

Learning Objectives

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

• Demonstrate your knowledge of EER syntax.
• Develop an EER model for a realistic system.

Lesson Outline

• [20 min] Group Activity: Reading EER Diagrams
• [10 min] Review for Test 1 (Thursday Feb 19)
• [15 min] Review the Conference Review System Model
  • One possible solution
• [30 min] Begin HW3

Test 1 Topics

• Simple SQL queries using the Company and World databases (see HW1)
• Simple insert, update, delete queries on the same databases (see HW2)
• Creating simple EER diagrams (see Abstract ER Model)
  • Chen solution
  • Compact solution
• Reading EER diagrams (see Reading EER Diagrams)
  • Solution
• Information you will be given:
  • Diagram notation
  • World DB model
  • Company DB model

Your To-Do List

• Read sections 2.3 and 2.4 in the book