$1$: Create a complete conceptual data model using the ER diagram. $2$: Relational Schema and the Database Tables. All relations should be in third normal form. Indicate primary keys, foreign keys, and the constraints. Use the following format: TABLE$\_$NAME $($Primary$\_$Key $($s$),$ Non Key$\_$Fields, Foreign$\_$Key $($s$)$

$3.$ System implementation including designing necessary tables, queries and modifications $($insert$,$ delete & update$),$ views, triggers and procedures on the database.

The database you design should be sizeable enough to contain eight or more tables with at least one many to many relationships in the database system. You should also have at least $10$ to $15$ queries, $2$ to $3$ views, $2$ to $3$ triggers, $2$ to $3$stored procedures and $2$ to $3$ functions.

Create SQL scripts All the code should be in one file.

$-$Customer table needs a subset of attribute account type to be $($Individual or Corporate$)$

$-$Vehicle table needs a subset to include category subset and SUV Type subset $($Mini or Full size$)$

$-$Employee table needs to have a subset of Role $($CSR and ServiceMGR$)$

It needs the following tables:

Employee, Customer, Vehicle, Bill, Invoice, Payment type, Rental, reservation, lease, Lease history, insurance, Cancellation, Job, Maintenance, and Garage.

business rules:

A Vehicle is assigned one and only one Category

A Category may be assigned to one or more Vehicles

A Vehicle may be assigned to one or more Rentals

A Rental may be assigned one and only one Vehicle$$

A Vehicle may be assigned to one or more Lease Histories$$

A Lease History is assigned one and only one Vehicle

A Vehicle may be assigned to one or more Jobs

A Job is assigned one and only one Vehicle

A Vehicle may have one or more Maintenance Histories$$

A Maintenance History is assigned one and only one Vehicle

A Category may be assigned to one or more Rentals

A Rental is assigned one and only one Category$$

A Category may be assigned to one or more Leases

A Lease is assigned one and only one Category$$

A Customer can be an Individual

An Individual is a Customer

A Customer can be a Corporate

A Corporate is a Customer

A Customer may be assigned to one or more Rentals

A Rental is assigned to one and only one Customer

A Customer may be sent one or more Bills

A Bill is sent to one and only one Customer

An Individual always uses one or more Credit Cards$$

A Credit Card is used by one and only one Customer

A Corporate always uses one and only one Account Number

An Account Number is always assigned to one Corporate$$

A Corporate may be assigned to one or more Leases

A Lease is assigned to one and only one Corporate

A Corporate may receive one or more Invoices

An Invoice is always sent to one and only one Corporate$$

A Payment Type can be a Credit Card

A Credit Card is a Payment Type$$

A Payment Type can be an Account Number

An Account Number is a Payment Type

A Payment Type is always assigned to one or more Rentals

A Rental is always assigned one and only one Payment Type

A Payment Type is always assigned to one or more Leases

A Lease is always assigned one and only one Payment Type

A Rental may have one and only one Insurance

An Insurance may be applied to one or more Rentals

A Rental may generate one and only one Bill

A Bill is always generated by one and only one Rental$$

A Rental is always created by one and only one Employee

An Employee may create one or more Rentals

A Lease may have one and only one Insurance

An Insurance may be applied to one or more Leases$$

A Lease is always created by one and only one Employee

An Employee may create one or more Leases

An Employee can be a Customer Service Rep

A Customer Service Rep is an Employee

An Employee can be a Service Manager

A Service Manager is an Employee

A Service Manager may assign one or more Jobs

A Job is always assigned by one and only one Service Manager

A Job always contains one or more Maintenance Services

A Maintenance Service may be assigned to one or more Jobs

A Job may be assigned to one and only one Garage

A Garage may be assigned one or more Jobs$$