Consider the relation-
Book (accno, author, author address, title, borrower no, borrower name, pubyear) with the following functional dependencies
accno → title accno → pubyear
author → accno
accno → authorauthor → author address
accno → borrower_no borrower no → borrower_name
(i) Normalize the relation. Clearly show the steps.
(ii) For each decomposed relation identify the functional dependencies that apply and identify the candidate key.