Analyze the entire application for Woodys Automotive and compose with an Extended ER diagram. Use the notation for E/R model constructs and additional notation for specialization/generalization hierarchies. Woody Randolph owns a chain of 5 auto repair shops in Northern New Jersey and has plans to expand across the state. Woody wants an on-line system to help him manage his growing company. The company wants to build a database system for customers, employees, and service transactions. You have been approached to help Woodys Automotive with the database design and application development. 1. Each customer has an ID, name, home address, a telephone number, an email address, and a credit card for payment. 2. Each customer has one or more vehicles. Each vehicle has a type (sedan, SUV, sports car, truck), manufacturer, model, color, and year. 3. Woodys Automotive offers a list of maintenance and repair services: a. Oil changes b. Front-end alignments c. Brakes d. Tire repairs and replacements e. Engine tune-ups f. Vehicle computer diagnostics g. State vehicle inspections 4. All services have a price for labor, which are based on the service and the vehicle type, and additional charges for parts. 5. Woodys wishes to maintain an inventory of parts at each location. Each part has a name and a retail price. 6. Prices for service labor and parts can be changed by management at any time using the on-line application. However, the price for labor and parts is fixed at the time a service appointment is made and cannot be changed. Those prices are recorded in the invoices and used for management reports 7. Customers will be able to self-register and make service appointments at the repair shop of their choice using the on-line system. 8. Customers will be able to track the current status of their service appointments waiting, in progress, waiting for parts, complete, etc. 9. Once service is complete, an invoice is generated and paid for via customer credit card and recorded in the database. Transactions include a complete record of the service provided, including labor and parts charges, the total charge, the shop location, the technician, the customer and vehicle, and the date of service. 10. Each Woodys Automotive repair shop location has a manager and between 4 and 6 repair technicians. The database will record the name, location, role, and start date for each manager and technician. 11. Each technician has the skills to perform one or more of the repair services that the company offers. The database needs to record the skills for each technician. 12. Each morning the location manager must print out a report of the services scheduled to be performed that day.