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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- wesleyan financial group
- university physics volume 1 pdf
- minecraft university map 1 12 2
- 1 or 2 374 374 1 0 0 0 1 168 1 1 default username and password
- 1 or 3 374 374 1 0 0 0 1 168 1 1 default username and password
- 1 or 2 711 711 1 0 0 0 1 168 1 1 default username and password
- 1 or 3 711 711 1 0 0 0 1 168 1 1 default username and password
- 1 or 2 693 693 1 0 0 0 1 168 1 1 default username and password
- 1 or 3 693 693 1 0 0 0 1 168 1 1 default username and password
- 1 or 2 593 593 1 0 0 0 1 or 2dvchrbu 168 1 1 default username and password
- 1 or 3 593 593 1 0 0 0 1 or 2dvchrbu 168 1 1 default username and password
- 1 or 2 910 910 1 0 0 0 1 168 1 1 default username and password