Safe Drive Insurance is a well$-$established car insurance company that provides a variety of

products for individuals and businesses. As a database designer, you are assigned to design a

data model for the car insurance policy application system.

Below are some of the highlights that you need to consider:

There are two types of insurance policies: comprehensive and third$-$party.

The policyholder must be above $18$ years old and have a driving license.

The policyholder's record contains policyholder ID$,$ policyholder's last name, and

so on$.$

Each policyholder can have one or more vehicles.

The policyholder can purchase single or multi$-$car policies, and the policies can be

for personal or commercial use.

Based on the information above, create a simple database application for the Insurance

company. The system keeps track of their customers and policy information made in the past.

The application can be built using command line interface and manipulated with SQL$.$ The

data creation, viewing and manipulation $($insert$,$ update, and delete$)$ are conducted through

the command line interface. You are encouraged to apply some extra SQL commands to

prettify your generated tables.

Database Design Process

Convert your ERD into relational schema. You are allowed to update the previous ERD

design from Assignment $1$ with justifications.

Re$-$examine the database structure and perform normalization $(1$NF$,2$NF$,3$NF$)$ to eliminate

anomalies in the database design.

Minimum requirements:

The application must be able to store all relevant data of your main entities. i$.$e$.$ policy

holders, policy, vehicle data, etc.

Can add, update, delete and view policies requests.

Can create, update, and delete vehicles requests.

Can add new and update Policy Holders and details.

Fill in minimum $5$ rows of sample data$/$records in all the normalized tables. You may use all

available data from your Assignment $1.$

Manipulate the data and generate the following:

a$.$ All Policy Holders list

b$.$ All Policies.

c$.$ All Towing assignments.

d$.$ Simple reporting for:

i$.$ Monthly insurance sales

ii$.$ List of policyholder names and their details.

iii. Car insurance sales by vehicle types.

iv$.$ Rankings of Top Five vehicle insurance sales.