Question: I need to normalise this table to third normal form (3NF) and show each step. This is what I have so far, I would like
I need to normalise this table to third normal form (3NF) and show each step.

This is what I have so far, I would like to know any misakes I have made and the steps to 2NF and then 3NF... Thanks guys.

The table below shows the staff roster for a small supermarket. Each row of the table represents a work shift of one staff member in an area of the supermarket. Shift Date Shift Duration | Staff # Shift # 22451 22452 224532018-08-23 08:30 22454 2018-08-23 08:30 22455 2018-08-23 11:30 22456 2018-08-23 12:30 22457 2018-08-23 12:30 22458 2018-08-23 14:30 Area ID CO cO FV DC SR co DC FV Area Name Checkout Checkout Fruit & Veg Deli Counter Store Room Checkout Deli Counter Fruit & Veg Staff Name Jonah Woods Sammie Benson Hannah Finlay Patrick Glad Norman Sera Patrick Glad Sammie Benson Angelo Roberts 2018-08-23 08:30 25 104 92 75 124 75 104 51 2018-08-23 08:30 Normalise this table to the third normal form, clearly showing the stages of ONF, 1NF, 2NF and 3NF State any assumptions you make. Use relational symbolic notation as indicated in the seconod lecture, and name your resultant data sets upon reaching 3NF
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
