How to find candidate keys in this relation?

  • Comp Sci
  • Thread starter shivajikobardan
  • Start date
  • Tags
    Relation
In summary, a candidate key is a set of attributes in a relation that uniquely identifies each tuple. To determine candidate keys, functional dependencies of attributes must be analyzed. Relations can have multiple candidate keys, which are known as alternate or secondary keys. The primary key is a chosen candidate key used for identification, while a candidate key can potentially serve as a primary key. However, not all candidate keys are equally good and it is important to carefully consider and evaluate them before selecting a primary key.
  • #1
shivajikobardan
674
54
Homework Statement
finding candidate keys
Relevant Equations
none
These are the FDs:
AB=>CD
C=>A
D=>B

My method of finding candidate keys is:

1) Look at RHS
2) Whatever isn't there could be a candidate key. (Find its closure).
But here everything is in RHS. So, I'm confused.
Can you share a better method to find candidate keys without getting too verbose(DBMS is too verbose).
 
Physics news on Phys.org
  • #2
my issue fixed after watching this video Qno.3
 

Similar threads

  • Engineering and Comp Sci Homework Help
Replies
2
Views
666
  • Set Theory, Logic, Probability, Statistics
Replies
1
Views
619
  • Engineering and Comp Sci Homework Help
Replies
1
Views
1K
  • Introductory Physics Homework Help
Replies
8
Views
163
  • Special and General Relativity
Replies
16
Views
715
  • Introductory Physics Homework Help
Replies
11
Views
877
Replies
15
Views
2K
  • Special and General Relativity
Replies
20
Views
826
  • Special and General Relativity
Replies
2
Views
654
  • Introductory Physics Homework Help
Replies
2
Views
1K
Back
Top