Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Consider the following universal relation schema for a BAND database BAND( Band ID, CD Nbr, Concert Fee, CD Tile, LabeL Name, Promoter, Promoter-contact, BandName,
3. Consider the following universal relation schema for a BAND database BAND( Band ID, CD Nbr, Concert Fee, CD Tile, LabeL Name, Promoter, Promoter-contact, BandName, Royalty ) and the set of functional dependencies defined for this database F BandID, CDNbrRoyalty, [BandID BandName, (CD-Nbr) ? {cnTile, LabeLName}, { Promoter) ? { Promoter-contact)). To shorten the notation we represent BAND by R with the set of functional dependencies F. a. Suppose we have the following decomposition D of R: D-(ABI.BDEH,EG Does D have the attribute preservation property and the dependency preservation property? Justify your answers; yes or no by itself is worth 0 points Attribute preservation property: Dependency preservation property: b. Using the appropriate algorithm, find the key Kof R. Clearly show all your work for all steps of the algorithm (final answer by itself without shown work is worth 0 points)
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