Asked by karamjeet singh on May 02, 2024
Verified
The common field between two tables in a one-to-many relationship is the primary key field on the "one" side of the relationship and the _____ on the "many" side of the relationship.
A) sorting field
B) junction field
C) orphan field
D) foreign key field
Foreign Key Field
A column in a database table that creates a link between two tables by referring to the primary key of another table.
Junction Field
A term used in databases referring to a field that connects two tables together in a many-to-many relationship.
- Comprehend the function of foreign keys in associating tables in a database.
Verified Answer
SA
sohan anirudhMay 04, 2024
Final Answer :
D
Explanation :
The foreign key field on the "many" side of the relationship is used to connect the records to their related record on the "one" side of the relationship.
Learning Objectives
- Comprehend the function of foreign keys in associating tables in a database.