1. FIRST NORMAL FORM (1NF) a. Decompose the composite attributes into simple attributes. b. Convert the table above to 1NF (eliminate repeating groups of data and select an appropriate PK). c. Show the table structure format (table name with PK and all dependent attributes in parentheses). d. Create a dependency diagram for the table above. 2. SECOND NORMAL FORM (2NF) a. Show the table structure format for each table in 2NF. b. Create the dependency diagrams for the resulting tables. 3. THIRD NORMAL FORM (3NF) - 25 points: a. Convert to 3NF and show the table structure format for each table. b. Create the dependency diagrams for the resulting tables. 4. ENTITY-RELATIONSHIP MODEL a. Using Chen notation, create an ERD showing all of the 3NF tables above. You must show the entities, relationships, connectivity, participation, and cardinality (it is not necessary to show the attributes on the ERD). b. Based on the ERD created in step 4a, create a relational schema showing the entities, their attributes, and the connectivity of the relationships. This relational schema should show each entity with its attributes listed inside a rectangle, similar to Crows Foot notation (i.e., do not show the attributes inside ovals stemming from the entities). This may be done in Access.