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


Discussion

No Comment Found

Related InterviewSolutions