Question: Draw an ERD representing the database for Ace. M:N relationships, if any, must be decomposed. Ace Auto Repair needs a database that will support the

Draw an ERD representing the database for Ace. M:N relationships, if any, must be decomposed. Ace Auto Repair needs a database that will support the daily operations of a small repair shop Customers bring vehicles in for repair. Each repair may require multiple parts, and the repair shop tracks all the parts needed for each repair order. To support marketing efforts, a list oif customers and vehicles is maintained. If a repair order is for a new customer or vehicle, that information is added to the database. To facilitate inventory, a list of parts is maintained. Ace Auto wishes to track the following customer information: customer name, a unique customer number, customer address, and phone number. Vehicle data to be tracked include the vehicle identification number (VIN) of the car, its year and model, the license number, the state, and the number of cylinders. To track inventory, Ace Auto maintains data about car parts, including a part description, the unique part number, the cost, the size, and the quantity in stock. When a vehicle is repaired, a repair order is tracked in the database. The repair order will include a repair order number, date, car odometer reading, and VIN number
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
