When using the relational model to represent data, one must ________.
A)add a foreign key to one of the tables
B)have more than ten tables in the model
C)establish only N:M relationships between tables
D)use metadata instead of foreign keys

Question

Quizplus · Accepted Answer

In the relational model, data is represented by tables consisting of rows and columns. In order to establish relationships between tables, a foreign key must be added to one of the tables which references the primary key of another table. Therefore, option A is the correct choice. Option B is not necessary as the number of tables in the model is dependent on the complexity of the data being represented. Option C is incorrect as the relational model supports other relationships, such as one-to-many and one-to-one. Option D is also incorrect as metadata is used to describe the data and its structure, but foreign keys are still necessary to establish relationships between tables.

When Using the Relational Model to Represent Data, One Must