Test Series

Question

Comments

you can see from option C that it has 3 candidate keys... AB, BC, BD so it's in 3NF and question says NOT in 3NF...

---

@Mk Utkarsh So we can consider all the candidate keys and not only the Primary Key to determine key attributes in case of normalization?

---

Yes..

Answer 1

option c and d both are true.

Comments

prime attributes are the attributes which present in any of the candidate keys,not only in primary key.So according to you definition of prime attribute will be violated

referhttps://en.wikipedia.org/wiki/Candidate_key

---

You Are right I think.

But there is confusion in question

---

if you chose c as the answer then DB+=DBAC ie DB become key and D prime attribute which makes it 3NF

so, answer is D