Using the STUDENT table structure shown in Table 1, do the following: a. Write the relational schema and draw its dependency diagram. Identify all dependencies, including all transitive dependencies. [5 marks] b. Write the relational schema and draw the dependency diagram to meet the 3NF requirements to the greatest practical extent possible. If you believe that practical considerations dictate 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. [10 marks] c. Using the results of Problem b, draw the Crow’s Foot ERD. [5 marks] TABLE 1: STUDENT INFO 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
Using the STUDENT table structure shown in Table 1, do the following:
a. Write the relational schema and draw its dependency diagram. Identify all
dependencies, including all transitive dependencies. [5 marks]
b. Write the relational schema and draw the dependency diagram to meet the
3NF requirements to the greatest practical extent possible. If you believe that
practical considerations dictate 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.
[10 marks]
c. Using the results of Problem b, draw the Crow’s Foot ERD. [5 marks]
TABLE 1: STUDENT INFO
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
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 8 images
