UGC NET CSE | December 2014 | Part 2 | Question: 19

Question

The best normal form of relation scheme $R(A, B, C, D)$ along with the set of functional dependencies $F = \left\{AB \rightarrow C, AB \rightarrow D, C \rightarrow A, D \rightarrow B\right\}$ is

• A. Boyce-Codd Normal form
• B. Third Normal form
• C. Second Normal form
• D. First Normal form 

Answer 1

keys are AB,CD,BC,AD

Here A,B,C,D all are prime attributes

So, no partial or transitive dependency are there

Therefore it is in 3NF

but as C and D are not keys for the relation A,B,C,D , therefore it is not in BCNF

Comments

it will be 3NF bcz Prime attribute (A,B,C,D)  & and there are not any partial dependency so 3NF 

---

vijaycs it's not key element but element.

---

@shreshtha please update the answer..its $3NF$