Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started