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
-
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.
-
1) Given an expected market return of 12.0%, a beta of 0.75 for Benson Industries, and a risk-free rate of 4.0%, what is the expected return for Benson Industries? A) 9.0% B) 10.0% C) 4.0% D) 13.0%...
-
Rand Medical manufactures lithotripters. Lithotripsy uses shock waves instead of surgery to eliminate kidney stones. Physicians Leasing purchased a lithotripter for $3,000,000 and leased it to...
-
Table 2.2 provides an example of 400 parts classified by surface flaws and as (functionally) defective. For this table, the conditional probabilities match those discussed previously in this section....
-
Cook Corporation manufactures plastic garbage cans. In a typical year, the firm produces between 40,000 and 50,000 cans. At this level of production, fixed costs are $10,000 and variable costs are $2...
-
Blue Mountain Hardware is adding a new product line that will require an investment of $1,510,000. Managers estimate that this investment will have a 10-year life and generate net cash inflows of...
-
f. If there were $800 of dividends declared but not yet received by Maloney Co's from their investments, what adjustment would need to be made to Maloney's revenue?
-
Suppose Sam and Cory are married and are deciding whether to use the filing status of Single or of Married filing jointly. Cory has a taxable income of $50,000 and Sam has a taxable income of...
-
You are given the following data set: -[4-[] = You would like to use PCA to find a 1-dimensional representation of the data. a. Plot the data set. b. Compute the feature covariance matrix S. c. You...
-
Jackie is buying a new car for $23,000. She would like to add options that cost $752.00. In her state, she is required to pay a $25.00 registration fee, $20.00 for a car license, and 7% sales tax....
-
what ways does the international dissemination of Conceptual art challenge cultural hegemony and Eurocentric perspectives within the global art discourse, fostering a more inclusive and diverse...
-
How does the philosophical underpinning of Conceptual art challenge traditional notions of aesthetics and artistic production ?
-
Your favorite algebra teachers are packing presents for the toy drive. Ms. May, Ms. Kirkland and Mr. Virgil pack 3 boxes of Barbies and 4 boxes of Kens for a total of 30 toys. Ms. Shead, Ms. Knight...
-
2. Patricia Johnson owns and operates CraneCakes, a bakery that creates personalized birthday cakes for a child's first birthday. The cakes, which sell for $40 and feature an edible picture of the...
-
Complete problem P10-21 using ASPE. Data from P10-21 Original cost ................................................................. $7,000,000 Accumulated depreciation...
-
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.
-
Let \(X \stackrel{\text { law }}{=} \mathcal{N}\left(m, \sigma^{2} ight)\) and \(\lambda>0\). Prove that \[\mathbb{E}\left(e^{-\lambda X^{2}} ight)=\frac{1}{\sqrt{1+2 \lambda \sigma^{2}}} \exp...
-
Let \(M\) be an \(\mathbf{F}\)-martingale and \(Z\) an adapted (bounded) continuous process. Prove that, for \(0
-
Give another proof that \(\lim _{t ightarrow \infty} M_{t}=0\) in the above Example 1.2.1.7 by using \(T_{-a}=\inf \left\{t: W_{t}=-a ight\}\). Example 1.2.1.7: The martingale \(M_{t}=\exp...
Study smarter with the SolutionInn App