databases normalisation Flashcards
1
Q
characteristics of first normal form
A
data is atomic , and has a primary key
2
Q
characteristis of second normal form
A
already in 1nf and every field is dependent on the primary key
3
Q
characteristics of 3rd normal form
A
it is already in 2nf and contains no attributes that depend on another attribute in the table (apart from the primary key)