Accountancy Part ADatabase Management System for Accounting

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

Answer & explanation

Correct answer: option 4

The correct answer is Option (4) → Key fields

Two tables are related through a field they share. This field is the primary key in one table and the foreign key in the other, so the common fields are called key fields.

Why the other options are incorrect

Option (1) Table fields — Incorrect. Every field of a table is a table field; the term does not name the linking field.
Option (2) Joint fields — Incorrect. The line joining the tables is a join line, but the fields are not called joint fields.
Option (3) Main fields — Incorrect. There is no such term in database relationships.

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.”