Consider the following relation:

BOOK(Book_name,Author,Edition,Year) with the data:

Book_name	Author	Edition	Year
DBMS	Navathe	3	2000
DBMS	Elmasri	3	2000
DBMS	Elmasri	4	2004
DBMS	Navathe	4	2004

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

ii) Does the above have one or more functional dependencies?(Do not list FDs by applying derivation rules) If so, what are they? Show how you will remove dependencies by decomposition.

iii) Does the relation have a Multivalued Dependency? If so? What is it?

Check whether the given relation is in 4NF or not.

iv) What will be final decomposition look like? (12M)