Answer:
Acc_No
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 [tex]\to[/tex] No two customers can have the same account number
Cust_Name [tex]\to[/tex] Multiple customers can have the same name
DOB [tex]\to[/tex] Multiple customers can have the same date of birth
PAN_NO [tex]\to[/tex] No two customers can have the same pan number; however, pan number is often issued by tax department of a country.
Opening_Bal [tex]\to[/tex] Multiple customers can have the same opening balance,
Hence, the field to use as primary key is:
Acc_No
