C. For each of the following given relational schemas (R1, R2, R3, R4) with prim
ID: 3627938 • Letter: C
Question
C. For each of the following given relational schemas (R1, R2, R3, R4) with primary key and set of functional dependencies, please indicate what the highest normal form is for each relational schema and why concisely: (40 points)
a. R1(A, B, C, D)
Key: AB
Functional Dependencies: AB -> C, AB -> D, A -> C, B -> D
b. R2(A, B, C, D)
Key: AB
Functional Dependencies: AB -> C, C -> D
c. R3(A, B, C, D)
Key: AB
Functional Dependencies: AB -> C, AB -> D, C-> B
d. R4(A, B, C, D)
Key: AB
Functional Dependencies: AB -> C, AB -> D
Explanation / Answer
c. R3(A, B, C, D) Key: AB Functional Dependencies: AB ? C, AB ? D, C? B AB ? C : In third normal form AB ? D : in third normal form C? B : In first normal form as non key attribute is depend on part of primary key d. R4(A, B, C, D) Key: AB Functional Dependencies: AB ? C, AB ? D AB ? C : In third normal form AB ? D : In third normal form