# Can somebody check this normalisation workings i think i am missing a step or a dependency somewhere

given these two tables:

and:

I need to first list them as an un-normalised structure(s) then i need to identify the functional dependencies/primary keys.

Once i have done this i must represent it in 3NF. I think i am skipping 1NF and going straight to 2NF but i cant work out the intermediate step.

*un-normalised structures with PK's *

``````Piste (PisteName {PK}, Grade, Length, Fall, Lifts (repeating group), Open)
Lift (LiftName {PK}, LiftType, Rise, Length, Operating)
``````

Function dependencies

``````PisteName →{Grade, Length, Fall, Open}
LiftName →{LiftType, Rise, Length, Operating}
``````

Is there any more? i cant seem to see any.

Normalisation:

1NF

``````Piste (PisteName, Grade, Length, Fall,  Open)
Lift (LiftName, LiftType, Rise, Length, Operating)
LiftLocation (PiestName*, LiftName*)
``````

Now from what i can tell this is 1NF, 2NF and 3NF so i have obviously missed something because the teacher is expecting us to show the steps for each NF.

Can anybody point me in the right direction/and or tell me where ive messed up.

Thanks, Chris.

-
I think you are fine. You can add how you check that the result of your 1NF normalization is actually already in 2NF and then why it is in 3NF. Not simply ("Now from what i can tell this is 1NF, 2NF and 3NF") but what exactly your checking conditions are. – ypercubeᵀᴹ Feb 7 '14 at 17:58
@ypercube 1NF is no repeating groups, 2NF is no partial dependencies and 3NF is no transitive dependencies. Which to me seems to be correct. I keep having a feeling i've missed something because it quotes "show you workings to 3NF" so when i put it into 1NF it is already in 2NF and 3NF, then surely ive missed something maybe a dependency? – chris edwards Feb 7 '14 at 18:08