Can I get help with this question, please.

Consider the following relation for published books: BOOK (Book_title, Authorname, Book_type, Listprice, Author_affil, Publisher).

The primary key for this relation: (Book_title, Authorname).

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

Using this information answer the following 2 questions and label your answers accordingly to their appropriate number.

1) Is this relation in 1NF, 2NF, or 3NF? Explain your answer.

2) How would you successively normalize it completely to 3NF? Specify the primary keys in each new table. State the reason behind each normalization.