Week6 Assignment

Week6 Assignment - Term, Grade) ) MY ANSWER: The changes...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Lacey Mowery 4048879 INFO321 Chapter 5, Question 12, Page 174: Using your knowledge of the college environment, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form: 2NF: Student (StudentNum, StudentName, NumCredits, AdvisorNum, AdvisorName, DeptNum, DeptName, (CourseNum, Description,
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

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.

Ask a homework question - tutors are online