Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions