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 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
Get step-by-step solutions from verified subject matter experts
