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.