Below is a database relation. Apply 1 st, 2nd, and 3rd normalization rules to the data contained in this relation and determine what level of normalization this relation is in. If it is not in 3rd normal form create new relations necessary to make it adhere to the rules of 3 rd normal form. Assume the new schema will need to store more information about the manufacturer than just the name. Deliverables: ER diagram in 3rd normal form. A script to create the database relations (tables) including all applicable primary and foreign keys and the referential integrity relationships between them. At the end of the script remember to use the describe command for each table you created. A script to insert the data into the tables. At the end of the script remember to use the SELECT * FROM each table you created. Printed output of: o The table creation script(s) o The output of the describe command for each table. o The insertion script(s). o The output of the SELECT * FROM each table.

Car ID	Car Make	Care Model	Car Vin	Car Color	Cam Mileage
1	Ford	Mustang	J8379793	Red	98274
2	Acura	Integra	W1348654	Blue	23541
3	Nissan	Altima	A837483	White	6432
4	Ford	Taurus	J1738492	White	82452
5	Nissan	Altima	J839845	Black	53424
6	Nissan	Maxima	J4679138	Red	74515
7	Ford	Taurus	T2948333	Silver	57322
14	Chevrolet	Aveo	C4568138	Light blue	65321
15	Chevrolet	Cobalt	C8897652	Dark blue	74526