We want to design a database for a local garage. For each customer, we want to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
We want to design a database for a local garage. For each customer, we want to record the (unique) name, the customer address, and the contact phone number. For each vehicle, we want to record the unique vehicle's identification number (VIN), and the vehicle's make, model and year. For each repair job we want to record the description of the job done (maximum 200 chars), the date, and the total dollar cost. A repair job may involve zero or more parts (like, e.g., "windshield wipers", "battery", etc.) For each part we want to record its (unique) part number, the part name and its cost. In addition, note that: Each vehicle may have 1 or more repair jobs. Each customer may be the primary owner of 1 or more vehicles. Every vehicle has only one primary owner (we ignore co-owners) Draw an ER diagram for this database. Make sure to indicate primary keys, cardinality constraints, weak entities (if any), and participation constraints. List any assumptions you make in the process. We want to design a database for a local garage. For each customer, we want to record the (unique) name, the customer address, and the contact phone number. For each vehicle, we want to record the unique vehicle's identification number (VIN), and the vehicle's make, model and year. For each repair job we want to record the description of the job done (maximum 200 chars), the date, and the total dollar cost. A repair job may involve zero or more parts (like, e.g., "windshield wipers", "battery", etc.) For each part we want to record its (unique) part number, the part name and its cost. In addition, note that: Each vehicle may have 1 or more repair jobs. Each customer may be the primary owner of 1 or more vehicles. Every vehicle has only one primary owner (we ignore co-owners) Draw an ER diagram for this database. Make sure to indicate primary keys, cardinality constraints, weak entities (if any), and participation constraints. List any assumptions you make in the process.
Expert Answer:
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1337627900
13th edition
Authors: Carlos Coronel, Steven Morris
Posted Date:
Students also viewed these programming questions
-
Population 65 and Older Suicide Rate Low High TOTALS Low 45 20 65 High 10 25 35 TOTALS 55 45 100 A. High Unemployment Population 65 and Older (%) Suicide Rate Low High TOTALS Low 23 10 33 High 5 12...
-
Design a database by analysing the requirements for the scenario detailed on the following pages. State any assumptions/notes you have made regarding your database design at the beginning of the...
-
Give condition for tracking down the most likely arrangement of grammatical feature (POS) labels that could be used by a stochastic POS tagger. You ought to accept a bigram model. [5 marks] (b) Given...
-
In Pissarides's view of labor markets (job matching model), the focus is on finding a good ________. a. level of TFP (A) b. supply of money (M). c. match d. Wage
-
After two consecutive years of 10% losses, what rate of return in the third year will produce a cumulative loss of 30%?
-
Find the following areas under the standard normal curve. a. To the right of z = 3.18 P(z > 3.18) b. To the right of z = 1.84 P(z > 1.84) c. To the right of z = 0.75 P(z > 0.75)
-
The person who buys an option giving him or her the right to sell shares in an underlying stock at a prespecified price would be said to have: a. A long call position b. A short call position c. A...
-
The bookkeeper for Fred Kelley??s dance studio made the following errors in journalizing and posting.1. A credit to Supplies of $600 was omitted.2. A debit posting of $300 to Accounts Payable was...
-
Susan Company has gathered the following information about its product. Direct materials: Each unit of product contains 4.5 pounds of materials. The average waste and spoilage per unit produced under...
-
Trail Runner guarantees its snowmobiles for three years. Company experience indicates that warranty costs will be approximately 5% of sales. Assume that the Trail Runner dealer in Colorado Springs...
-
ABC Company purchased an equipment for $36,000. It estimated a 6-years useful life and a salvage value of $6,000 The company used the Straight-Line Method. At the end of the third (3rd) year, the...
-
Fig (below) has a log scale for the pressure p and a linear scale for the altitude z, implying that p(z) = p. exp(-z/H), where po is the surface pressure and H is the scale height. Use the endpoints...
-
There are two types of bonds available in the market: a 4-year bond A with annually paid coupon rate of 30% selling at a yield to maturity of 30%. and a 4-year zero-coupon bond B selling at a yield...
-
A 10-ft ladder, whose base is sitting on level ground, is leaning at an angle against a vertical wall when its base starts to slide away from the vertical wall. When the base of the ladder is 6 ft...
-
In the best case scenario for a gravity boost, a spacecraft approaches a planet very closely and does a U-turn around it, heading back exactly in the direction it came (see the image below). Before...
-
how the implementation of Balance Score Card can be used as a monitoring technique and TQM as an improvement technique for the overall enhancement of a company performance
-
On October 31 Juanita Ortega, owner of Outback Guide Service, received a bank statement dated October 30. Juanita found the following: 1. The checkbook has a balance of $2,551.34. 2. The bank...
-
Lomax Companys Statement No. 69 disclosures included the following information: REQUIRED: Using the information for Lomax Company in problems 13, 14, and 15 and in this problem: a. Compute the value...
-
Lomax Company reported the following expenses in its financial statements (in thousands): REQUIRED: Using the reserve disclosure for Lomax Company given in problem 13 and the data presented in this...
-
Discuss the ratios computed for Lomax Company in problems 13, 14, 15, and 16. What is your assessment of the performance and future potential of Lomax Company? Problems 13 The following reserve table...
Study smarter with the SolutionInn App