If someone knows how to do this and can answer these questions I would be greatful:
7) Note the four tables below labeled a, b, c, and d. State which is/are in 3nf. For those that are not in 3nf, put in 3nf. State your assumptions.
a) Student Table
key stud-num
other fields stud-name, stud-grade-level
Example with one record loaded:
stud-num stud-name stud-grade-level
16 Bill Freshman
b) student table
key stud-num
other fields stud-name, stud-grade-level, age
Example with one record loaded:
stud-num stud-name stud-grade-level age
16 Bill, 揃uddy?Freshman 30
c) key stud-num
other fields stud-name, stud-grade-level, grade-code
Example with one record loaded:
stud-num stud-name stud-grade-level grade-code
16 Bill Freshman 1
d) key stud-num, activity-number
other fields stud-name, hours-with-activity
Example with one record loaded:
stud-num activity-number stud-name hours-with-activity
16 24 Sue 15
7) Note the four tables below labeled a, b, c, and d. State which is/are in 3nf. For those that are not in 3nf, put in 3nf. State your assumptions.
a) Student Table
key stud-num
other fields stud-name, stud-grade-level
Example with one record loaded:
stud-num stud-name stud-grade-level
16 Bill Freshman
b) student table
key stud-num
other fields stud-name, stud-grade-level, age
Example with one record loaded:
stud-num stud-name stud-grade-level age
16 Bill, 揃uddy?Freshman 30
c) key stud-num
other fields stud-name, stud-grade-level, grade-code
Example with one record loaded:
stud-num stud-name stud-grade-level grade-code
16 Bill Freshman 1
d) key stud-num, activity-number
other fields stud-name, hours-with-activity
Example with one record loaded:
stud-num activity-number stud-name hours-with-activity
16 24 Sue 15