DBMS - Program 6 - Insurance Database
6. INSURANCE DATABASE Consider the Insurance database given below. The primary keys are underlined and the data types are specified. PERSON (Driverld: text; Name: text; Address: text) CAR (RegNo: text; Model: text; Year: number) OWNS (DriverId: text; RegNo: text) ACCIDENT (ReportNo: number, AccDate: Date; Location: text) PARTICIPATED (DriverId; text; RegNo: text; ReportNo; number, Dmg_Amt:number (10, 2)) a) Create the above tables by specifying the primary and foreign keys. b) Enter at least five tuples for each relation c) Update the damage amount for each car accident. d) Add a new accident to the database. e) Find the total number of people who owned cars that were involved in accidents in the year 2002. f) Find the number of accidents in which cars belonging to a specific model were involved. g) Display the owners and their car deta ils. Cre
Comments
Post a Comment