Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

given these two tables:

enter image description here

and:

enter image description here

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.

share|improve this question
    
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 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 at 18:08

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.