Database course

Write SQL DDL corresponding to the following schema. Make any reasonable assumptions about data types, and be sure to declare primary and foreign keys.

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

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)

owns (driver_id, license)

participated (report_number, license, driver id, damage amount)