Identify entity types from the following problem statement. No need to develop a complete ERD.

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 for each vehicle brought by a customer. In the shop, there are two service advisors. Customer may or may not be a royalty member of the shop. The repair 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.

Answer rating: 100% (QA)

Explanation The class has the following attributes Service name is a foreign key The service name mu... View the full answer