Part I: Normalize the information in the table below. 1. First, describe the normalization process in writing and apply it to the information in the table below. Diagram your tables (this can be done in MS Word, MS Vision, or Excel) which should include the identification of two primary keys and one foreign key. Include a data dictionary that describes the field name, the appropriate field type, and length of the field, whether the field is a primary or foreign key. Other metadata would be welcomed (e.g., is the field required?). Answer this question- What do you need to do in MS Access to adhere to Codd's 12 rules? Parts Supplier Description Supplier Rating Quantity Cost Supplier Name ID 1000 AAAA Light 8 $6.00 ABC Light Company 1001 CCCC Little Lamp 100 $13.00 ABC Electronics 1002 AAAA Switch 205 $2.00 ABC Light Company ABC Electronics 1003 | CCCC 99 $19.00 Big Lamp Universal Shade 3 $4.00 Lamp Shade INC 1004 BBBB Part II Timel. You should have two 1002 AAAA Switch 205 $2.00 ABC Light Company ABC Electronics 1003 CCCC Big Lamp 6 99 $19.00 1004 BBBB Universal Shade 3 $4.00 Lamp Shade INC u Part II Please create an MS Access database based on the information above. (Hint)- You should have two tables. Please use the specified field types that you defined in your data dictionary. In addition, create the following queries: 1. Display everything in the Parts Table. 2. Display descriptions and cost in the Parts Table. 3. Display everything in the Parts Table but order by cost from lowest to highest. 4. Display all items sold by BBBB and their rating. 5. Display Supplier Names and ratings but order alphabetically by name. 6. Create a report from query #2 using the "Report Wizard