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:- TGS0262979

Expected delivery within 24 Hours