Normal Forms Flashcards by Christer Noren

Q

1NF

A

Column should contain (single) Atomic Values

Columns should have the same data type

Columns must have unique name

Order where you store your data should not matter

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

2NF

A

No Partial Relationships + 1NF

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

3NF

A

2NF + Transitive Dependency

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

BCNF

A

(Boyce Codd Normal Form)

3NF + A ——-> B then A is a super key

How well did you know this?

1

Not at all

2

3

4

5

Perfectly