This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Term, Grade) ) MY ANSWER: The changes are an addition of a relational table containing StudentNum, CourseNum, and Grade, all of which are dependent on the other tables for more information. 3NF: Student (StudentNum, StudentName, NumCredits, AdvisorNum) Advisor (AdvisorName, DeptNum, DeptName) Course (CourseNum, Description, Term, Grade) StudentCourse (StudentNum, CourseNum, Grade )...
View Full Document
This note was uploaded on 11/29/2011 for the course INFO 321 taught by Professor Meyer during the Spring '11 term at Old Dominion.
- Spring '11