Question

Pratibha is working in a bank. She is creating a database to store the details of the bank customers. Which of the following fields of table Bank_Customer can be selected as primary key?​

Answer 1

Acc_No

Step-by-step explanation:

Given

See attachment for table Bank_Customer

Required

Which field can be used as primary key

A field, once made the primary key, cannot contain duplicate entries.

This means that Pratibha has to select a field that can be unique to all customers.

From the table, we have:

Acc_No
`\to` No two customers can have the same account number

Cust_Name
`\to` Multiple customers can have the same name

DOB
`\to` Multiple customers can have the same date of birth

PAN_NO
`\to` No two customers can have the same pan number; however, pan number is often issued by tax department of a country.

Opening_Bal
`\to` Multiple customers can have the same opening balance,

Hence, the field to use as primary key is:

Acc_No