normal form

Question

R(W, X, Y, Z) is a relation

FD - WX→Y,Y→WZ. It is in which normal form?

Comments

@joshi but isnt non key and non prime same?

whats the difference?

---

no,

both are differnt things, non key can contain prime attributes...

---

okay :)

Answer 1

WX->Y,Y->WZ

Candidate keys are XW, XY.

So prime attributes =X,Y,W.

non prime= Z

So in FD Y->WZ non prime attribute Z is partially dependent on Y which is part of candidate key XY.

So, it cant be in 2NF and thus the relation is in 1NF.