Question: Considering the following relations, determine the candidate key(s) and normal form for each relation (note that a relation can be in multiple normal forms). Please

Considering the following relations, determine the candidate key(s) and normal form for each relation (note that a relation can be in multiple normal forms). Please consider the following normal forms: INF, 2NF, 3NF and BCNF 1. R(A, B, C, D) and the Functional Dependencies are C B, B D,A BD 2. R(A, B, C, D, E) and the Functional Dependencies are A-B, B-C, ACD 3. R(A, B, C, D, E) and the Functional Dependencies are A->BC, DE, AB-CD 4. R(A. B,C,D, E) and the Functional Dependencies are AC,BC. ABDE. AD 5. R(A, B, C, D, E) and the Functional Dependencies are ACBE, A-D, B-A, BC D 6. R(A, B, C, D) and the Functional Dependencies are C-B, B AC, A-BD
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
