0

Hi Can anyone please help to create this ER Diagram:

A trucking company called "ABC" picks up shipments from warehouses of a retail chain called WARE_BROTHERS. Shipments are delivered to individual retail store locations of WARE_BROTHERS. There are currently 6 warehouse locations and 50 retail stores.
A truck can carry several shipments during a single trip, and each trip is identified by Trip# and delivers those shipments to possible multiple stores. Each shipment is identified by a shipment# and includes info about shipment volume, weight, destination, etc.
Trucks have different capacities for both the volume they can hold and the weight they can carry. The ABC company currently has 150 trucks, and each truck makes 3 to 4 trips each week.
A database to be used by both ABC and WARE_BROTHERS must be designed to keep track of truck usage and deliveries as well as for scheduling trucks and shipments.

Thanks in advance.

2
Contributors
1
Reply
3
Views
6 Years
Discussion Span
Last Post by BitBlt
0

We generally give help to those who show at least SOME effort to do their own work first. What have you already got?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.