What is the main purpose of using foreign keys in a relational database design?
A)It provides useful financial data value in the table.
B)It is required in all tables.
C)It is used to link tables.
D)It is required for forms.

Question

Quizplus · Accepted Answer

Foreign keys are used to link tables in a relational database design. It establishes a relationship between two tables by creating a common column between them. The foreign key column in one table refers to the primary key column in another table, allowing for data to be connected and accessed across tables.

What Is the Main Purpose of Using Foreign Keys in a Relational