Comp Sci How to find candidate keys in this relation?

  • Thread starter Thread starter shivajikobardan
  • Start date Start date
  • Tags Tags
    Relation
AI Thread Summary
To find candidate keys in the given relation with functional dependencies AB=>CD, C=>A, and D=>B, the method of examining the right-hand side (RHS) is highlighted. Since all attributes are present in the RHS, identifying potential candidate keys becomes challenging. A more effective approach involves calculating the closure of attribute combinations to determine if they can derive all attributes in the relation. The discussion emphasizes the need for concise methods in database management systems (DBMS) to avoid verbosity. Ultimately, a video resource was found helpful in clarifying the process of finding candidate keys.
shivajikobardan
Messages
637
Reaction score
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
my issue fixed after watching this video Qno.3
 

Similar threads

Back
Top