consider the following relation for published books: book (book title, author name, book type, list price, author affil, publisher) author affil refers to the affiliation of author. suppose the following dependencies exist: book title → publisher, book type book type → list price 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
