Question

Which of the following fields would not make a suitable primary key?
(1) A date of birth field
(2) An invoice number
(3) An AutoNumber field
(4) A customer's social security number​

Answer 1

A date of birth field would not make a suitable primary key.

Answer 2

The date of birth filed would not make a suitable primary key.

Answer: Option A

Explanation:

It is because primary keys are utilized to distinguish records in a database. They are surrounding us. Each time you experience a special number it may fill in as a primary key in a database.

The following would make a suitable key:

• The request number you get when you shop online could be the primary key of some request table in the shop's database, since it is a one of a kind worth.  
• Your standardized savings may be a primary key in some administration database.  
• A receipt number could be utilized as a primary key in a database table that stores solicitations that have been sent to customers.  
• A numeric client ID is regularly utilized as a primary key in a clients table.  
• An item number regularly alludes to an item number primary key field in an 'items' table.

Date of birth filed would not make a suitable primary key because it is not same for all clients and thus doesn’t need any distinguish primary key.