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
 
Thread 'Have I solved this structural engineering equation correctly?'

Thread 'Have I solved this structural engineering equation correctly?'

Hi all, I have a structural engineering book from 1979. I am trying to follow it as best as I can. I have come to a formula that calculates the rotations in radians at the rigid joint that requires an iterative procedure. This equation comes in the form of: $$ x_i = \frac {Q_ih_i + Q_{i+1}h_{i+1}}{4K} + \frac {C}{K}x_{i-1} + \frac {C}{K}x_{i+1} $$ Where: ## Q ## is the horizontal storey shear ## h ## is the storey height ## K = (6G_i + C_i + C_{i+1}) ## ## G = \frac {I_g}{h} ## ## C...
View full post »

Similar threads

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

Hot Threads

Recent Insights

Back
Top