Different types of keys in DBMS and their features

Asked By James S Savoy 5 points N/A Posted on - 03/30/2016

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

• Status: Open
• Question Views: 285
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Anonymous

Answered By Paul M Lucero 5 points N/A #183287

Different types of keys in DBMS and their features

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.

 

About Paul M Lucero

Questions
20

Answers
10

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/30/2016
• Question Category: Anonymous