Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

تمرين 16

Consider the following relation for published books:
BOOK (Book_title, Authorname, Book_type, Listprice, Author_affil, Publisher)
Author_affil referes 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.