The Gateway to Computer Science Excellence
+1 vote
255 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.3k points) | 255 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,647 questions
56,493 answers
195,481 comments
100,789 users