Question: Consider the insurance database of Figure, where the primary keys are underlined. Construct the following SQL queries for this relational database. a. Find the total

Consider the insurance database of Figure, where the primary keys are underlined. Construct the following SQL queries for this relational database.

a. Find the total number of people who owned cars that were involved in accidents in 1989.

b. Find the number of accidents in which the cars belonging to ?John Smith? were involved.

c. Add a new accident to the database; assume any values for required attributes.

d. Delete the Mazda belonging to ?John Smith?.

e. Update the damage amount for the car with license number ?AABB2000? in the accident with report number ?AR2197? to $3000.

person (driver-id, name, address) car (license, model, year) accident (report-number, date, location)

person (driver-id, name, address) car (license, model, year) accident (report-number, date, location) owns (driver-id, license) participated (driver-id, car, report-number, damage-amount)

Step by Step Solution

★★★★★

3.32 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The participated relation relates drivers cars and accidents a Find the total number of people who owned cars that were involved in accidents in 1989 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

16-CS-DB (134).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Instructions Norwegian Satellite Development Company (NSDC) Cost Estimates for World Satellite Telephone Exchange Project NSDC has a contract to produce eight satellites to support a worldwide...

Consider the relational database of Figure where the primary keys are underlined. Give expressions in QBE for each of the following queries: a. Find all employees who earn more than the average...

Consider the AIRLINE relational database schema shown in Figure 3.8, which describes a database for airline flight information. Each FLIGHT is identified by a flight NUMBER, and consists of one or...

Cars A and B are d = 60 m apart and are traveling respectively at the constant speeds of (vA)0 = 32 km/h and (vB)0 = 24 km/h on an icecovered road. Knowing that 45 s after driver A applies his brakes...

Consider the insurance database of Figure, where the primary keys are underlined. Construct the following QBE queries for this relational-database. a. Find the total number of people who owned cars...

Consider the relational database of Figure, where the primary keys are underlined. Give an expression in the relational algebra to express each of the following queries: a. Find the names of all...

PLEASE HELP ME WITH THIS I AM REALLY STRUGGLING AND THIS IS THE ONLY PROBLEM I HAVE LEFT AND CANNOT FIGURE IT OUT! SQL DATABASE THEORY IS THE COURSE! Consider the insurance database of Figure 3.18,...

Consider the insurance database of Figure 3.17, where the primary keys are underlined. Construct the following SQL queries for this relational database. a. Find the number of accidents involving a...

A.Consider the insurance database of Figure 3.17, where the primary keys are underlined. Construct the following SQL queries for this relational database. a. Find the total number of people who owned...

1. Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

All answers shall be typed using a word processor 1. (100 pts) Consider the insurance database of Fig 1, where the primary keys are underlined. Construct the following SQL queries for this relational...

DATE() - In the OrderHeaders worksheet, in cell AB2 use DATE() and find out how many days there have been since 1/1/1900 and 12/4/2020. Change the formatting to a number if the results from DATE() is...

Refer to the trial balance in Problem 3-13B and to the analysis of the change in owners equity in Problem 3-14B. REQUIRED 1. Prepare an income statement for Jantz Plumbing Service for the month ended...

Determine whether each of the following statements is true or false. If it is true, explain your reasoning. If it is false, give a counterexample. (a) If 6 is a factor of a number, then 2 and 3 are...

Create a new program that will ask a user to enter a number repeatedly. This program will calculate 2 averages based on the sign of the inputted numbers: ave_pos (average of all positive numbers) and...

Create a C++ program that fills 5 by 5 two-dimensional array with integer random numbers ranging from 0 to 99. Calculate the sum of each rows and columns of the array entries. Purpose of the program...

Ducati Redesigns Its Operations Company Overview Ducati Motor Holding manufactures motorcycles known worldwide for their precision engineering, lightning speed, and sleek design and for customers who...

Amazon.coms IT Patents Create Competitive Edge Entrepreneur and e-commerce pioneer Jeff Bezos envisioned the huge potential for retail sales over the Internet and selected books for his e-commerce...

Last year, the House of Orange had sales of $826,650, net operating income of $81,000, and operating assets of $84,000 at the beginning of the year and $90,000 at the end of the year. What was the...

The data in the file MoviePrices contain the price for two tickets with online service charges, large popcorn, and two medium soft drinks at a sample of six Ftheatre chains: $36.15 $31.00 $35.05...

Outline the key similarities and differences between the timestamp-based implementation of the first-committer-wins version of snapshot isolation, described in Exercise 18.15, and the...

As discussed in Exercise 18.15, snapshot isolation can be implemented using a form of timestamp validation. However, unlike the multi-version timestamp ordering scheme, which guarantees...

Suppose the lock hierarchy for a database consists of database, relations, and tuples. a. If a transaction needs to read a lot of tuples from a relation r, what locks should it acquire? b. Now...

The multiple-granularity protocol rules specify that a transaction Ti can lock a node Q in S or IS mode only if Ti currently has the parent of Q locked in either IX or IS mode. Given that SIX and S...

The snapshot isolation protocol uses a validation step which, before performing a write of a data item by transaction T, checks if a transaction concurrent with T has already written the data item....

2. Mrs. Quine takes out a 25-year mortgage for a loan of $1,400,000 at 12 = 5%. (a) Calculate the monthly payments required. (b) After 5 years, the interest rate increases to j2 = 5.5%, calculate the...