Finding Normal Form For Rational Dependency

Question

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.
 
 
Summary

The question belongs to Computer Science and it is about finding out the normal form for a relational dependency. This has been discussed in the solution.

Total Word Count 110