Problem:
Consider the following relation for published books:
BOOK (Book_title, Authorname, Book_type, Listprice, Author_affil, Publisher)
Author_affil refers to the affiliation of the author. Suppose the following dependencies exist:
Book_title → Publisher, Book_type
Book_type → Listprice
Author_name → Author-affil
(a) What normal form is the relation in? Explain your answer.
(b) Apply normalization until you cannot decompose the relations further. State the reasons behind each decomposition.
Additional Information:
This question is from Computer Science as well as it is about determining the normal form for relational dependency. This has been stated in the solution.