Question: 2. Let R(ABC) be a relation with attributes A, B and C. Let Fi and F2 be sets of functional dependen- cies where Fi A-B,A+C)and
2. Let R(ABC) be a relation with attributes A, B and C. Let Fi and F2 be sets of functional dependen- cies where Fi A-B,A+C)and F2-A-B, B-c}. (Here to get some intuitions about the relation R, you may think of R as representing information about a person- attribute A represents the SSN of the person, attribute B represents the address of the person, and attribute C represents the phone number of the person. However, this visualization of R should NOT impact your answers to the question) (2.1) Compute Fi, Fi (using the compact representation we discussed in class). Is Fi equivalent to F2 Explain your answer. (2.2) Let F,-{A B, B C, A C} . Are F2 and F3 equivalent? Explain your
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
