1NF, 2NF and 3NF
Pataasin ang iyong marka sa homework at exams ngayon gamit ang 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
