2 NF doubt

Question

In which Normal Form the relation is in /

R(A,B,C,D)  $AB \rightarrow C $,  $AC\rightarrow D$ ,$C\rightarrow A $ are the functional dependencies given.

Answer 1

Relation is in 2NF

Comments

@hitendra u mean not getting non prime attribute right(all are prime attribute)?

---

@adarsh_1997

R(A,B,C,D,E) {ABC$\rightarrow$C , CD$\rightarrow$ B ,BC$\rightarrow$  E}

what will u say about its Normal form?

---

R(A,B,C,D,E) {ABC→C , CD→ B ,BC→  E}

{A, B, C, D} are prime attributes here. 

now, according to definition of Partial Dependency,

 Prime Attribute -> Non Prime Attribute

{E} is non-prime attribute, and hence BC->E becomes a PD.

And if there is any PD in the grammer, then it's not in 2NF and hence not in 3NF.