Which of the following describes something in a database that refers to the unique identifier in the parent table?
Click on the arrows to vote for the correct answer
A. B. C. D.A.
The correct answer is C. Foreign key.
A foreign key is a column or a set of columns in a database table that references the primary key of another table. In other words, it is a field in one table that uniquely identifies a row of another table.
For example, consider two tables, "Customers" and "Orders". The "Customers" table has a primary key column named "CustomerID". The "Orders" table has a foreign key column named "CustomerID" that references the "CustomerID" column in the "Customers" table. This creates a relationship between the two tables such that each order can be associated with a single customer.
An attribute is a characteristic or property of an entity, such as a column in a table. A constraint is a rule or restriction placed on the data in a database. A schema is a logical container that holds database objects, such as tables, views, and indexes.
Therefore, none of the other answer choices describe a unique identifier in the parent table like a foreign key does.