1. Download the following Excel spreadsheet: Normalization Exercise 2.xlsx
2. Open the worksheet and review the data.
3. What different groups are represented by the data? Create a new sheet in the workbook for each group.
4. What columns should be listed under the different groups? Add the columns for each group
5. What would the keys be? Enter the primary and foreign keys
6. Do the tables conform to 1NF? (Column Names Unique? Row data/primary key unique?) If tables aren't 1NF, modify them to conform (usually this means split the table into additional tables).
7. Do the tables conform to 2NF? (Single primary key is in 2NF, for composite keys all non-key fields must relate to all keys, no partial dependencies). If tables aren't in 2NF, modify them to conform (usually this means split the table into additional tables)
8. Do the tables conform to 3NF and BCNF? (table is in 2NF and non-key columns ONLY depend on primary keys, no transitive dependencies) If tables aren't in 3NF, modify them to conform (usually this means split the table into additional tables)
9. Save your changes to the workbook and submit it to the dropbox
Normalization Exercise 2 Key.htm