Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Central Repairs is a new motor repairs facility set up this year. It needs to store data on all cars and owners that pass

 

Central Repairs is a new motor repairs facility set up this year. It needs to store data on all cars and owners that pass through its premises as well as details of all mechanics that work there. It also has to keep records on work carried out that may have been issued to each vehicle. The repairs facility wishes to store the following data about the Owners, Owner ID, Owner name, address, and contact number. For each mechanic, it wishes to store ID number, name, and year of qualification. address and contact number. For each car it requires the following information to be stored its registration number colour, engine capacity, and manufacturer. For each Repair, it requires to store Repair ID, Fixed/Not Fixed, and Cause of fault. When the car is repaired, an invoice of work completed is assigned to the repair. Thus only one repair can generate one invoice and each invoice is generated by one repair. If the car cannot be repaired, no invoice will be created. For each Invoice, it stores Invoice ID, Invoice Date, Invoice Details and Amount. Each invoice needs to be signed off by an employee. There are a number of mechanics working on a particular car repair and each mechanic could work on one or more than one cars each day. (a) List the entities present in the above specification. (b) (c) (d) List the relationships that exist between these entities? Draw an Entity Relationship (ER) diagram to represent the above scenario. Develop a relational schema for your ER diagram. (2.5 marks) (2.5 marks) (10 marks) (10 marks) Total (25 marks)

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

International Marketing And Export Management

Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr

8th Edition

1292016922, 978-1292016924

More Books

Students also viewed these Databases questions

Question

What are the parameters in a simple linear regression model?

Answered: 1 week ago

Question

How is the NDAA used to shape defense policies indirectly?

Answered: 1 week ago