1NF, 2NF and 3NF
Ace your homework & exams now with Quizwiz!
Steps needed to get to 2NF
check database is in 1NF, remove partial dependencies, fix many-to-many relationships
Steps needed to get to 3NF
check database is in 2NF, remove non-key dependencies
4 steps necessary to get from 0NF to 1NF
eliminate duplicate columns, get rid of groups of repeating data, identify primary key, separate out attributes which aren't atomic
What is a non-key dependency?
when the value of an attribute is determined by another attribute which is not the key
