GATE CSE
First time here? Checkout the FAQ!
x
+2 votes
570 views

A prime attribute of a relation scheme $R$ is an attribute that appears

  1. in all candidate keys of $R$
  2. in some candidate key of $R$
  3. in a foreign key of $R$
  4. only in the primary key of $R$
asked in Databases by Veteran (75.6k points)   | 570 views
Why some?  Why not all?
check below comment.
I have a different doubt what if candidate key is= A then is A a prime attribute.??

2 Answers

+13 votes
Best answer
prime attribute is a constituent of a candidate key. it need not present in all candidate keys. hence option B is correct

correct me if i went wrong
answered by Veteran (10.9k points)  
selected by
@Sankar: yes you are correct it is sufficient if the prime attribute is in any of candidate key. did not read all the options , my bad

Consider a relation $R(ABCDE)$ and $FD =\left \{ AB\rightarrow CD,C\rightarrow B,D\rightarrow E \right \}$.

Here Candidate key  are $AB$ and $AC$.

Prime Attribute:$A$,$B$,$C$.

Now check is B is appearing in both C.K.?No

So prime attribute appears in some CK.

@ManojK sir , It wiould be nice if you could explain ( or verify ) how to find the prime attribute

AFAIK ,  Prime attributes are part of CK
Here CK are AB, AC .  Dependncies invloving them
AB→CD
AC→B
AC→A [ Trivial ]

$\Rightarrow$ (Prime attributes are part of Key ) Prime attributes are CD, C,D,B,A

As you stated Prime attributes are part of CK .

CD is nether CK nor part of any CK here then how CD,D becomes prime attribute.
Got it :)
–4 votes

(A) in all candidate keys of $R$

a prime attribute need not be necessaryly in the primary key alone, though attributes in all the candidate key are considered prime attribute

answered by Loyal (3.1k points)  
Answer:

Related questions

Top Users Feb 2017
  1. Arjun

    5288 Points

  2. Bikram

    4230 Points

  3. Habibkhan

    3952 Points

  4. Aboveallplayer

    3086 Points

  5. Debashish Deka

    2378 Points

  6. sriv_shubham

    2308 Points

  7. Smriti012

    2236 Points

  8. Arnabi

    2008 Points

  9. mcjoshi

    1690 Points

  10. sh!va

    1684 Points

Monthly Topper: Rs. 500 gift card

20,860 questions
26,012 answers
59,674 comments
22,114 users