Question

A table named "customer "has the following columns: customer ID name City mobile number. identify which column cannot be specified as a primary key and why?

Answer 1

Hey folks..!!

Today's question..

Here's your answer...

____________________________________________________________

That's simple Name and City can not be specified as primary key because they are not unique.Many person can have same name and their cities can also be similar.But CustID and mobile no. will be unique for every customer.

___________________________________________________________

I HOPE YOU GET IT...


@Rêyaañ11

Answer 2

Name and city can’t as they can be and primary key can’t have same records