Question: Consider a relation schema {S, T, V, C} with two FDs: (We use to for the arrow.) T to S V to S,C Which of

Consider a relation schema {S, T, V, C} with two FDs: (We use "to" for the arrow.)

T to S

V to S,C

Which of the following statements are correct?

1.

After decomposing first on the FD T to S, we must do one more decomposition to get everything in BCNF.

2.

If we decompose on the second FD, we obtain {V,S,C} with key V, and {V,T} without any FDs.

3.

If we decompose on the first FD, we obtain {T,S} with FD T to S, and {S,V,C} with FD V to S,C.

4.

If we decompose on the first FD, we obtain {T,S} with FD T to S, and {T,V,C} with FD V to C.

5.

If we decompose on the second FD, we obtain {V,S,C} with FD V to S,C, and {T,S} with FD T to S.

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!