A library database records the authors and the publisher of each book. Normalize the following relation and indicate the primary and foreign key attribute types:
R (ISBN, title, author(name, date_of_birth), publisher(name, address(streetnr, streetname, zipcode, city)), pages, price)
The assumptions are:
a. each book has a unique ISBN number;
b. each author has a unique name;
c. each publisher has a unique name;
d. a book can have multiple authors;
e. an author can write more than one book;
f. a publisher can publish more than one book;
g. a book has only one publisher;
h. a publisher has only one address.
Suppose that one book can have multiple publishers. How can you extend your model to accommodate this? Where would you