130k views
2 votes
In a database, each table has an individual key called the ____________.

a. Foreign Key
b. Map Key
c. DBMS Key
d. Primary Key

1 Answer

2 votes

Final answer:

In a database, each table has an individual key called the Primary Key, which is a unique identifier for each record in the table, maintaining data integrity.

Step-by-step explanation:

In a database, each table has an individual key called the Primary Key. The primary key is a unique identifier for each record in the table, ensuring that no two rows have the same value in the primary key column. This is essential for maintaining data integrity within a database. For example, in a table containing student information, the student ID might serve as the primary key.

Unlike the primary key, a Foreign Key is a field (or collection of fields) in one table that uniquely identifies a row of another table. It is used to establish and enforce a link between the data in two tables. The foreign key effectively points to the primary key of another table, creating a relationship between the two tables.

User Abest
by
8.2k points