databases normalisation Flashcards

1
Q

characteristics of first normal form

A

data is atomic , and has a primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

characteristis of second normal form

A

already in 1nf and every field is dependent on the primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly