Normalization

Question

A relation with 3 attribute is always in

a)4NF

b)BCNF

c)5)NF

d)DK/NF

According to me answer must be (b)

but answer given in answer sheet is (d)

Can any body explain

Comments

But ans given is option (d) can u explain this

---

https://gateoverflow.in/1260/gate2007-62-ugcnet-june2014-ii-47

---

Okk thanks

Answer 1

• R(ABC)

        FD { A--->B}

Candidate key = AC.

Given example is of three attribute . But it is not in BCNF.

Comments

Sorry by mistake I written Realtion is of 3 attribute actually it was 2 attribute relation in question

---

if question is about $3$ attribute then it may not be in 2NF .

if the question is about $2$ attributes then it will always be  in $BCNF$

---

According to me also it must be BCNF

But answer given is option (d)