Consider the following table : Faculty(facName, dept, office, rank, dateHired)
(Assume that no faculty member within a single department has same name. Each faculty member has only one office identified in office). 3NF refers to third normal form and BNCF
refers to Boyce-Codd normal form
Then Faculty is
Create a FREE account and get: