Chat with AI
Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
Edition 6ISBN: 0136086209Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
Edition 6ISBN: 0136086209 Exercise 16
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.
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.
Explanation
Verified
Verified
Given the relation
Book(Book_title, Auth...
Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
