Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Phase 1 of the project includes the design and ER diagramming for the narrative description below. Car Doctor needs a database to support its operations
Phase 1 of the project includes the design and ER diagramming for the narrative description below. Car Doctor needs a database to support its operations in its three locations in central Illinois. Customers bring vehicles in for repair. Car Doctor wishes to maintain records of all customers and their vehicles. Customers are identified by a unique customer number, customer name, address, and phone number. Vehicle data to be tracked include the vehicle identification number (VIN) of the car, its year, make, and model, license plate number, and license state. When a vehicle is repaired, a repair order is created in the database. The repair order will include a repair order number, date, car odometer reading, and VIN number. Each repair order may require multiple parts, and all parts used in each repair order along with the respective quantities of use will need to be recorded. (For example, an oil change may require one oil filter, five quarts of 5W-30, and other supplies.) Each of the three branch locations needs to keep track of the different car parts stored at its location, including a unique part number, part name, cost, the size, and the quantity in stock. Though Car Doctor wishes to keep records of its inventory for each branch, it currently does not feel the need to track which customers and vehicles come to which branch since all three locations will be using the same database
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started