The Gateway to Computer Science Excellence
+1 vote
260 views
Since candidate key is a minimal key and it is a proper subset of a super-key , then how is it that for a candidate key ,its proper subset is not a super key ?
in Databases by Loyal (6.4k points) | 260 views

1 Answer

+6 votes
Best answer
A candidate key is the minimal superkey. That means if we try to remove some attributes from the candidate key (minimal super key) we will no more get a superkey as it was the minimal. Hence, any proper subset of the candidate key is not a superkey.
by Active (3.8k points)
selected by
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,737 questions
57,284 answers
198,183 comments
104,863 users