Please written by computer source 1. Let's say you're a database designer for a logistics company. Your task is to design a database to store information about the company's trucks, drivers, shipments, and customers. (1) Each truck has a unique id, information about its make and model, and its capacity. Each shipment has a unique id, as well as information about its origin, destination, and weight. Each customer has a unique id and information about their name, address, and phone number. Each driver has a unique id and information about their name, license number, and level of experience. (2) A truck can transport one or more shipments, and each shipment can be transported by one or more trucks. A customer can have one or more shipments, and each shipment can belong to one customer. a driver can drive one or more trucks, and each truck can be driven by one or more drivers.
Please written by computer source
1. Let's say you're a
to store information about the company's trucks, drivers, shipments, and customers.
(1) Each truck has a unique id, information about its make and model, and its capacity.
Each shipment has a unique id, as well as information about its origin, destination, and
weight. Each customer has a unique id and information about their name, address, and
phone number. Each driver has a unique id and information about their name, license
number, and level of experience.
(2) A truck can transport one or more shipments, and each shipment can be transported
by one or more trucks. A customer can have one or more shipments, and each shipment
can belong to one customer. a driver can drive one or more trucks, and each truck can be
driven by one or more drivers.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
