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. 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.