Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have been employed by Safety First Insurance (SFI) company. SFI is an insurance broker working out of Fiji. Based on the Safety First

You have been employed by Safety First Insurance (SFI) company. SFI is an insurance broker working out of Agent PK agent id first name last_name user_name phone Customer agent PK id PK,FK1 agent id PK,FK2 cust id

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

SQL CREATE TABLE Statement CREATE TABLE tablename column1 datatype column2 datatype column3 datatype ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Smith and Roberson Business Law

Authors: Richard A. Mann, Barry S. Roberts

15th Edition

1285141903, 1285141903, 9781285141909, 978-0538473637

More Books

Students also viewed these Databases questions

Question

What other market-based approaches to pricing could it take?

Answered: 1 week ago

Question

Distinguish between public and private law.

Answered: 1 week ago