Normalisation

Question

Options are

a- not in 3nf,in bcnf

b- in 3nf,not in bcnf

c- in 3nf, in bcnf

d- not in 3nf, not in bcnf

Comments

Thanks for confirming.I knew the concept but got confused seeing the options

---

two fds

facname,dept ----->office rank date hired

facname,office------->dept rank datehired

ans is still bcnf not in 3nf

---

i think of one more dependency

office ------>dept . is possible 

then office is not even candidate key ......so answer is b 

that it is 3nf but not bcnfNishtha_Agarwal whts ans. they provide?