MadeEasy Workbook: Databases - Database Normalization

Question

Comments

A and BC both are candidate keys

---

Yeah

---

B-->D is partial dependency

Answer 1

Ans is 1Nf .

candidate keys are={A,BC} Prime Attributes={a,b,c}, Non-Prime Attribute={d,e}

in second fd the prime attribute of candidate key determines non-prime. so it can't be in 2nf .