Let R(A, B, C, D, E, P, G) be a relational schema in which the following functional dependencies are known to hold:
AB —> CD,
DE —> P,
C --> E,
P --> C and B —> G .
The relational schema R is
A. | In BCNF |
B. | in 3NF, but not in BCNF |
C. | In 2NF, but not in 3NF |
D. | Not in 2NF |
Answer : D Explanation : pushpa said: (6:50am on Saturday 31st March 2018)
bcoz it follows partial dependency,so it is not in 2 NF.
|
|
Option: A Explanation : Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. |