--%>

find a 3nf decomposition of the following


Find a 3NF decomposition of the following relation scheme: University (Faculty, Dean, Department, Chair, Professor, Rank, Student}. The University relation satisfies the following set of functional dependencies:

{Faculty → Dean, Dean → Faculty, Department → Chair, Professor →Rank Chair, Department → Faculty, Student → DepartmentFacultyDean,

ProfessorRank → DepartmentFaculty}

Is the decomposition non-loss and dependency preserving?

 

Request for Solution File

Ask an Expert for Answer!!
Database Management System: find a 3nf decomposition of the following
Reference No:- TGS0412513

Expected delivery within 24 Hours