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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!