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.

2. 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.

3. 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?).

4. Answer this question- What do you need to do in MS Access to adhere to Codds 12 rules?

Parts ID Supplier ID Description Supplier Rating Quantity Cost Supplier Name

1000 AAAA Light 1 8 $6.00 ABC Light Company

1001 CCCC Little Lamp 6 100 $13.00 ABC Electronics

1002 AAAA Switch 1 205 $2.00 ABC Light Company

1003 CCCC Big Lamp 6 99 $19.00 ABC Electronics

1004 BBBB Universal Shade 5 3 $4.00 Lamp Shade INC

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.