Comp Sci How to find candidate keys in this relation?

  • Thread starter Thread starter shivajikobardan
  • Start date Start date
  • Tags Tags
    Relation
Click For 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
 

Thread 'Bending Stress and Shear Stress'

I have a question that I couldn’t fully understand its logic. The professor asked us to calculate the shear resistance and moment about the X and Y axis, using the given cross-section and the values of compressive and tensile stresses. I understand how to get the moment, but I’m confused about how to find the shear resistance from these stresses. Could you explain or clarify the method?
View full post »

Similar threads

Comp Sci How to find candidate keys here in DBMS?
  • · Replies 2 ·
Replies
2
Views
1K
Comp Sci Functional Dependency Solving Algorithm for Minimal Cover
  • · Replies 1 ·
Replies
1
Views
2K
Comp Sci RSA to encrypt English Alphabets, any restrictions?
  • · Replies 7 ·
Replies
7
Views
2K
Comp Sci Implementing a PriorityQueue w/ a Doubly-Linked List (Java)
  • · Replies 2 ·
Replies
2
Views
4K
B. comp sci after b. and m. math
  • · Replies 3 ·
Replies
3
Views
2K
Finding maximum shearing stress in connected shafts
  • · Replies 2 ·
Replies
2
Views
4K
How does relativity affect the detection of atmospheric muons?
  • · Replies 11 ·
Replies
11
Views
2K
Advice: Doing grad school abroad and getting a masters instead of PhD
  • · Replies 15 ·
Replies
15
Views
4K
How to Find Housing and Succeed as a Visiting Scholar at Berkeley?
  • · Replies 3 ·
Replies
3
Views
1K
Comp Sci Why Does My Java Program Say Cannot Find Method?
  • · Replies 1 ·
Replies
1
Views
3K