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 class in english.

draw the class diagram, including association classes if required.

describe each association in english (both directions).

draw the relation scheme.