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 Dependencie 1 (33.64 KiB) Viewed 63 times