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:

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

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!