Question: Please draw the Entity - Relationship Diagram, including the entity types and relationship types ( including attributes ) , for the following scenario. Jo's Automotive

Please draw the Entity-Relationship Diagram, including the entity types and relationship types (including attributes), for the following scenario.
Jo's Automotive needs a database to manage customer and service data. Each customer would provide first name, last name, phone number, and zip code. A customer can own many different vehicles, which are described by Vehicle Identification Number (VIN), make, model, color, year. Jo provides different services at the shop, such as oil change, lube job, tire rotation, etc. Each service would have a name, a number of labor hours, and a price. A vehicle may need different services over time, and a serviced can be provided to many different vehicles. Jo only keeps records for the vehicles that have been to the shop and received services. When a service is performed for a vehicle, the date and the mileage need to be recorded. Jo also provides smog check for vehicles. Each smog check record would include the date and time performed, and the test result; the test results include the levels of carbon monoxide, carbon dioxide, hydrocarbon, nitrogen oxide, and emission from evaporation. A vehicle can receive multiple smog check (at different time), and a smog check record is for only one vehicle. However, a vehicle in the shop may never receive any smog check at Jo's Automotive.
 Please draw the Entity-Relationship Diagram, including the entity types and relationship

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!