Chapter 5, Problem 8C

Explanation of Solution

Crow’s Foot ER diagram for MARU art school:

The following data model shows the solution for the given question.

Explanation:

• In the above data model, “Student” entity contains “Stud_No” as primary key and details of the student are present in the “Student” entity.
• The “Instructors” is a subtype of “Student” entity. Here same “Stud_No” is the primary and foreign key. The “Student” supertype entity has optional “Instructors” entity.
• The many class is assigned to one instructor so one-to-many relationship is used...