3.3 Databases and Data Management

Question 1

Requirements for First Normal Form (1NF)

Answer 1

1. All its data are atomic.
2. There are no repeating columns or fields.

Question 2

Requirements for Second Normal Form (2NF)

Answer 2

1. It must satisfy 1NF.
2. All non-key-attributes must be fully dependent on the primary key.

Question 3

Requirements for Third Normal Form (3NF)

Answer 3

1. It must satisfy 2NF.
2. All non-key attributes are non-transitively dependent on the primary key.