Using your knowledge of the college environment, determine the functional dependencies that exist in the following table.

Question:

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) )
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts of Database Management

ISBN: 978-111182591

7th edition

Authors: Philip J. Pratt, Joseph J. Adamski

Question Posted: