The Relational Model and Normalization - Technical MCQs

Q1:

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.

ANS:C - (A,B) is a composite determinant.

Composite key means if 1 attribute is not able to identify uniqueness among rows than we have to combine two or more attributes called as composite key.

Now here A & B together determine C that is AB->C. So AB is composite.