Assignment Chapter 5
Members: 4
Deadline: Before final term year 2 semester 2
I. Review Questions:
1.
2.
3.
4.
5.

Define functional dependence.
Define primary key.
Define candidate key.
Define first normal form.
Define second normal form. What types of problems would you find in tables that are not in second normal form?
6. Define third normal form. What types of problems would you find in tables that are not in third normal form?
7. Define fourth normal form. What types of problems would you find in tables that are not in fourth normal form?
8. Define interrelation constraint and give one example of such a constraint. How are interrelation constraints addressed?
9. Consider a Student table containing StudentNum, StudentName, student’s
StudentMajor, student’s AdvisorNum, student’s AdvisorName, student’s
AdvisorOfficeNum, student’s AdvisorPhone, student’s NumCredits, and student’s Class
(freshman, sophomore, and so on). List the functional dependencies that exist, along with the assumptions that would support those dependencies.
10. Convert the following table to an equivalent collection of tables that are in third normal form. This table contains information about patients of a dentist. Each patient belongs to a household.
Patient (HouseholdNum, HouseholdName, Street, City,
State, Zip, Balance, PatientNum, PatientName,
(ServiceCode, Description, Fee, Date))
The following dependencies exist in the Patient table:
PatientNum  HouseholdNum, HouseholdName, Street,
City, State, Zip, Balance, PatientName
HouseholdNum  HouseholdName, Street, City, State,
Zip, Balance
ServiceCode  Description, Fee
PatientNum, ServiceCode  Date
11. Using your knowledge of the college environment, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third