Instructions 1. 2. Study the background information very carefully. Apply your skills Background Information The IT team at Bottom Lines Trucking is working on the new Vehicle Information and Maintenance System called VIMS. So far, they have created a table design in 1NF. The 1NF design has no repeating field groups, but some fields do not depend on the entire primary key. You have been assigned to transform the 1NF design to 2NF. Study the table carefully, and then complete the four tasks shown. 1 NF design for the Work Order table. MwORK ORDER-I DATE .. VN -SERVICE CODE . SERVICE DESC , MILES.MECHANIC NUMBER.MECHANIC NAME 103554 103554 103554 104456 104456 10/20/2009 111AAA111 TR14 10/20/2009 111AAA111 BK11 10/20/2009 111AAA111 INO3 11/12/2009 222888222 INO3 11/12/2009 222BBB222 OLO TRANSMISSION 41488 R14 BRAKES INSPECTION 41488 R14 INSPECTION 29807 P7 OIL CHANGE 29807 P07 RUIZ RUIZ RUIZ PHAM PHAM 41488 R14 Apply Your Skills A. Show the 1 NF design in standard notation format. B. Briefly explain how you will create the 2NF design. C. Show standard notation format for each new table that you will create. D. Create the new 2NF tables, and show each one with sample reports, using the data in the 1 NF table shown. 0 paq LA2206