Exercises

Answer the following questions

1. What are the benefits of database table normalization.

2. Explain the following dependencies between table attributes:

   a. Functionally dependent.
   b. Fully functionally dependent.
   c. Transitively functionally dependent.

3. When is a table in 1NF.

4. When is a table in 2NF.

5. When is a table in 3NF.

6. What is the difference between 2NF and 3NF.

7. When is a table in BCNF.

8. When is a table in 4NF.