1 - Wesleyan University



1. Using the following STUDENT table structure, draw its dependency diagram and identify all dependencies (including all transitive dependencies).

Attribute name Sample value

STU_NUM 211343

STU_LNAME Stephanos

STU_MAJOR Accounting

DEPT_CODE ACCT

DEPT_NAME Accounting

DEPT_PHONE 4356

COLLEGE_NAME Business Administration

ADV_LASTNAME Grastrand

ADV_OFFICE HKB201

ADV_BUILDING Howard Kallenberger Building

ADV_PHONE 2115

STU_GPA 2.87

STU_HOURS 96

STU_CLASS Junior

Figure P4.6 The Dependency Diagram for Problem 4.6

6. Using the initial dependency diagram drawn in problem 5, normalize the structure to meet the 3NF requirements to the greatest practical extent. If you believe that practical considerations dictate the using a 2NF structure, explain why your decision to retain 2NF is appropriate. If necessary, add or modify attributes to create appropriate determinants and to adhere to the naming conventions.

Note: Although the completed student hours (STU_HOURS) do determine the student classification (STU_CLASS), this dependency is not as clear-cut as you might initially assume it to be. For example, a student is considered a Junior if that student has completed between 61 and 90 credit hours. Therefore, a student who is classified as a Junior may have completed 66, 72, 87, or any number of hours within the specified range of 61-90 hours. In short, any hour value within a specified range will define the classification.

The normalized structure is shown in Figure P4.6.

Figure P4.6 The Normalized Dependency Diagrams for Problem 6

-----------------------

[pic]

[pic]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download