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.

I need to normalise this table to third normal form (3NF) and

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.

show each step. This is what I have so far, I would

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!