what is a candidate keya table may have more than


What is a candidate key?

A table may have more than one combination of columns that could uniquely identify the rows in a table; every combination is a candidate key. During the database design you can pick up one of the candidate keys to be the primary key. For e.g., in the supplier table the supplierid and the suppliername can be a candidate key but you will only pick up the supplierid as the primary key.

Request for Solution File

Ask an Expert for Answer!!
DOT NET Programming: what is a candidate keya table may have more than
Reference No:- TGS0161371

Expected delivery within 24 Hours