define primary key and candidate key.
Answers
Answered by
3
A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys, but one candidate key is unique, and it is called the primary key.
evaebey211:
mark me brainliest
i saw same definition on Wikipedia
so humble request to u Write answer in different way
A candidate key is a set of columns that can identify any database record without referring to any other data. A table may have one or more candidate keys,one candidate key is the primary key.
Answered by
7
primary key
A primary key is a special relational database table column (or combination of columns) designated to uniquely identify all table records.
A primary key’s main features are:
It must contain a unique value for each row of data.It cannot contain null values.A primary key is either an existing table column or a column that is specifically generated by the database according to a defined sequence.
A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data. Each table may have one or more candidate keys, but one candidate key is unique, and it is called the primary key. This is usually the best among the candidate keys to use for identification.
When a key is composed of more than one column, it is known as a composite key.
please mark me as the brainliest
Similar questions