ER Modeling III

Learning Objectives

• 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 II Database Management Systems »