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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!