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
Get step-by-step solutions from verified subject matter experts
