DATABASE DEPENDENCIES

PLEASE DRAW THE DEPENDENCY DIAGRAM

PLEASE DRAW THE DEPENDENCY DIAGRAM

PK = PRIMARY KEY, it looks like there may have been a mistake, it should have been SECTION, not SEMESTER

FD = FUNCTIONAL DEPENDENCY

Transform this bad design through to the 3NF. Draw a dependency Diagram. (You DO NOT HAVE TO POPULATE THE TABLES WITH Rows. JusT sHow THE NEW RELATIONS WITH PK's). People CourseName Facult Name students Course ID Eacultydd Rection Semester K Bingham Bob, Mary, Joan CS101 FS2016 (Alice, Robert, Car) B Hare CS101 FS2016 Bingham (Ron, Harry, Hermoine) cs191 FS2016 (Mark, Janet, Ron Appie CS404 SS2017 PK (CourselD, Faculty ld, Semester FDs (Courseld, Facultyld, Section Semester, Students Faculty id Faculty Name Courseld CourseName