Question
Out of star schema and snowflake schema, whose dimension
table is normalized?Solution
The correct answer is B
Statements: M ≥ S, V ≤ S, O < N > J, V < O
Conclusion:
I. S > J
II. N ≥ V
Statements: Y ≤ A = F; H > T; H < V < F; Y ≤ W < R
Conclusions:
I. Y < V
II. T < A
III. W > H
Statement: X > Y > Z; A > C > X; A < D
Conclusion: I. Z < AÂ Â Â Â Â Â II. C > Y
Statements: 21 < 51 = 71 ≤ 61 < 11; 32 < 81 ≤ 91 =51
Conclusions:
I. 11 > 81
II. 21 > 32
III. 32 ≥ 21
Statements: S < T < U ≤ W; C > U < V < W ≤ X
Conclusion:
I. S < V
II. T < X
Statement:
B = E ≥ F ≥ M < J < V ≥ R; M > A
Conclusion:
I) A ≥ R
II) B > A
Statements: R < S ≤ T = U; V ≤ W = R; P > U ≥ Q
Conclusions:
I. V < T
II. P > W
III. Q < TStatements:
A ≤ Z < X < I; L > P > C > B = I;
Conclusions:
I) Z > L
II) B > A
Statements: I < P = S ≥ O > W < E≤ G ≥ A
Conclusion
I: O ≤ P
II: G > O
Statements: Y > U = I; U > H; Z ≤ C ≤ E = Y
Conclusions:
I. U < C
II. E > I
III. I > H