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

A relation with 3 attrbutes may not be in 2nf/3nf/bcnf

$R(A,B,C)$

$A\rightarrow B$

$C \rightarrow B$

key will be $AC$

The relation holds partial dependency hence not in 2nf .hence not in 3nf,bcnf

---

Sorry in question it is a 2 attribute relation by mistake I wrote 3 attribute

---

then it will always hold BCNF

---

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)