1. A) Normalize the following relation into 3NF. Show all your work, including intermediate steps through 1NF and 2NF. Indicate the primary and foreign key attributes. Justify your answer.

R(ISBN, title, author(name, date of birth), publisher(name, address(streetnr, streetname, zipcode, city)), pages, price)

each book has a unique ISBN number;

each author has a unique name;

each publisher has a unique name;

a book can have multiple authors;

an author can write more than one book;

a publisher can publish more than one book;

a book has only one publisher;

a publisher has only one address.

First Normal Form:

Second Normal Form:

Third Normal Form:

B) Suppose that a book can have multiple publishers. How would your answer to the previous question change? Where would you put the attribute type number

of copies? Justify your answer.

Third Normal Form: