Using the STUDENT table structure shown, do the following:
|
ATTRIBUTE NAME |
SAMPLE VALUE |
SAMPLE VALUE |
SAMPLE VALUE |
SAMPLE VALUE |
SAMPLE VALUE |
|
STU_NUM |
211343 |
200128 |
199876 |
198648 |
223456 |
|
STU_LNAME |
Stephanos |
Smith |
Jones |
Ortiz |
McKulski |
|
STU_MAJOR |
Accounting |
Accounting |
Marketing |
Marketing |
Statistics |
|
DEPT_CODE |
ACCT |
ACCT |
MKTG |
MKTG |
MATH |
|
DEPT_NAME |
Accounting |
Accounting |
Marketing |
Marketing |
Mathematics |
|
DEPT_PHONE |
4356 |
4356 |
4378 |
4378 |
3420 |
|
COLLEGE_NAME |
Business Admin |
Business Admin |
Business Admin |
Business Admin |
Arts & Sciences |
|
ADVISOR_LNAME |
Grastrand |
Grastrand |
Gentry |
Tillery |
Chen |
|
ADVISOR_OFFICE |
T201 |
T201 |
T228 |
T356 |
J331 |
|
ADVISOR_BLDG |
Torre Building |
Torre Building |
Torre Building |
Torre Building |
Jones Building |
|
ADVISOR_PHONE |
2115 |
2115 |
2123 |
2159 |
3209 |
|
STU_GPA |
3.87 |
2.78 |
2.31 |
3.45 |
3.58 |
|
STU_HOURS |
75 |
45 |
117 |
113 |
87 |
|
STU_CLASS |
Junior |
Sophomore |
Senior |
Senior |
Junior |
Note
Although the completed student hours(STU_HOURS) do determine the student classification (STU_CLASS),this dependency is not as obvious as you might initially assume itto be. For example, a student is considered a junior if the studenthas completed between 61 and 90 credit hour
- Write the relational schema and draw its dependency diagram.Identify all dependencies, including all transitivedependencies.
- Write the relational schema and draw the dependency diagram tomeet the 3NF requirements to the greatest practical extentpossible. If you believe that practical considerations dictateusing a 2NF structure, explain why your decision to retain 2NF isappropriate. If necessary, add or modify attributes to createappropriate determinants and to adhere to the namingconventions.
- Using the results of Problem 3, draw the Crow’s Foot ERD.
Expert Answer
Answer to Using the STUDENT table structure shown, do the following: ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE …