Consider a relation named BOOK that contains data about the books in a library. BOOK relation was
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Managing Operations Across the Supply Chain
ISBN: 978-0078024030
2nd edition
Authors: Morgan Swink, Steven Melnyk, Bixby Cooper, Janet Hartley
Posted Date: