Question

Columns that are keys to different tables than the ones in which they reside are called ________.

A) attributes
B) foreign keys
C) primary keys
D) internal records

Answer 1

A foreign key is a column that creates a link between data in different tables by referencing a primary key in another table.

Step-by-step explanation:

The correct answer to the schoolwork question is B) foreign keys. In database management systems, a foreign key is a column or a combination of columns that is used to establish a link between the data in two tables. It acts as a cross-reference between tables because it references the primary key of another table, thus establishing a relationship between them. For example, in a database with a table for students and a table for classes, a student's ID might be a primary key in the student table and a foreign key in the class table if that class table includes a field to indicate which students are enrolled in each class.