pexels-kulbir-11079217
pexels-kulbir-11079217
pexels-kulbir-11079217
First determine which normal form (1nf, 2nf, 3nf or bcnf) the above relation is, and why.
Home » Computer Science  »  First determine which normal form (1nf, 2nf, 3nf or bcnf) the above relation is, and why.
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.

Leave a Reply

Your email address will not be published.

Scan the code