Central Repairs is a new motor repairs facility set up this year. It needs to store...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Related Book For
International Marketing And Export Management
ISBN: 9781292016924
8th Edition
Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr
Posted Date:
Students also viewed these databases questions
-
Required information [The following information applies to the questions displayed below.] Knickknack, Inc. manufactures two products: Odds and Ends. The firm uses a single, plantwide overhead rate...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The root cause of underdevelopment and environmental degradation is the overdevelopment of a handful of rich nations. Discuss.
-
Consider the following four-year project. The initial outlay or cost is $180,000. The respective cash inflows for years 1, 2, 3 and 4 are: $110,000, $80,000, $80,000 and $20,000. What is the payback...
-
Why do ethical lapses occur in businesses?
-
Will a company with ample growth opportunities tend to issue short-term, mediumterm or long-term debt? Why?
-
The volume of a dry box (a closed chamber with dry nitrogen flowing through it) is 2.0 m3. The dry box is maintained at a slight positive gauge pressure of 10 cm H2O and room temperature (25C). If...
-
Presidential Poll. A research group suspects that less than 47% of Americans support the Republican presidential candidate. To test this claim, they randomly call Americans until they get 1000...
-
Assume that all individuals have identical preferences but some individuals are wealthier than others. Assume there is a single public good and a single private good. a. Show diagrammatically how you...
-
Please show work. Question 7 of 13 10 Points George is in contract negotiations with a publishing house for his new autobiography. He has two options. With option 1, he would receive $250,000 up...
-
You have been hired as a controller of Hughes Co., a small but growing business that manufactures high-end electronics distributed through retail superstores. You plan to prepare the current-year...
-
Using Article 29 of Model Tax Convention, Part 3 of Multilateral Instrument and Base Erosion Profit Shifting, explains Principle Purpose Test Limitation of Benefit Simplified Limitation of Benefit...
-
What ethical responsibilities do stakeholders, including corporations, governments, and individuals, bear in mitigating the risks associated with the globalization of technological innovation ?
-
Express the following first-order system as a single higher-order differential equation and solve using the given initial conditions. Make sure to change the initial conditions appropriately....
-
Recently, the topic of CEO compensation has been in the news. The challenges are that CEO's are compensated quite well and often without regard for the health, profitability, and sustainability of...
-
Talk about the Johnny Depp vs. Amber Heard trials and the societal damage we faced because of it. (trials being grossly filmed for entertainment purposes, viral on tik tok, youtube and more), abuse,...
-
The text defined intrinsic value as the value of an asset given a hypothetically complete understanding of the assets investment characteristics. Discuss why hypothetically is included in the...
-
The Woberg Company, located near Aarhus, Denmark, manufactured dishwashers and garbage pulverizers for home use, and cooking equipment and commercial pulverizers for restaurants. A relatively young...
-
Under what conditions would a strategy of multiple entry modes be most appropriate and under what conditions would it be inappropriate? Discuss.
-
Can an exporter realistically follow the strategy of product phasing when replacing a product in the product line being exported to a foreign market? Explain.
-
Given the probabilities of expected states of the economy shown here, and the expected returns to stocks A and B in those states, what is the standard deviation of a portfolio with weights of 40...
-
The controller of Getty Industries has collected the following monthly expense data for use in analysis the cost behavior of maintenance costs. Instructions (a) Determine the fixed and variable cost...
-
Stock W has an expected return of 12.4 percent and a beta of 1.8. If the expected market return is 10 percent, what is the risk-free rate? a. -5.6% b. 3.0% c. 5.6% d. 7.0%
Study smarter with the SolutionInn App