Based on your Assignment $1,$ create a simple database application for the SafeTowing company. The

system keeps track of their customers and towing services made in the past. The application can be

built using command line interface and manipulated with SQL since you have learned it in your

lab sessions. 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

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

design from Assignment $1$ with justifications.

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

anomalies in the database design.

Minimum requirements:

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

tow request, etc.

$2.$ Can add, update, delete and view towing requests.

$3.$ Can create, update, and delete towing assignments.

$4.$ Can add new and update customer details.

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

available data from your Assignment $1.$

$6.$ Manipulate the data and generate the following:

a$.$ All Customers list

b$.$ All Bills for towing services.

c$.$ All Towing assignments.

d$.$ Simple reporting for:

i$.$ Monthly towing services list

ii$.$ List of customer names and their areas$/$locations

iii. Most$-$towing vehicle type

iv$.$ Rankings of highest towing areas$/$locations $($Top Five$)$