Database - Data Models into Database Designs - Discussion
Discussion Forum : Data Models into Database Designs - True or False (Q.No. 2)
2.
The terms alternate key and candidate key mean the same thing.
Discussion:
3 comments Page 1 of 1.
Shiv said:
2 months ago
It is false, as alternate keys are the keys which are not selected as primary keys from candidate keys.
(1)
Sanjay said:
1 decade ago
So you can not say both are having same meaning, alternate keys are those candidate keys which are left after choosing primary key.
Rajesh said:
1 decade ago
Candidate key=Alternatekey + Primary key
If table have more than one candidate key then there will be only one primary key and rest are the alternate key.
If table have more than one candidate key then there will be only one primary key and rest are the alternate key.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers