1NF, 2NF and 3NF
अब 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
