[Computer Science - CS2203 - Databases 1]

Consider a relation named as BOOK that contains data about the books in a library. BOOK relation was initially created with the attributes BookID (an id that library assigns), ISBN, CopyNr (used to differentiate copies of the same book), Title, PublYear, Author, and AuthorBornYear.

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 on BookID, CopyNr and Author
• Dependency 2 (D2): Title and PublYear were dependent on BookID, CopyNr
• Dependency 3 (D3): AuthorBornYear was dependent on Author

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.

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.

BookID ISBN CopyNr Title PublYear Author AuthorBornYear