Accountancy Part ADatabase Management System for Accounting

The common fields used in a relationship between tables are called :

Answer & explanation

Correct answer: option 3

The correct answer is Option (3) → Key fields

Note: This question is from the pre-rationalised NCERT book. The topic is not there in the latest NCERT book (2026-27), but it is still in the CUET 2026 syllabus, so do not skip it.

NCERT (Pre-rationalised edition):
Multiple Choice Questions – “… 5. The common fields used in a relationship between tables are called: a. Joint fields b. Main fields c. Key fields d. Table fields.”

NCERT (Pre-rationalised edition):
Creating Relationships – “… A black line will appear joining the two tables at the common field. This line, also referred to as Join Line, establishes the relationship between TabMonthlySalary and TabDARates using the common field of MonthID.”