Chapter 5, Problem 5P

Explanation of Solution

Crow’s Foot ER diagram for Tiny College:

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 “Professor” and “School” are the current data entities which mean the user can get the data from the current database...