Functional Dependencies PPT Notes
I friends I found these notes when I was studying Normalization.I hope you find them useful. ๐
Replies
-
ISHAN TOPRERe: Functional Dependencies
Also see this! ๐ -
kevin88Hello
I am having a problem understanding dependency theory using Armstrong's Axioms, I have researched this online and I understand the axioms however I am struggling to understand a particular example. Can anyone provide me with any advice or help?
Can I post the example here?
Thank you -
ISHAN TOPREYes of course you can post your query here. Our CS/IT people will try to explain you the theory so that you will be able to solve your problem. ๐
-
kevin88Thank you ishutopre
I have two examples with answers but I do not understand how the answer has been derived:
Example 1:
Given
R < A= {V,W,X,Y,Z},
Gamma = { 1. V -> Y, 2. YW -> Z
3. Y -> W}>
RTP(required to prove) VWY -> Z and VXY ->Z
Answers:
VWY -> WY -> Z
VXY -> Y -> YW -> Z
augment 3 by Y Y -> W
Example 2:
Given the following relation
R < A = {M,N,O,P,Q,R,S},
Gamma = {Q->MO, S->R, M->SP}>
prove that PM->R
Answer:
PM -> SP -> S -> R
M -> SP augment by P
You are reading an archived discussion.
Related Posts
These are the lecture notes of Normalization form.
These are the notes of Relational Database design. ๐
Looking for BCNF Notes? I'm attaching these notes of BCNF. ๐ . Download them and let me know if you find them useful.
can someone advice me which of the two i shud use to design website??
plz post links to PHP e books ๐
hi all,
can anybody explain me open tie point?
regards
vibhor mittal