Q1. Consider the given relation for the published books:
BOOK(Book_title, Author_name, Book_type, List_price, Author_affil, Publisher)
Author_affil refers to affiliation of author. Assume the given dependencies exist:
Book_title → Publisher, Book_type
Book_type → List_price
Author_name → Author_affil
a) What normal form is the relation in? Describe your answer.
b) Apply normalization till you can’t decompose the relations further. State the reasons following each and every decomposition.
Q2. What do you mean by primary goal of normalization? How the concepts of functional dependency and multi are valued dependency related with the normalization? Give an illustration for the same.