Chapter 4, Problem 11C

Explanation of Solution

Entity Relational (ER) Diagram:

The following figure illustrates the ER Diagram for given business rules in Crow’s Foot notation:

Explanation:

The above The Tiny College (TFBS Maintenance) ERD contains entities such as “LOG”, “VECHICLE”, “LOG_LINE”, “ACTION”, “MECHANIC”, “PART”, “EMPLOYEE” and “LOG_OUT”.

• The relationship between the “VECHICLE” and “LOG” entities is 1: M. It is a weak relationship because the VECHICLE’s PK is included as FK in LOG entity...