Why do relational databases use primary keys and foreign keys?
A) To create a database
B) To create physical relationships
C) To create logical relationships
D) All of these choices are correct.

Question

Quizplus · Accepted Answer

Relational databases use primary keys to uniquely identify each record in a table and foreign keys to create logical relationships between tables. These relationships ensure data integrity and prevent inconsistencies in the database. While primary and foreign keys are used to create physical relationships between tables, their main purpose is to establish logical relationships in the database. Therefore, option C is the most appropriate answer.

Why Do Relational Databases Use Primary Keys and Foreign Keys