Question: given the relation r ( e , f , g , h , i , j ) and the functional dependencies GI - > EF

given the relation r(e,f,g,h,i,j) and the functional dependencies GI->EF and E
-
>
H and I
-
>
J
,
give a lossless decomposition of r into BCNF
.
Your answer should list the normalized relations that you will create in place of r
(
E
,
F
,
G
,
H
,
I,J
)
.
New relations should be stated in the form of r
(
x
,
y
,
z
)
,
with the primary keys underlined.

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!