Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone solve this for me? I wanna check if my answer is correct or no Create an ER Diagram of a Car Shop: A

Can someone solve this for me? I wanna check if my answer is correct or no

Create an ER Diagram of a Car Shop:

A car shop needs to design a database to collect and manage its car operations. The shop has employees who are either Salesmen responsible for selling/buying cars to Clients or Mechanics responsible for performing car repair jobs. The database needs to store information about the employees and their operations. Any repair job is performed on one car only and is handled by a specific mechanic. Repair job information to be stored is repair job number, description of job, and cost which include both parts and work cost. Information collected about clients who sell/buy their cars includes ID, name, phone and address. Car information collected includes license, manufacturer, model, and year. Buy operations indicate price, date, and value. Sell operations indicate date, value, and commission.

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

Fundamentals Of Database Systems

Authors: Sham Navathe,Ramez Elmasri

5th Edition

B01FGJTE0Q, 978-0805317558

Students also viewed these Databases questions