Consider the relation: BOOK (Book_Name, Author, Edition, Year) with the data: (a
ID: 3568322 • Letter: C
Question
Consider the relation:
BOOK (Book_Name, Author, Edition, Year)
with the data:
(a) Based on a common-sense understanding of the above data, what are the possible candidate keys of this relation?
(b) Justify that this relation has the MVD { Book } ? { Author } | { Edition, Year }.
(c) What would be the decomposition of this relation based on the above MVD? Evaluate each resulting relation for the highest normal form it possesses.
Book_Name Author Edition Copyright_year DB_Fundamentals Navathe 4 2004 DB_Fundamentals Elmasri 4 2004 DB_Fundamentals Elmasri 5 2007 DB_Fundamentals Navathe 5 2007Explanation / Answer
a)
Book_Name, Author
Book_Name, Author, Edition
Book_Name, Author, Edition, Year
b)
1 book name can have mulitple authors or 1 book name can have same combination of edition and year but those 2 books are different. That's why we won't be able to distinguish between them.
c)
Book(Book_Name,Author)
BookEdition(Book_Name,Author,Edition)
BookYear(Book_Name,Author,Year)