The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
+17 votes
An instance of a relational scheme $R(A, B, C)$ has distinct values for attribute $A$. Can you conclude that $A$ is a candidate key for $R$?
asked in Databases by Veteran (59.8k points) | 1.1k views

2 Answers

+32 votes
Best answer


$1$ $5$ $6$
$2$ $4$ $7$
$3$ $4$ $5$

Suppose this is the relational instance at any point of time.

Now we may see that $A->BC$ holds for this instance, hence A+={ABC}.

But FD s are defined on the schema itself not the instance, so based on the state of the instance we cannot say what holds for schema (there can be a many instances for R).

answered by Active (3.6k points)
edited by
+16 votes
instance of a relation is just a snapshot at any instant of time it is not whole table. it may be possible in that instance of a relation some attribute behave like key but who knows in other instance of a relation this attribute is not key, some other attribute behave like key. so w/o whole table we cannot say anything about key of rel
answered by Active (4.7k points)
Well Explained

Related questions

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

46,769 questions
51,221 answers
66,581 users