Consider the relation:
BOOK (Book_Name, Author, Edition, Year) with the data:

a. Based on a common-sense understanding of the above data, what are the possible candidate keys of this relation?
b. Does the above have one or more functional dependency (do not list FDf.d.s by applying derivation rules)? If so, what is it? Show how you will remove it by decomposition.
c. Does the resulting relation have an MVD? If so, what is it?
d. What will the final decomposition look like?

Transcribed Image Text:

Book_Name DB fundamentals Navathe 4 DB fundamentl Elmasri 4 DB fundamental Elmasri 5 DB fundamental Navathe 5 Author Edition Year 2004 2004 2007