A primary key from one file and a foreign key from another file are used to create a relationship between two files in a relational database.

Question

Quizplus · Accepted Answer

A foreign key is a primary key of one file that appears in another file.Foreign keys are essential in the relational database model.Without them,you have no way of creating logical ties among the various files.We use these relationships extensively to create business intelligence because they enable us to track the logical relationships within many types of information.

A Primary Key from One File and a Foreign Key