Normalization

Question 1

When is a database Normalized?

Answer 1

A database is normalized when each field holds just one value and each table has the correct set of fields. Improve organization of data

Question 2

Normal forms

Answer 2

Set of rules for database design

Question 3

1NF:

Answer 3

All fields must contain single values only

Question 4

2NF:

Answer 4

Part of the primary key may not determine a non-key field

Question 5

3NF:

Answer 5

A non-key field may not determine another non-key field