Question

Discuss the significance of Primary key column in a table with suitable example.​

Answer 1

A primary key is a special relational database table column (or combination of columns) designated to uniquely identify all table records. A primary key's main features are: It must contain a unique value for each row of data. It cannot contain null values.For example, a database must hold all of the data stored by a commercial bank. Two of the database tables include the CUSTOMER_MASTER, which stores basic and static customer data (name, date of birth, address, Social Security number, etc.) and the ACCOUNTS_MASTER, which stores various bank account data (account creation date, account type, withdrawal limits or corresponding account information, etc.).

Jai brainly!!!

Answer 2

In the primary key column, each row contains different values, no two rows can contain the same value. So, it will be easier to find out a column.

If there are two rows of students having same name, it is tough to find out. So name is not made the primary key. But admission number is different to every student. So it is made primary key.

Hope you like it. If so, rate it as brainiest answer.