ER Modeling II

Learning Objectives

• Define the following terms:
  • cardinality
  • modality
• Name the types of relationships that may exist among entities
• Interpret an ER model for a real-world system
• Describe how to model inheritance within an ER diagram
• Explain the difference between disjoint and overlapping constraints on subtypes
• Create an ER model based on a case study of a real-world system

How to Complete this Lesson

Complete the following learning activities: (3.5 hours total)

1. Skim Fundamentals of Database Management Systems Chapter 9: Object-Oriented Database Design (45 minutes)
2. Attend the class meeting (60 minutes)
   • Complete the handout as time permits in (or out of) class
3. Take the quiz (10 minutes)
4. Complete the Microsoft Access programming exercise (PEX) (90 minutes)
   • Complete Creating Forms and Reports

Due

As a reminder, the following is due this lesson:

• Quiz: ER Modeling

Resources

• Questions for data modeling (45 minutes)

---

« ER Modeling I

Database Management Systems »