

InterviewSolution
Saved Bookmarks
1. |
Consider the following table : Faculty (facName, dept, office, rank, dateHired)facNamedeptofficerankdateHiredRaviArtA101Professor1975MuraliMathM201Assistant2000NarayananArtA101Associate1992LakshmiMathM201Professor1982MohanCSCC101Professor1980LakshmiMathM201Professor1982SreeniMathM203Associate1990TanujaCSCC101Instructor2001GaneshCSCC105Associate1995(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 BCNF refers to Boyee-Codd Normal FormThen Faculty is(A) Not in 3NF, in BCNF(B) In 3NF, not in BCNF(C) In 3NF, in BCNF(D) Not in 3NF, not in BCNF |
Answer» None | |