The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
+16 votes
830 views
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.5k points) | 830 views

2 Answers

+28 votes
Best answer

No.

A B C
$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.5k points)
edited by
+9 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.4k points)


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

39,440 questions
46,623 answers
139,377 comments
57,024 users