Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given universal schema R(A,B,C,D,E,F,G,H,I) and a set of functional dependencies as follows: AB CD A E B FH C G D B G C H
Given universal schema R(A,B,C,D,E,F,G,H,I) and a set of functional dependencies as follows:
AB CD
A E
B FH
C G
D B
G C
H I
when schema R(A,B,C,D,E,F,G,H,I) is normalized or decomposed into the following schema:
R1(A,B,C,D)
R2(A,E)
R3(B,F,H)
R4(C,G)
R5(H,I)
Group of answer choices
b. The decomposition created is in the third normal form.
c. both a. and b.
a. The decomposition created is in the Boyce-Codd normal form.
d. neither a. nor b.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started