C. For each of the following given relational schemas (R1, R2, R3, R4) with prim

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

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.