Computer Science, asked by Bidhansupakar, 1 year ago

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

Answers

Answered by divyansh20021
2
I think mobile number can be specified as primary key it's value is unique.
please mark as brainliest if you like so
Answered by gaurav2013c
7
The Name and City could not be specified as primary key because two or more than two persons can have same name and two or more persons may belongs to same city....

gaurav2013c: This question came in today's exam
Anonymous: Thanks..I too write the same
gaurav2013c: Yeah its correct.....
Anonymous: but i think city name is more correct because it has a higher chance of two persons having same city name than ur name
gaurav2013c: See the question again dear...... There was written "Identify which column(s)" it means that there maybe more than one
Anonymous: yes i know that
Similar questions