Consider why it is important to set a primary key in a table.

Question

What will be an ideal response?

Answer 1

When designing your database tables, it is important to determine the primary key because this is the field whose values will uniquely identify each record in a table. For example, in a Customers table, the CustomerID field will uniquely identify each customer in the database. The primary key enables you to join the table to a related table via a common field and is indexed for faster data retrieval.