A trucking comapny called truckers is responsible for picking up shipments for warehouses of a retail chain called MAZE brothers and delivering the shipments to individual reatil store locations of MAZE brothers. Currently there are six warehouse locations and 45 retail outlets of MAZE brothers. A truck may carry several shipments on a single trip, which is identified by a trip number, and delivers those shipments to multiple stores. Each shipment is identified by a shipment number 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 truckers company currently has 150 trucks and a truck makes three to four trips per week. Design an ER schema diagram for the above application. Make any assumptions you need but state them clearly. A database is being constructed to keep track of teams and games of a sports league. A team has a number of players, not all of whom participate in each game.