Question

Exercises from Fundamentals Database of Systems 6th Edition

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 normal form is the relation in? Explain your answer.
b. Apply normalization until you cannot decompose the relations further. State the reasons
behind each decomposition

Solutions

Expert Solution
No answers


Submit Your Answer