Question: Can you help me with q2 please? For database. A trucking company is responsible for picking up shipments for warehouses of s retail chain and
A trucking company is responsible for picking up shipments for warehouses of s retail chain and delivering the shipments to individual retail store locations. A truck may carry several shipments during a single trip, which is identified by a Trip#, and delivers those shipments to multiple stores. Each shipment is identified by a Shipment# and include data on shipment volume, weight, destination, etc. Trucks have different capacities for both the volumes they can hold and the weights they can carry. A database 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 the above application. Make any assumptions you need but state them clearly
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
