When using the relational model to represent two tables, one must ________.
A) add a foreign key to one of the tables
B) have more than two primary keys in the model
C) establish only N:M relationships between the tables
D) use metadata instead of foreign keys
E) minimize the number of columns in the second table

Question

Quizplus · Accepted Answer

In the relational model, one must add a foreign key to one of the tables to establish a relationship between the two tables. The foreign key refers to the primary key in the related table and allows for data to be connected between the two tables. Having more than two primary keys or establishing only N:M relationships are not requirements of the relational model. Using metadata instead of foreign keys is not a standard practice in the relational model, and minimizing the number of columns in the second table is not always necessary or appropriate.

When Using the Relational Model to Represent Two Tables, One