Vidyalelo
Database · Q1

The Relational Model and Normalization

Programming · Database · question 1

Q1

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.
Answer
B.
A → C.
C.
A → (B,C).
D.
(B,C) → A.

Answer: Option A

Solution

Answer: Option A
Solution:
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.