Problem (4): Car dealership Jim Smith's dealership offers a range of vehicles, including Ford, Honda, and Toyota models. The dealership maintains a database of information on vehicles, models, manufacturers, and customers. Car manufacturers provide the dealership with their contact details, such as name, sales representative name and, phone number, address, and email, to facilitate easy communication. Each manufacturer supplies one or more models to the dealership, with each model being specific to a particular brand. For each model, the dealership keeps detailed records, including the list price, the price paid to obtain the model, and the model name and series (such as Honda Civic LX). Specific information is stored for each vehicle, including the identification number, model name, and color(s). While several vehicles of the same model are available, each vehicle is associated with only one model. Customers may purchase multiple cars, but each car is owned by only one customer. The dealership also maintains customers' information. Employees record the customer's name, the car(s) purchased, and the amount paid for each car. In addition, the dealership stores the customer's contact information, such as their address, phone number, and email address, to enable future communication