Computer Science, asked by Umeed3666, 1 year ago

what is 'primary key'? explain its use.

Answers

Answered by suniltty180
5
A primary key, also called a primary keyword, is a key in a relational database that is unique for each record. It is a unique identifier, such as a driver license number, telephone number (including area code), or vehicle identification number (VIN). A relational database must always have one and only one primary keyWhy do I need to use a primary key?

Well, even though the column set as a foreign key may have duplicate data in multiple rows, it is still relying on the unique information in the primary key. If there was non-unique rows in the primary key column, there would not be a use for a foreign key because you would be mapping one row in the foreign key to two rows in the primary key. In essence, primary to foreign keys ensure that:


Umeed3666: ok
Answered by gardenheart
4
if we apply primary key to any field in MS ACCESS it means that the particular field will only contain unique value.
steps-

Umeed3666: explain its use
gardenheart: if we put it on a field then one name or any number cannit be repeated in that field
suniltty180: sorry
Umeed3666: why
suniltty180: for not give right answer
suniltty180: answers change kiya hai
Similar questions