You are required to perform the process of normalising the data shown in Appendix A and B to first (1NF), second (2NF) and third (3NF). Ensure you clearly outline the process you went through to create the database in 3NF and identity the appropriate primary and foreign keys.

Activity

1: Put data in First Normal Form: Remove Repeating Elements or Groups of Elements in Data Activity

2: Put data in Second Normal Form: Remove Partial Dependencies on a Concatenated Key in Data Activity

3: Put data in Third Normal Form: Remove Dependencies on Non-Key Attributes / Final Database Design Activity

4: Create an ER diagram of the normalised relations derived from activities 1 to 3. Show the attributes for each entity, identifier attribute(s) and the correct relationships that exist between the entities taking care to show the correct relationship cardinalities. Evidence You should provide a report section that contains diagrams and brief written explanations providing evidence on the normalisation process for each normal form (1st, 2nd and 3rd ) was applied to the table in Appendix B. For activity 4 you also need to produce an ER diagram showing your normalised entities.