Chapter 6, Problem 23E

Explanation of Solution

Database diagram for world-wide package delivery company:

Explanation:

In the above database diagram, “Customer”, “Package”, “Location”, “Truck”, “Plane”, “Airport”, and “Warehouse” are the entities.

• The “Customer” entity contains “cust_ID”, “cust_Name”, “cust_Address” and “cust_Phone” attributes. Here, “cust_ID” is a primary key.
• The “Package” entity contains “package_ID”, “package_desc”, “date” and “time” attributes. Here, “package_ID” is a primary key.
• The “Location” entity contains “loc_ID”, “loc_desc”, “date”, and “time” attributes. Here, “loc_ID” is a primary key...