First determine which normal form (1nf, 2nf, 3nf or bcnf) the above relation is, and why.

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

For This or a Similar Paper Click Here To Order Now