Lincoln Autos is a small car dealership located in the city of Chatoon, IL. Most of its customers are either students or households looking for a second car. Appendix A shows basic information needed in order to run the dealership. The data shown in Appendix A is not organized in an effective way. It needs to be organized - or normalized to use the database designers’ terminology.Database normalization is the process of organizing data to minimize redundancy. Normalization, usually, involves (a) dividing large tables into smaller (and less redundant) tables, and (b) defining relationships between them. The goal is to eliminate anomalies from the database in order to produce smaller and well structured related tables. This means isolating data in smaller tables so that additions, deletions, and modifications of fields can be made just in one table and then propagated through the rest of the database by means of the relationships.Your AssignmentNormalize the tables shown in Appendix A in order to come up with four (4) tables that the database is free of redundancy – except foreign keys. You need to use the template given in Appendix B of this assignment to create the design of your tables. The tables must be called: AutoEmployees, AutoSales, AutoInventory, AutoCustomers, Make sure you have added the necessary fields for creating the relationships between the tables where applicable. Also, all addresses must be broken into street (e.g. 600 Lincoln Avenue), city, and state. A copy of your tables’ design (your Appendix B) must be typed and saved as a Word file under the name tablestructure.doc. You will submit a hard copy of the file and keep the electronic copy on your personal disk for future use.1/3Designing theLincoln AutosdatabaseAppendix AStudent Name: _______________________________________________________Table 1Sale_ID SaleDate Inventory_ID Make Model Body Engine TransS001 1/1/2011 IV005 Toyota Camry SE Sedan V4 AutomaticS002 2/1/2011 IV009 Chevy Impala XE Sedan V4 AutomaticS003 2/3/2011 IV001 Honda Accord LE Sedan V4 ManualS004 1/7/2011 IV010 Chrysler 300M Sedan V4 AutomaticS005 3/1/2011 IV016 Toyota Camry XE Sedan V6 AutomaticS006 1/28/2011 IV003 Ford Escape-i SUV V6 ManualS007 1/20/2011 IV004 Ford Explorer SUV V8 AutomaticTable 1 (continued)VehicleYear SalePrice CustomerName CustomerAddress CustomerPhone2009 10250 John Knew 200 Lincoln Ave, Chatoon IL 21734511112010 21000 Isabel Williams 234 Elm Street, Worth IL 21778185692008 8500 George Busch 128 Mckinley Ave, Salem KY 32556690002005 9000 Elaine Wong 41 Dawn Street, Rardin, IL 21754200102003 6000 Steve Simpson 210 10th Street, Chatoon, IL 21774532102010 15000 Thether Saw 102 Ohio Rd, Decatur, IL 21795045662011 28000 Lisa Bloom 74 Indian Road, Chester, KY 4109581000**********************************************************************************Table 2Employee_ID FirstName LastName Title ExperienceE001 John Longhorn Salesperson 10E002 Audry Brown Secretary 5E003 Luc Jambon Salesperson 5E005 Ken Williams Mecanic 5E006 Diane Lawson Salesperson 3E007 Roberto Gonzales Salesperson 5E008 Steve Johns Manager 10Table 2 (continued)Address Phone102 Ohio Street, Chatoon, IL 217582410214 Lerna Road, Chatoon, IL 2178542100120 Jacki Lane, Chatoon, IL 2178542121128 Lincoln Avenue, Chatoon, IL 2175242100100 Main Street, Salem, IN 2178754100145 Neil Avenue, Champaign, Il 2173251000123 Prospect Avenue, Urbana, IL 21762510152/3Appendix B: tables’ structure Table’s name: _________________________ Column Data type Field size Default valueNote: The table’s primary key must be shown with the PK suffix. Foreign keys (if any) must have the FK suffix.Table’s name: _________________________ Column Data type Field size Default valueNote: The table’s primary key must be shown with the PK suffix. Foreign keys (if any) must have the FK suffix.Table’s name: _________________________ Column Data type Field size Default valueNote: The table’s primary key must be shown with the PK suffix. Foreign keys (if any) must have the FK suffix.Table’s name: _________________________ Column Data type Field size Default valueNote: The table’s primary key must be shown with the PK suffix. Foreign keys (if any) must have the FK