The correct answer is Option (2) → 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 – “… 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. In our example, any ‘employee name’ in the personal table appears only once (i.e. unique row); and hence this field of personal table is a primary key of the relationship. On the other hand, an ‘employee name’ in the pay table appears in multiple rows; and hence this field of pay table is a foreign key of the relationship.” NCERT (Pre-rationalised edition):
Exercise – “… 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):
Answer – “… ANSWER Q.1. 1. c. 2. d. 3. a. 4. c 5. c …” |
