INSURANCE COMPANY

Design  a database for insurance company.Asume that following are the requirements that were collected:

An insurance company has different policies.Policies have pno,term_price and coverage.

Policies are categorized based on their types.There are two types:Auto_policy and Home_policy.

Policies for vehicles come under Auto policy.Auto_policy has pno,vehicle type and issue date.

Policies for house come under home policy.Home_policy has pno,issue date and term_price.

Customers take policies policy through policy agent.A customer can take only one policy .

ANSWER

ENTITIES:

1)Policy

2)Auto_policy

3)Home_policy

4)Vehicle

5)House

6)Customer

 

KEY ATTRIBUTES:

1)Policy: pno

2)Auto_policy: polno

3)Home_policy:policyno

4)House:hno

5)Vehicle: vehicle_no

6)Customer: custid

OTHER ATTRIBUTES:

1)Policy:price,coverage.

2)Auto_policy:type,issue_date

3)Home_policy:date,term_price

4)House:name

5)Vehicle:model

6)Customer:address,phno

 

RELATIONSHIPS:

 

Image

 

ER DIAGRAM:

 

Image

 

 

 

Advertisements