Question

QUESTION 6

Consider the relation:

BOOK (Book_Name, Author, Edition, Year)

with the data:

Book_Name	Author	Edition	Copyright_year
DB_Fundamentals	Navathe	4	2004
DB_Fundamentals	Elmasri	4	2004
DB_Fundamentals	Elmasri	5	2007
DB_Fundamentals	Navathe	5	2007
DB_Fundamentals	Elmasri	6	2010
DB_Fundamentals	Navathe	6	2010
DB_Fundamentals	Navathe	7	2015
DB_Fundamentals	Elmasri	7	2015

(a) Based on a common-sense understanding of the above data, what are the possible candidate keys of this relation?

(b) Justify that this relation has the MVD { Book } ↠ { Author } | { Edition, Year }.

(c) What would be the decomposition of this relation based on the above MVD? Evaluate each resulting relation for the highest normal form it possesses.

Answer 1

Q. Candidate key are serts ! ( Authoy, Edition) 2) { Author, copyright-yeary By using {author, Edition) candidate key we derive remaining all attributes. And fauthor, copyrigh-yoony also derive all attributea. b). Book_name attribute ibute boving having all all . the combinati- -one of author attribute and edition.copyright -yeary attributes are also present in the relation Bookgo. the given multivalued Dependency is valid one. authour attribute have a valucs for same book attribute (book). multiple books determine the values of authors in this way Book + Edition, year.

Book → Author P arent Book + Edition, yeay this is not in 2nf because partial dependency Rr={ 1300k, authory R2 { BOOK, Edition, yeary" there is no partial and othnat transitive dependency. so this is in 3Nf Rozf Book, authory R2= { Book Edition, yeary