Sample Entity-Relationship Modeling Problem

 

A trucking company called NORTH STATE TRUCKING is responsible for picking up shipments for warehouses of a retail chain called MAZE BROTHERS, and delivering the shipments to individual retail store locations of MAZE BROTHERS.  Currently there are 6 warehouse locations and 45 retail stores of MAZE BROTHERS.  A truck may carry several shipments during a single trip, which is identified by Tripnum, and delivers those shipments to multiple stores.  Each shipment is identified by a Shipmentnum, and includes data on shipment volume, weight, destination, etc.  Trucks have different capacities for both the volumes they can hold and the weights they can carry.  The NORTH STATE TRUCKING company currently has 150 trucks and each truck makes 3 to 4 trips each week.  A database, to be used both by NORTH STATE TRUCKING and MAZE BROTHERS, is being designed to keep track of truck usage and deliveries, and to be used for scheduling trucks to provide timely deliveries to stores.  Design an ER schema diagram for this application.  Make any assumptions you need to make and state them clearly.