Question

Match List-I with List-II.

List-I	List-II
(A) Primary key	(III) Attribute used to uniquely identify a tuple.
(B) Degree	(I) Total number of attributes in a table.
(C) Foreign key	(II) Attribute used to relate two tables.
(D) Constraint	(IV) A restriction on the type of data that can be inserted in a column.

• A. (A)-(I), (B)-(II), (C)-(III), (D)-(IV)
• B. (A)-(III), (B)-(I), (C)-(II), (D)-(IV)
• C. (A)-(I), (B)-(II), (C)-(IV), (D)-(III)
• D. (A)-(III), (B)-(IV), (C)-(I), (D)-(II)

Hint:

Primary key = unique identity, Foreign key = reference link, Degree = number of attributes, Constraint = restriction.

Answer 1

The Correct Option is B

Step 1: Recall definitions.
- Primary key: Attribute used to uniquely identify each tuple → (III).
- Degree: Total number of attributes in a table → (I).
- Foreign key: Attribute used to relate two tables → (II).
- Constraint: Restriction on type of data allowed in a column → (IV).

Step 2: Matching.
So: (A) - (III), (B) - (I), (C) - (II), (D) - (IV).
Final Answer: \[ \boxed{(A)-(III), (B)-(I), (C)-(II), (D)-(IV)} \]