Question: A relation R(A, B, C) satisfies the functional dependencies A Band A C Q4.1 (4 points) State another functional dependency that R must satisfy so

 A relation R(A, B, C) satisfies the functional dependencies A Band

A relation R(A, B, C) satisfies the functional dependencies A Band A C Q4.1 (4 points) State another functional dependency that R must satisfy so these three functional dependencies (i.e, A B, A- C and the new functional dependency) allow us to infer that R also B C. Your answer cannot contain B or C on the right hand side! Show your work. For the next two parts of this question, assume that the new functional dependency you stated in Q4.1 also holds in R. Again, show your work for the next two parts as well Q4.2 (2 points) What are R's keys? Q4.3 (2x1-2 points) Is R in (A) BCNF and (C) 3NF

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!