Question: 1 PublishBook Consider the following Relation PUBLISHED-BOOK Normalize the PROJECT Relation completely up to 3NF. PUBLISHED-BOOK: {ISBN, Author name, Author Affiliation, Publisher name, Publisher street
1 PublishBook Consider the following Relation PUBLISHED-BOOK Normalize the PROJECT Relation completely up to 3NF. PUBLISHED-BOOK: {ISBN, Author name, Author Affiliation, Publisher name, Publisher street address, Publisher city, Publisher zip code, pages, price, Year}
The following functional dependencies are given:
1. Each book has a unique ISBN Number
2. A book can have multiple authors
3. An author can write more than one book
4. A publisher can publish more than one book
5. A book has only one publisher
6. A publisher can have only one address
7. An author can have only one affiliation
8. A city and a state can have only one zip code
would like to know how exactly do I define/label 1NF, 2NF, 3NF and the relations and processes behind them
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
