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. [3 points] (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.