question

maheshamanu avatar image
maheshamanu asked

What are the important Keys in DBMS?

I wanted to understand the types of keys in DBMS with examples and please mention which keys is most important.

databaseprogrammingprogramming-language
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image
anthony.green answered

Google Bing etc are your friend, there are plenty on the topic with a simple Google search


https://www.guru99.com/dbms-keys.html

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

BadKarma avatar image
BadKarma answered

Although there are multiple Important keys in DBMS, but each key has its own role.


Keys play an important role in the relational database. It is used to uniquely identify any record or row of data from the table. It is also used to establish and identify relationships between tables.

You can go through all the keys with example - https://www.scaler.com/topics/keys-in-dbms/

  1. Super key

  2. Candidate key

  3. Primary key

  4. Alternate key

  5. Foreign key

  6. Partial key

  7. Composite key

  8. Unique key

  9. Surrogate key

  10. Secondary key
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.