Chapter 5, Problem 6P

Explanation of Solution

Crow’s Foot ER diagrams for Tiny College IT Staffing Solution:

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

Explanation:

• In the above data model, the overlapping constraint (o) is used as a category symbol. Here the “Employee” supertype entity has optional subtype entity. The primary of “Employee” entity is “Emp_No”.
• The “Professor”, “Staff” and “Admin” are the subtype entities...