Different types of keys in DBMS and their features

Asked By 5 points N/A Posted on -
qa-featured

What are the different types of keys used in relational DBMS? What is the purpose of primary key? What is the difference between a primary key and unique key

SHARE
Answered By 5 points N/A #183287

Different types of keys in DBMS and their features

qa-featured

Hi

The different types of keys used in DBMS are: –
• Super Key
• Candidate Key
• Primary Key
• Foreign Key
• Alternate Key
• Unique Key
A primary key is a modification of a candidate key that neither allows NULL values nor allows repetitive values. A unique key however, allows NULL values but doesn’t allow repeated values.
 

Related Questions