CS Electrical And Electronics
@cselectricalandelectronics

What are the different types of keys in the database?

All QuestionsCategory: DatabaseWhat are the different types of keys in the database?
chetan shidling asked 4 years ago

I need short information.

1 Answers
chetan shidling answered 4 years ago

The different types of keys in the database are:
 

  1. Super key = Candidate Key + Unique Key
  2. Primary key = CustomerID
  3. Alternate Key = PanNumber
  4. Candidate Key = CustomerID and PanNumber
  5. Foreign Key – CustomerID