Posted: September 23rd, 2022

Dependency 2 (d2): title and publyear were dependent on bookid, copynr

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

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 To Order Now