88.9k views
0 votes
What is primary key? List any two advantage of it.​

2 Answers

7 votes
A primary key is a column of set columns heft ref
User Momh
by
8.1k points
5 votes
A primary key is a column or set of columns in a database table that is used to uniquely identify each row in the table. It is a fundamental element of database design, as it ensures that each row in a table can be uniquely identified and helps to enforce the integrity of the data.

There are several advantages to using a primary key in a database table:

Uniqueness: A primary key ensures that every row in a table has a unique identifier, which makes it easier to distinguish one row from another.
Data integrity: A primary key helps to ensure that the data in a table is accurate and consistent, as it can be used to enforce relationships between tables and prevent data inconsistencies.
Performance: A primary key can be used to optimize the performance of a database, as it can be used to quickly locate and retrieve specific rows of data.
Data security: A primary key can be used to secure sensitive data in a database, as it can be used to control access to specific rows of data.
User Aharon Manne
by
7.6k points