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)

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: