Chapter 5, Problem 10C

Explanation of Solution

Crow’s Foot ER diagram for Global Unified Technology Sales (GUTS):

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

Explanation:

• In the above data model, one department can contain many employees. The primary key of “Department” entity is “Dept_No” and “Employee” entity contains “Emp_No” as primary key.
• One employee uses more than one enabled services. so, the primary key and foreign key of this “Enabled” entity is “Service_No” and “Emp_No”.
• The “Service” entity is used by the “Enabled” entity. The primary key of the “Service” entity is “Service_No” and foreign key is “Server_No”...