Homework 3 Automobile Dealership Draw an enhanced…

MateMeerkatMaster783 Homework 3 Automobile Dealership Draw an enhanced…Homework 3 Automobile Dealership Draw an enhanced entity-relationship diagram for the following case. Major Auto is a nationwide chain of automobile dealerships that sells and services cars and light trucks. It wants to develop a new information system that will help it manage the vehicles it has for sale and its employees. Each dealership has a unique dealer number and Major Auto also must record each dealership’s address and phone number. Each vehicle has a unique vehicle id number (VIN) plus the system must record the date it was manufactured and the date it was delivered to the dealership. There are several kinds of vehicles, three of which are sedans, SUVs, and trucks, but there are others, as well. A vehicle can fall into only one of these categories. For each sedan, the system must track its length and weight. Furthermore, there are (only) two kinds of sedans: hardtops and convertibles. A sedan can only be one of these two kinds. For hardtops, the system must record their list price; for convertibles the system must record their insurance class. For each truck, the system must track its emissions rating and its engine size. There are only two kinds of trucks: pickup trucks and vans, but they can both be used for some of the same purposes, such as making deliveries. For pickup trucks, the system has to store their bed (the open portion) length; for vans, the system has to store their cargo capacity. Each employee has a unique employee number, a name, and a cell phone. Three types of employees are salespersons, mechanics, and service advisors, but there are other types, too. An employee can serve in more than one of these capacities (for example, a service advisor may also work as a mechanic.) Major Auto wants to store each salesperson’s home address and office number. For mechanics, it wants to store their skill rank and date of hire. For service advisors it wants to store their age. Be clear while answering Arts & HumanitiesEnglish