In normalization, what is the meaning of the transitive dependency? A. If non-key attribute depends on only one side of a composite key B. If non-key attribute depends on another non-key attribute C. If non-key attribute depends fully on the…
In normalization, what is the meaning of the full dependency? A. If non-key attribute depends on only one side of a composite key B. If non-key attribute depends on another non-key attribute C. If non-key attribute depends fully on the…
In normalization, what is the meaning of the partial dependency? A. If non-key attribute depends on only one side of a composite key B. If non-key attribute depends on another non-key attribute C. If non-key attribute depends fully on the…
In functional dependency, if you say A depends on B, what do you write? A. A->B B. B->A C. AB D. None correct Answer: Option B
In functional dependency, if you write A->B, which of the following is a wrong meaning? A. A depends on B B. B depends on A C. A determine B D. None correct Answer: Option A
In functional dependency, how to do read A->B? A. A depends on B B. B depends on A C. B determine A D. None correct Answer: Option B
What is the meaning of the repeating group? A. Merge cell B. Duplicated data C. Repeating data D. All correct Answer: Option B
Which normalization that uses functional dependency? A. 0NF B. 1NF C. 2NF D. None correct Answer: Option C
Which normalization that does not use functional dependency? A. 1NF B. 2NF C. 3NF D. All correct Answer: Option A
Which step is correct for 3NF? A. Each attribute value must be single B. Remove transitive dependency C. Remove partial dependency D. None correct Answer: Option B
KB Cambodia