Consider the relation:BOOK (Book_Name, Author, Edition, Year) with the data: $ \begin{matrix} \text{Book_ Name} & \text{Author} & \text{Edition} & \text{Copyright_ Year}\\ \text{DB_ fundamentals} & \text{Navathe} & \text{4} & \text{2004}\\ \text{DB_ fundamentals} & \text{Elmasri} & \text{4} & \text{2004}\\ \text{DB_ fundamentals} & \text{Elmasri} & \text{5} & \text{2007}\\ \text{DB_ fundamentals} & \text{Navathe} & \text{5} & \text{2007}\\ \end{matrix} $ 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 $\{\text { Book }\} \rightarrow \mathrm{~ \{ A u t h o r \} ~} | \mathrm{~ \{ E d i t i o n , ~ Y e a r \} . ~}.$ 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.

Q&A Education