Given R (ISBN, A_Name, A_DOB, P_Name, P_City, P_State, pages, price):
The assumptions are: each book has a
unique ISBN number; each author has a unique name; each publisher has a unique name; a book can have multiple authors; an author can write more than one book; a publisher can publish more than one book; a book has only one publisher; a publisher has only one address.
How to get the best decomposition if R is not in BCNF?
R (ISBN, A_Name, A_DOB, P_Name, P_City, P_State, pages, price) BCNF (Boyce-Codd Normal Form): It is one of the Normal... View the full answer