Question

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

• A. Table fields
• B. Joint fields
• C. Main fields
• D. Key fields

Hint:

Always use "key fields" or other appropriate jargon while relating the data and building databases.

Answer 1

The Correct Option is D

Understanding Database Table Relationships:
Database table relationships are structured connections established between tables in a relational database system. The core element facilitating these relationships is the use of common fields.
Role of Key Fields:
Primary Key: A field that uniquely identifies each record in a table.
Foreign Key: A field in one table that refers to the primary key in another table. This creates the link between the two tables.
The correct terminology for the common fields are hence Key fields.