Find Us On: Facebook Twitter Rss Feed Blog
Need To Register? Sign Up Login

Forum Help

stretch8302
stretch8302 


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. Student (StudentNum, StudentName, NumCredits, AdvisorNum, AdvisorName, DeptNum, DeptName, (CourseNum, Description, Term, Grade) ) Attachments
Tags Clarifications

Answers

Student Advisor Database

dickersonka
dickersonka 



Attached is the schema for the student and advisors database including the functional dependencies Attachments
StudentAdvisors.txt (1 K) Download Preview
Single course description per course num. Single student name, num credits, and advisor per course. Grade is based upon studentnum, coursenum, and term allowing a student to take

Screenshots
Purchase Answer