Consider the following relation for published books: BOOK [Title, Author-name, T
ID: 3699314 • Letter: C
Question
Consider the following relation for published books:
BOOK [Title, Author-name, Type, List-price, Category, Author-affil, Publisher]
Author-affil refers to the affiliation of author. Suppose the following functional dependencies are derived from the business rules of this application domain:
Title ? Type, List-price, Publisher
Type ? Category
Author-name ? Author-affil
1. What normal form is this relation in? Explain your answer
2. Apply normalization until you cannot decompose the relation further. State the reasons of each decomposition. (Draw the relational forms chart)
Explanation / Answer
1.BOOK relation is in 1NF
2NF violations
Title ? Type, List-price, Publisher
Type ? Category
Author-name ? Author-affil
Reason: they denote partial functional dependence on simply a part of the primary key.