Consider a relation named BOOKthat contains data about the books in a library.BOOKrelation was initially created with the attributesBookID(an id that library assigns),ISBN, CopyNr (used to differentiate copies of the same book),Title,PublYear,Author, andAuthorBornYear.

Primary key: BookID, CopyNr and Author

Candidate key: ISBN, CopyNr and Author

Below you see dependencies of attributes:

• Dependency 1 (D1): ISBN, Title, PublYear, AuthorBornYear were dependent onBookID,CopyNrandAuthor
• Dependency 2 (D2): Title and PublYear were dependent onBookID,CopyNr
• Dependency 3 (D3): AuthorBornYear was dependent onAuthor

First determine which normal form (1NF, 2NF, 3NF or BCNF) the above relation is, and why. Then, if necessary, convert the above relation to the highest normal form (BCNF). Write any assumptions that you make.