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 AuthorCandidate key: ISBN, CopyNr and AuthorBelow you see dependencies of attributes: Dependency 1 (D1): ISBN, Title, PublYear, AuthorBornYear were dependent on BookID, CopyNr and AuthorDependency 2 (D2): Title and PublYear were dependent on BookID, CopyNrDependency 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. D1D2D3BookID ISBNCopyNrTitle PublYear AuthorAuthorBorn Year

The given relation "BOOK" is not in BCNF (Boyce-Codd Normal Form) because it has dependencies where…

Answered: Consider a relation named as BOOK that…

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter6: Managing Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 4.16CP

See similar textbooks

Related questions

Concept explainers

Question

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.

D1
D2
D3
BookID ISBN
CopyNr
Title PublYear Author
AuthorBorn Year

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.