Super Key vs Candidate Key vs Primary Key. Understand the difference.

Описание: Super Key is super-set of a key which can uniquely identify each record in the table. Candidate Key is the Minimal Super Key. Primary Key is one of the Candidate keys. Primary Key is one or more attributes used to uniquely identify each record in the table.

#dbms #database #sql #mysql #exam #interviewquestions #primary_key #super_key

Image credits:
Unsplash: benwhitephotography
Unsplash: tommytom1818
Unsplash: sammywilliams
Pixabay: jillwellington
Pixabay: qimono-1962238