Question Part (50 points) Question 1 (25 points) Design an ER-diagram for an automobile company to provide to its dealers to assist them in maintaining customer records and dealer inventory and to assist sales staff in ordering cars. Each vehicle is identified by a vehicle identification number (VIN). Each individual vehicle is a particular model of a particular brand offered by the company (e.g., the XF is a model of the car brand Jaguar of Tata Motors). The data held on each customer is id, name, address, and the telephone number. The data held on each dealer is id, name, address. Each vehicle can be owned by at most one customer. The database needs to store information about models, brands, and vehicle. Draw an ER diagram for this application. Specify key attributes of each entity type, and structural constraints on each relationship type. Note any unspecified requirements, and make appropriate assumptions to make the specification complete