Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

difference between super key and candidate key

Super Key:
1. Super Key is used to identify all the records in a relation.
2. All super keys can not be candidate keys.	
3. Super keys are combined together to create a candidate key.
4. Super keys are more than Candidate keys.

Candidate key:
1. Candidate key is a subset of Super Key.
2. All candidate keys are super keys.
3. Candidate keys are combined together to create a primary key.
4. Candidate keys are less than Super Keys.
Source by www.tutorialspoint.com #
 
PREVIOUS NEXT
Tagged: #difference #super #key #candidate #key
ADD COMMENT
Topic
Name
4+1 =