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):
Logical Structuring of Data in Tables – “… In order to establish relationship between any two tables, we will have to insert columns with matching values in the two related tables. Thus, we may have ‘employee name’ appearing in both ‘personal table’ as well as in ‘pay table’. After establishing a relationship between these two tables, rows with a common value in ‘employee name’ field of both the tables get related. The two common fields used in a relationship between tables are called the key fields.”

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