0 votes 0 votes 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 Nishtha_Agarwal asked Dec 31, 2018 Nishtha_Agarwal 682 views answer comment Share Follow See all 8 Comments See all 8 8 Comments reply Show 5 previous comments Bhagyashree Mukherje commented Dec 31, 2018 reply Follow Share Thanks for confirming.I knew the concept but got confused seeing the options 0 votes 0 votes Deepanshu commented Dec 31, 2018 reply Follow Share two fds facname,dept ----->office rank date hired facname,office------->dept rank datehired ans is still bcnf not in 3nf 0 votes 0 votes Deepanshu commented Dec 31, 2018 reply Follow Share 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? 0 votes 0 votes Please log in or register to add a comment.
