Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. (6 pts) Consider the following instance 4 (1) Does the functional dependency D->C hold in this instance? (2) Does the functional dependency C->B hold
1. (6 pts) Consider the following instance 4 (1) Does the functional dependency D->C hold in this instance? (2) Does the functional dependency C->B hold in this instance? (3) Does the functional dependency A->BCD hold in this instance? 2. (12 pts) Given a relation schema R (A, B, C, D, E, G) and a set of functional dependencies F-A->B, AB->E, A-:-E, G->C) (1) Find (AC) in F (2) Find a candidate key for relations on schema R, and prove that your answer is a candidate key 3. (12 pts) Consider a relation schema R-(A, B, C, D, E) with functional dependencies (1) Is the decomposition (A, C, D), (B, C, E) a lossless-join decomposition? Why or why not? (2) Is the decomposition (A, C, D), (A, B, E) a lossless-join decomposition? Why or why not
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