ISRO-2007
September 6, 2024Topologies
September 7, 2024Normalization
| Question 68 |
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 BCNF refers to Boyce-Codd Normal Form. Then Faculty is
(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 Boyce-Codd Normal Form. Then Faculty is
| Not in 3NF, in BCNF | |
| In 3NF, not in BCNF | |
| In 3NF, in BCNF | |
| Not in 3NF, not in BCNF |
Question 68 Explanation:
Possible FD’S for given instance are:
FacName ➝ dept,office
FacName ➝ dept,office
Correct Answer: B
Question 68 Explanation:
Possible FD’S for given instance are:
FacName ➝ dept,office
FacName ➝ dept,office