1.

BOOK(Book_title, Author_name, Book_type, List_price, Author_affiliation, Publisher_name)

Primary Key: (Book_title, Author_name)

FD1: (Book_title, Author_name) -> (Book_type, List_price, Author_affiliation, Publisher_name)

The following additional dependencies exist:

FD2: Book_title -> Publisher_name, Book_type

FD3: Book_type -> List_price

FD4: Author_name -> Author_affiliation

Is the relation BOOK in first normal form? Why?

(b) Is the relation BOOK in second normal form? Why?

(c) Is the relation BOOK in third normal form? Why?

(d) Improve the relation by breaking it down to separate relations, so that the whole design is in third normal form. For each relation in this improved design, please clearly indicate the relation name, the attributes, and have the primary key attribute(s) underlined. You CANNOT add new attributes or change the names of the existing attributes.