Chapter 6, Problem 22E

Explanation of Solution

Database for automobile company:

Explanation:

In the above database diagram, “Customer”, “Vehicle”, “Brand”, “Model”, “Dealer”, and “Option” are the entities.

• The “Customer” entity contains “cust_ID”, “cust_Name”, “cust_Address” and “cust_Phone” are the attributes. Here, “cust_ID” is a primary key.
• The “Vehicle” entity contains “VIN”, and “vehicle_Name” attributes. Here, “VIN” is a primary key.
• The “Brand” entity contains “brand_ID”, and “brand_Name” attributes. Here, “brand_ID” is a primary key.
• The “Model” entity contains “model_ID”, and “model_Name” attributes. Here, “model_ID” is a primary key...