Consider the following relation for published books:
BOOK (Book_title, Authorname, Book_type, Listprice, Author_affil, Publisher)
Author_affil referes to the affiliation of the author. Suppose the following dependencies exist:
Book_title -> Publisher, Book_type
Book_type -> Listprice
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.
```
Given the relation
Book(Book_title, Authorname, Book_type, Listprice, Author_affil, Publisher)
and the FDs
Book_title ??Publisher, Book_type
Book_type ??Listprice
Authorname ?Author_affil
(a)The key for this relation is Book_title,Authorname. This relation is in 1NF and not in
2NF as no attributes are FFD on the key. It is also not in 3NF.
(b) 2NF decomposition:
Book0(Book_title, Authorname)
Book1(Book_title, Publisher, Book_type, Listprice)
Book2(Authorname, Author_affil)
This decomposition eliminates the partial dependencies.
3NF decomposition:
Book0(Book_title, Authorname)
Book1-1(Book_title, Publisher, Book_type)
Book1-2(Book_type, Listprice)
Book2(Authorname, Author_affil)
```
This decomposition eliminates the transitive dependency of Listprice
You might also like to view...
A vertical axis title can be displayed parallel to the axis
Indicate whether the statement is true or false
By default, the Control Panel window displays in Category view.?
Answer the following statement true (T) or false (F)
One advantage of ERP is complete integration of information systems across departments.
Answer the following statement true (T) or false (F)
When at the rightmost cell in a row, press the ENTER key to move to the first cell in the next row; do not press the TAB key.
Answer the following statement true (T) or false (F)