Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
A. A → B.
B. A → C.
C. A → (B,C).
D. (B,C) → A.
Answer: Option A
Solution (By Examveda Team)
Option1: A → B.This option states that attribute A determines attribute B. In this scenario, every time attribute A appears, it is matched with the same value of attribute B. This option aligns with the given information.
Option2: A → C.
This option states that attribute A determines attribute C. However, the given information mentions that every time attribute A appears, it is not matched with the same value of attribute C. Therefore, this option is not true based on the provided data.
Option3: A → (B,C).
This option states that attribute A determines both attribute B and attribute C. Since attribute A is matched with the same value of attribute B but not the same value of attribute C, this option is not accurate.
Option4: (B,C) → A.
This option states that attributes B and C together determine attribute A. Since every time attribute A appears, it is matched with the same value of attribute B and not the same value of attribute C, this option is not consistent with the given information. Therefore, the correct option based on the provided data is Option1: A → B.
This Question Belongs to Database >> The Relational Model And Normalization
Join The Discussion