If attributes A and B determine attribute C, then it is also true that:
A. A → C.
B. B → C.
C. (A,B) is a composite determinant.
D. C is a determinant.
Answer: Option D
Solution (By Examveda Team)
Option1: A ? C.This option states that attribute A determines attribute C. If attributes A and B together determine attribute C, it is possible that attribute A alone can determine attribute C as well.
Option2: B ? C.
This option states that attribute B determines attribute C. If attributes A and B together determine attribute C, it is possible that attribute B alone can determine attribute C as well.
Option3: (A,B) is a composite determinant.
This option suggests that attributes A and B together determine attribute C. This is consistent with the given information that attributes A and B determine attribute C.
Option4: C is a determinant.
This option implies that attribute C determines other attributes. However, based on the given information that attributes A and B determine attribute C, it is more accurate to say that C is determined by attributes A and B.
In conclusion, the correct options based on the given information are Option1: A ? C, Option2: B ? C, and Option3: (A,B) is a composite determinant. Option4: C is a determinant is not accurate in this context.
This Question Belongs to Database >> The Relational Model And Normalization
Related Questions on The Relational Model and Normalization
A. A → B.
B. A → C.
C. A → (B,C).
D. (B,C) → A.
A. normal forms.
B. referential integrity constraints.
C. functional dependencies.
D. None of the above is correct.
A relation is in this form if it is in BCNF and has no multivalued dependencies:
A. second normal form.
B. third normal form.
C. fourth normal form.
D. domain/key normal form.
Join The Discussion