Structured query language | Database management systems homework help

1. Consider the following database”

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)

1. Write SQL DDL corresponding to the following schema. Make any reasonable assumptions about data types, and be sure to declare primary and foreign keys.
2. Find the number of accidents in which the cars belonging to “John Smith” were involved.
3. Update the damage amount for the car with the license number “AABB2000” in the accident with report number “AR2197” to $3000.

B   ASSIGNMENT (EmployeeNumber, ProjectNumber, ProjectName, HoursWorked)

Assume that ProjectNumber determines ProjectName and explain why this relation is not normalized.

Demonstrate an insertion anomaly, a modification anomaly, and a deletion anomaly.

Apply the normalization process to this relation.

State the referential integrity constraint.