Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Add a new accident to the database; assume any values for the required attributes. Update all involved tables. 2) Delete the Toyota cars from

1) Add a new accident to the database; assume any values for the required attributes. Update all involved tables.

2) Delete the Toyota cars from the database. Update all involved tables.

3) Increase by 10% the damage amount for all cars that have been involved in accidents during 2009. List the changed tuples from the Participated table, after the update.

image text in transcribed

person (driver id, name, adress) car (license, model, year) accident (rabortw accident date, location) participated (pot r, license, driver jid damage amb Consider the instance of this relational database shown in Tables 1- 5 below. Use your Oracle account to create this database and populate the tables; a script is provided on Canvas for this purpose (file hn4_db.sa) Person Tabhle 2: Car Name Year Model Honda Toyota Universi Rubens Barrichelo 1st Ave Scbastian Vettel Mark Webber Lewis Hamilton Felipe Massa SZM813 SZM814 SZM815 SZM816 SZM817 SZM818 SZM819 SZM820 2009 1st Ave 1st Ave 1st Ave Univ 2008 2008 2008 2008 Honda BMW Toyota Table 3: Owns Tahle 4: Accident SZM813 SZM814 SZM815 SZM816 SZM817 SZM818 SZM819 SZM820 R01 RO2 R03 04-13-2008 07-22-2008 07-22-2008 07-22-2008 07-27-2008 01-27-2009 Highland Heights 02-15-2009 Indiana New Yorlk New Yorlk R05 R06 ROT Tabe 5: Participated R01 R02 R03 RO4 R05 R06 ROT RO4 R05 R06 ROT ROT ROT SZM813 0 SZM814 1 SZM815 4 SZM814 1 SZM817 4 SZM818 5 SZM819 0 SZM817 4 SZM813 0 SZM814 3 SZM814 1 SZM820 4 SZM813 3 6000 1000 Important: in the table Participated, the Driver id column records the id of the person who drove the car involved in an acciden from or the same as the person owning the car 5000 3000 t - this person could be different 1000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database In Depth Relational Theory For Practitioners

Authors: C.J. Date

1st Edition

0596100124, 978-0596100124

More Books

Students also viewed these Databases questions