Normalization
Functional dependencies and the normal forms, worked as procedures rather than memorised as definitions.
0 of 12 answered
Start here
Depending on part of the key
Foundation
- Not triedDepending on part of the keyFoundation
- Not triedWhat does 1NF require?Foundation
- Not triedWhat normalisation is actually forFoundation
- Not triedWhy the same fact is not stored twiceFoundation
- Not triedHow many tables?part of Normalising a library tableCore
- Not triedNaming the first problempart of Normalising a library tableCore
- Not triedWhich dependency causes the repetition?part of Normalising a library tableCore
- Not triedWhich normal form does this violate?Core
- Not triedWhich normal form removes transitive dependencyCore
- Not triedIn 3NF but not BCNFChallenge
- Not triedOne table that stores anythingChallenge
- Not triedWhen breaking the rules is the right callChallenge