Answer Happy

Determine the functional dependencies based on the scenario
below, create the relations in 3NF based off the dependencies and
apply the DBDL model (identify all keys). Using your knowledge of
the college environment, determine the functional dependencies that
exist in the following relation. After determining the functional
dependencies, convert the relation to an equivalent collection of
relations that are in third normal form (3NF). Once relations are
in 3NF, apply the DBDL model (identify primary keys, secondary
keys, foreign keys and alternate keys). Must follow the syntax for
creating functional dependencies, relations and DBDL Student
(StudentNum, StudentName, NumCredits. (AdvisorNum, AdvisorName)
(CourseNum, CourseName, CourseCredit)
Determine the functional dependencies based on the scenario below, create the relations in 3NF based off the dependencies and apply the DBDL model (identify all keys). Using your knowledge of the college environment, determine the functional dependencies that exist in the following relation. After determining the functional dependencies, convert the relation to an equivalent collection of relations that are in third normal form (3NF). Once relations are in 3NF, apply the DBDL model (identify primary keys, secondary keys, foreign keys and alternate keys). Must follow the syntax for creating functional dependencies, relations and DBDL Student (StudentNum, StudentName, NumCredits. (AdvisorNum, AdvisorName) (CourseNum, CourseName, CourseCredit)