Third Normal Form (3NF) To take this motley crew of tables to Third Normal Form (3NF), we must now take 2NF tables and eliminate all transitive (i.,...

Third Normal Form (3NF)

To take this motley crew of tables to Third Normal Form (3NF), we must now take 2NF tables and eliminate all transitive (i.e., hidden) dependencies. In other words, every column that isn't a part of the key must depend on the key for its informational value. Non-key columns should have no informational value if they are separated from the key of a 3NF table. Remember that the term "eliminate' doesn't mean "delete." Instead, it means to split into separate tables.

TODO: LIST THE FOUR TABLES AND LIST THE COLUMNS OF EACH TABLE IN 3NF

Circus_lnfo Table, Unnormalized

1. animal_nbr (the Primary key)

2. animal_name

3. tent_nbr

4. tent_name

5. tent_location

6. trick_nbr1

7. trick_name1

8. trick_learned_at1

9. trick_skill_level1

10. trick_nbr2 ... (and on through 16)

11. trick_name2 ... (and on through 16)

12. trick_learned_at2 ... (and on through 16)

13. trick_skill_level2 ... (and on through 16)