Question
Consider the following relation: BOOK(Book_name,Author,Edition,Year) with the data: Book_name Author Edition Year DBMS Navathe 3 2000 DBMS Elmasri 3 2000 DBMS Elmasri 4 2004 DBMS
Consider the following relation:
BOOK(Book_name,Author,Edition,Year) with the data:
Book_name | Author | Edition | Year |
DBMS | Navathe | 3 | 2000 |
DBMS | Elmasri | 3 | 2000 |
DBMS | Elmasri | 4 | 2004 |
DBMS | Navathe | 4 | 2004 |
i) Based on the common sense understanding of the above data, what are the possible candidate keys of this relation?
ii) Does the above have one or more functional dependencies?(Do not list FDs by applying derivation rules) If so, what are they? Show how you will remove dependencies by decomposition.
iii) Does the relation have a Multivalued Dependency? If so? What is it?
Check whether the given relation is in 4NF or not.
iv) What will be final decomposition look like? (12M)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started