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
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


Expert Solution
No answers

Submit Your Answer