Question

a table named customer has following columns customer ID name City mobile number identify which column cannot be specified as primary key and why

Answer 1

Hey friend !!

Here is your answer.

Name and city can't be specified as primary key because two individuals may have the same name and city.

While customer ID and mobile number can't be same for two people.

Hope it helps.

#pragya_singh

Answer 2

"Name and city" are the answer for the above question.

Explanation:

• The primary key is a key which is made by any attribute or a collection of attributes (in sometimes), to read the data of a table. It is a column of a table that never holds the NULL or any duplicate data.
• The above question has one table of some columns. The question wants to ask which column can not be a primary key and that is Name and city column.
• It is because the Name and city column can have duplicate data. After all, there may be two or more persons with the same name or living in the same city. By this scenerio, the city or name column can hold the duplicate data which reflects the property of a primary key.
• While the other column can be a primary key because all columns can be unique in any case except the name and city column.

Learn More:

• Primary key: https://brainly.in/question/4146387