Question related to the course of Foundamintal of Database;

Normalize the following schema, with given constraints, to BCNF.

books(accessionno, isbn, title, author, publisher)

users(userid, name, deptid, deptname)

accessionno ----> isbn

isbn -----> title

isbn ------> publisher

isbn -----> author

userid -----> name

userid -----> deptid

deptid -----> deptname