Question

What are examples of primary keys that most likely would be used for customers in a department store database? Check all that apply.

genders

blank values

years of birth

customer IDs

phone numbers

social security numbers

Answer 1

customer IDs

phone numbers

social security numbers

Step-by-step explanation:

A primary key may be defined as the special choice of the attributes which uniquely specify tuple in the relation. It is the set of columns where values uniquely identify each of the rows in the table.

It is use to find the unique record form the table or database. It is the key in the relational database which is unique for each record. It can be a unique number such as identification number, vehicle number, etc.

In the context, the primary keys which is used for the customers in a departmental store database are :

-- customer IDs

-- phone numbers

-- social security number

All these are unique set of number and they are the primary keys for a customer as they are uniquely identifies a particular customer. No other person is given the same phone number or phone number.