Question: 4. Find if the given relationship set is in 2NF given: * 2 points R = {A,B,C,D,E} FD = {AB->CD, C->A, D->E} AND candidate keys

4. Find if the given relationship set is in 2NF given: * 2 points R = {A,B,C,D,E} FD = {AB->CD, C->A, D->E} AND candidate keys = AB, CB, AD Yes No 2 points 5. Which normal form is associated with the term "transitive functional dependency"* 1NF 2NF 3NF BCNF 2 points 6. Given relation R=(A,B,C,D), find if Ris in 3NF with respect to the following FDs: B -> C, C -> A, C -> D (B is the candidate key) * Yes O No
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
