Consider the following relation for published books: BOOK (Book title, Author_name, Book type, List price, Author affil, Publisher) Author_affil refers to the affiliation of author. Suppose the...

Consider the following relation for published books: BOOK (Book title, Author_name, Book type, List price, Author affil, Publisher) Author_affil refers to the affiliation of author. Suppose the following dependencies exist Book title - Publisher, Book fype Book type = List price Author_name > Author affil () What normal form is the Book relation in? Why? (b) Decompose Book info 2NF relations. (¢) Decompose Book into 3NF relations.
Consider the following relation for published books:<br>BOOK (Book title, Author_name, Book type, List price, Author<br>affil, Publisher)<br>Author_affil refers to the affiliation of author. Suppose the<br>following dependencies exist:<br>Book title → Publisher, Book type<br>Book type > List price<br>Author_name > Author affil<br>(a) What nomal form is the Book relation in? Why?<br>(b) Decompose Book into 2NF relations.<br>(c) Decompose Book into 3NF relations.<br>

Extracted text: Consider the following relation for published books: BOOK (Book title, Author_name, Book type, List price, Author affil, Publisher) Author_affil refers to the affiliation of author. Suppose the following dependencies exist: Book title → Publisher, Book type Book type > List price Author_name > Author affil (a) What nomal form is the Book relation in? Why? (b) Decompose Book into 2NF relations. (c) Decompose Book into 3NF relations.

Jun 10, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?