Answer to Question #259423 in Databases | SQL | Oracle | MS Access for Novella

Question

Exercise: Auto Repair

• You are designing a database for an automobile repair shop. When a customer brings in a vehicle, a service advisor will write up a repair order. This order will identify the customer and the vehicle, along with the date of service and the name of the advisor.
• A vehicle might need several different types of service in a single visit. These could include oil change, lubrication, rotate tires, and so on.
• Each type of service is billed at a pre-determined number of hours work, regardless of the actual time spent by the technician.
• Each type of service also has a flat book rate of dollars-per-hour that is charged.
• Describe each entity in English.
• Describe each association in English (both directions).
• Draw the entity diagram, including association entities if required.

Answer 1

Repair Order class has the following attributes.

Customer-> Customer Name- Datatype string

Vehicle -Datatype string

ServiceNames->Has string datatype. This is also a foreign key.

Advisor-Has string as the datatype. The advisor details

OrderStatus-Has a string as the datatype.

Amount- This is the amount for the service.

The class can have the following functions:

addOrder: Use to add orders;

orderCompletion: Use to indicate when a vehicle has been serviced.

totalCost: Use to calculate the total amount for the service.

Cost Class;

The class has the following attributes:

ServiceName: Has the string as the data type and is the primary key of the class.

Number of hours: Total time time taken to service the vehicle

The class can have the following functions:

addNewService- For adding a new vehicle service.

updateCost: Used to update the cost of the service.