1.3 Exchanging data

Question 1

When in a database in first normal form (1NF) ?

Answer 1

there must be no attribute that contains more than a single value.

Question 2

When in a database in second normal form (2NF) ?

Answer 2

A database with no partial dependencies , no attributes depend on part of a composite key; and is in first normal form

Question 3

When in a database in third normal form (3NF) ?

Answer 3

Contains no non-key dependencies, so the attribute only depends on the primary key; and is in second normal form