You have been employed by Safety First Insurance (SFI) company. SFI is an insurance broker working...

 

Transcribed Image Text:

You have been employed by Safety First Insurance (SFI) company. SFI is an insurance broker working out of Fiji. Based on the Safety First Insurance ERD diagram you have been tasked with creating a database that will capture the basic structure given in the ERD. SFI will also require some reports for strategic decision making and improving efficiency of daily operations. To achieve this you are required to: 1. Use DDL to create the table structures and populate them. 2. Use DML to create queries that will facilitate extraction and presentation of required information. Agent PK agent id first name last_name user_name phone Customer agent PK id PK,FK1 agent id PK,FK2 cust id Policy payment PK id PK,FK2 policy id O PK,FK1 pay id date Payment PK pay id number amount Property PK prop id cost type PK HPK,FK1 Works at HH id agent id PK,FK2 add id Policy PK policy id policy_num type coverage HH term_price deductible issued_date Property policy PK,FK1 policy id Covers property PK id PK,FK1 policy id PK,FK2 prop id Address PK add id #H street_address state city zip Customer PK cust id first_name last_name dob age phone ssn di num HH HO Policy holder PK id PK,FK1 policy id PK,FK2 cust id Auto policy PK,FK1 policy id Covers car PK id PK,FK1 policy id PK,FK2 car id Lives in PK id +PK,FK1 cust id PK,FK2 add id Had accident PK id PK,FK2 acc id FK2 FK1 cust_id is_fault Accident PK acc id report num date Was in accident PK id PK,FK1 acc id car_id damage cost Car HPK car id model plate color year. doors You have been employed by Safety First Insurance (SFI) company. SFI is an insurance broker working out of Fiji. Based on the Safety First Insurance ERD diagram you have been tasked with creating a database that will capture the basic structure given in the ERD. SFI will also require some reports for strategic decision making and improving efficiency of daily operations. To achieve this you are required to: 1. Use DDL to create the table structures and populate them. 2. Use DML to create queries that will facilitate extraction and presentation of required information. Agent PK agent id first name last_name user_name phone Customer agent PK id PK,FK1 agent id PK,FK2 cust id Policy payment PK id PK,FK2 policy id O PK,FK1 pay id date Payment PK pay id number amount Property PK prop id cost type PK HPK,FK1 Works at HH id agent id PK,FK2 add id Policy PK policy id policy_num type coverage HH term_price deductible issued_date Property policy PK,FK1 policy id Covers property PK id PK,FK1 policy id PK,FK2 prop id Address PK add id #H street_address state city zip Customer PK cust id first_name last_name dob age phone ssn di num HH HO Policy holder PK id PK,FK1 policy id PK,FK2 cust id Auto policy PK,FK1 policy id Covers car PK id PK,FK1 policy id PK,FK2 car id Lives in PK id +PK,FK1 cust id PK,FK2 add id Had accident PK id PK,FK2 acc id FK2 FK1 cust_id is_fault Accident PK acc id report num date Was in accident PK id PK,FK1 acc id car_id damage cost Car HPK car id model plate color year. doors

Answer rating: 100% (QA)

SQL CREATE TABLE Statement CREATE TABLE tablename column1 datatype column2 datatype column3 datatype ... View the full answer