The correct answer is Option (4) → Key fields
Note: This question is from the pre-rationalised NCERT book. The topic is not there in the latest NCERT book (2026-27), and it is also out of the CUET 2026 syllabus.
NCERT (Pre-rationalised edition):
Database Management System for Accounting – “… 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.” NCERT (Pre-rationalised edition):
Answers – “ANSWER Q.1. 1. c. 2. d. 3. a. 4. c 5. c …” |
