Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started