Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please draw the Entity - Relationship Diagram, including the entity types and relationship types ( including attributes ) , for the following scenario. Jos Automotive

Please draw the Entity-Relationship Diagram, including the entity types and relationship types (including attributes), for the following scenario.
Jos 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 Jos Automotive.
NOTE:Please follow the naming convention (including the letter case) and use the symbol discussed in class. The names of the relationship types should be unique.Please make sure the key attribute(s) for each entity type is defined.Please make sure the cardinalities for relationship types (on both ends) are specified.You can use any software to draw the ERD or draw it by hand and scan (take a photo of) the diagram.

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

Database Management With Website Development Applications

Authors: Greg Riccardi

1st Edition

0201743876, 978-0201743876

More Books

Students also viewed these Databases questions

Question

If you have a short RTO, what type of replication might you use?

Answered: 1 week ago