Database Management - Required ACCES DATABASE

1. Define functional dependence.

2. Give an example of a column A and a column B such that B is functionally dependent on A. Give an example of a column C and a column D such that D is not functionally dependent on C.

3. Define primary key.

4. Define candidate key.

5. Define first normal form.

6. Define second normal form. What types of problems would you find in tables that are not in second normal form?

7. Define third normal form. What types of problems would you find in tables that are not in third normal form?

8. Define fourth normal form. What types of problems would you find in tables that are not in fourth normal form