(Solved) : 45 Consider Following Car Insurance Schema Person Driverid Name Address Car Licence Model Q44092613 . . .
45 Consider the following car insurance schema: person (driver_id, name, address) car(licence, model, year) accident report number, date, location) owns (driver_id, licence-plate) participated (report number, licence plate, driver_id, damage_amount) Write SQL queries to: a Find the number of accidents involving a car belonging to a person named “Ahmed El-Roby”. (3 marks) b Update the damage amount for the car with licence plate “DB007” in the accident with report number “AR2020” to $3000. (2 marks) Show transcribed image text 45 Consider the following car insurance schema: person (driver_id, name, address) car(licence, model, year) accident report number, date, location) owns (driver_id, licence-plate) participated (report number, licence plate, driver_id, damage_amount) Write SQL queries to: a Find the number of accidents involving a car belonging to a person named “Ahmed El-Roby”. (3 marks) b Update the damage amount for the car with licence plate “DB007” in the accident with report number “AR2020” to $3000. (2 marks)
Expert Answer
Answer to 45 Consider the following car insurance schema: person (driver_id, name, address) car(licence, model, year) accident rep…
OR