Construct an E-R diagram for a car-insurance company whose customers own one or more cars each....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Construct an E-R diagram for a car-insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. driver-id address person name driver owns license Car insurance tables: person (driver-id, name, address) car (license, year, model) model car year participated damage-amount report-number (b) Construct appropriate tables for the above ER Diagram? accident (report-number, date, location) participated (driver-id, license, report-number, damage-amount) accident location date 1. Create tables with necessary primary and foreign key. 2. Insert values in person table not allowing iver_id with any negative value. 3. Insert values in car table with default year as "2020". 4. Insert values in accident table with default location as "usa". 5. Make sure the car table with year column will not allow value/year less than 1960. Construct an E-R diagram for a car-insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. driver-id address person name driver owns license Car insurance tables: person (driver-id, name, address) car (license, year, model) model car year participated damage-amount report-number (b) Construct appropriate tables for the above ER Diagram? accident (report-number, date, location) participated (driver-id, license, report-number, damage-amount) accident location date 1. Create tables with necessary primary and foreign key. 2. Insert values in person table not allowing iver_id with any negative value. 3. Insert values in car table with default year as "2020". 4. Insert values in accident table with default location as "usa". 5. Make sure the car table with year column will not allow value/year less than 1960.
Expert Answer:
Answer rating: 100% (QA)
Answer Solution TablePerson Person driverid name address Pri... View the full answer
Related Book For
Posted Date:
Students also viewed these electrical engineering questions
-
The resuts of a sieve analysis for a soil sample are given in the Table. Cc = 0.5 and C = 5. If the LL and the PL of the soil sample are 55 and 40 respectively, classify the soil according to USCS...
-
Old MathJax webview from his next door neighbour, Jono, by telling him that he was 20 years old and had a good, stable income. The loan was payable in three equal fortnightly payments. After the...
-
Old MathJax webview Take any 2 logistics companies in the market. Download their 3-year Income statement and Balance Sheet. After that convert, these income statements into Common size income...
-
For publicly traded companies, the Sarbanes-Oxley Act prescribes fines and prison time for knowingly falsifying financial information. Further, investors of the company may be able to successfully...
-
1. As the total output of a constant-cost industry increases, ________the cost does not change, so the long-run supply curve is _______ (horizontal/ positively sloped/negatively sloped). 2. A...
-
The precision and accuracy hold a lot of value in measuring for quality control in project management to which both assist in forming the direction of the process ensuring that end product or service...
-
Review Kelly Long Travel Designs trial balance. Assume that Long accidentally listed dividends as \($100\) instead of the correct amount of $1,000. Requirement 1. Compute the incorrect trial balance...
-
Alisha Incorporated manufactures medical stints for use in heart bypass surgery. Based on past experience, Alisha has found that its total maintenance costs can be represented by the following...
-
In terms of test data, what specific physical parameter(s) should this test measure (or determine) during each individual trial and what specific tool( s) will enable data collection?
-
1. Does the amount of purifier have a significant effect on yield, according to this regression analysis? Based on this alone, would you be likely to recommend including a purifying step in the...
-
Download the annual report of Meezan Bank limited for the year 2020 and explain its primary financial statements. Also, explain the key financial ratios. How does it differ from a conventional bank?
-
An organizations demographics are an important factor to consider for its business strategies. Review the demographic and technological information about your company to complete the activity below....
-
6. Julia wants to pay off her $23 000 loan early. It is due in 4 years. A creditor is willing to discount the loan at 3.25%, compounded monthly. How much would the creditor be willing to accept today...
-
Consider the following. (a) Find aw s aw at (b) Find aw s w at w = x cos(yz), x = s, y = t, z =s - 2t aw aw by using the appropriate Chain Rule. (Enter your answers in terms of s and t.) s at aw s...
-
You have been requested, as a consultant, to help an organization improve the injection molding p You decided to run a multi-variable analysis to determine where you should focus your improvem The...
-
Logan Company owns equipment that cost $140,000 when purchased on January 1, 2018. It has been depreciated using the straight-line method based on estimated salvage value of $14,000 and an estimated...
-
A car drives north for 100m, stops at a stop sign, and then continues north another 500 m. What is the car's resultant displacement (include direction! ) 2 answers
-
1) Predict the organicproduct formed when BzCl reacts with cyclohexanol. BzCl = benzoylchloride. 2) Provide the majororganic product of the reaction below. 3) Draw the structureof the product formed...
-
Write a query to find cumulative balances, equivalent to that shown in Section 22.2.5, but without using the extended SQL windowing constructs.
-
Show, by giving a DTD, how to represent the books nested-relation from Section 9.1, using XML
-
The indexed nested-loop join algorithm described in Section 13.5.3 can be inefficient if the index is a secondary index, and there are multiple tuples with the same value for the join attributes. Why...
-
For the system methanol (1)-methyl acetate (2), the activity coefficients for components 1 and 2 are represented by where \[ \begin{aligned} \ln \gamma_{1} & =A x_{2}^{2} \quad \text { and } \quad...
-
Deduce the Gibbs-Duhem-Margules equation for a binary solution starting from Raoult's law.
-
The vapour pressure of acetone, acetonitrile and nitromethane can be represented by Antoine equations as \[ \begin{aligned} & \ln P_{1}^{\text {Sat }}=14.3916-\frac{2795.82}{T+230.0} \\ & \ln...
Study smarter with the SolutionInn App