Database - The Relational Model and Normalization - Discussion

Discussion Forum : The Relational Model and Normalization - General Questions (Q.No. 19)
19.
If attribute A determines both attributes B and C, then it is also true that:
A → B.
B → A.
C → A.
(B,C) → A.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
22 comments Page 2 of 3.

Tarun V.Nair said:   1 decade ago
Its simple A->BC, so via split rule we can say A->B, A->C so option a is correct.

Pradeep said:   1 decade ago
Attribute A determines attributes B and C so,
A->BC, or A->B and A->C, in the three option only one option are given hence option a are right.

Vahini said:   1 decade ago
I think answer is correct. By splitting A -> (B, C) to A ->B, A ->C.

Nitish said:   1 decade ago
The question is saying that A determines both B and C. But no option suggest that A is determining C.

Really have no idea what should be the correct answer?

Please suggest the correct answer with reason.

Debobrata said:   1 decade ago
Apply Decomposition rule on A -> (B, C) we get A -> B and A->C.

Rupesh said:   10 years ago
Solution of this question is not right. According to your question an attribute A determines both B and C, then answer must be A->B, A->C or A->(B, C) or A->BC.

Karan said:   9 years ago
If attribute A determines both attributes B and C then answers will be:.

A -->B, A-->C.

Prachi said:   9 years ago
There is a different between determines and determine of.

If determine of then B->A but here determines B and C so A->B.

Rahul said:   9 years ago
Give brief explanation for option A.

Sreepada B l said:   9 years ago
Please explain, how option A is true.


Post your comments here:

Your comments will be displayed after verification.