The key for this relation is Book_title,Authorname. This relation is in 1NF and not in 2NF as no attributes are FFD on the key. It is also not in 3NF
<u>Explanation:</u>
<u>
lGiven the relation
</u>
<u>l</u>Book(Book_title, Authorname, Book_type, Listprice, Author_affil, Publisher)
land the FDs
lBook_title . Publisher, Book_type
lBook_type . Listprice
lAuthorname .Author_affil
(a) The key for this relation is Book_title,Authorname. This relation is in 1NF and not in 2NF as no attributes are FFD on the key. It is also not in 3NF
(b) 2NF decomposition:
lBook0(Book_title, Authorname)
lBook1(Book_title, Publisher, Book_type, Listprice)
lBook2(Authorname, Author_affil)
<u>
This decomposition eliminates the partial dependencies.
</u>
3NF decomposition:
lBook0(Book_title, Authorname)
lBook1-1(Book_title, Publisher, Book_type)
lBook1-2(Book_type, Listprice)
lBook2(Authorname, Author_affil)
l<u>This decomposition eliminates the transitive dependency of Listprice
</u>
