I have some issues in understanding about relations and dependencies. I will show two examples and what I want to know:
Assume the relation GTX {G,T,X}
with the following dependencies:
G,X -> T
T -> X
or this one:
Relation {W,X,Y,Z}
:
X,Y -> Z
Z -> W
- So to my question, how do I properly draw a dependency diagram for this kind of relations? (tutorials or/and explanations are much appreciated)
- How do I see what the primary key is? (I know what a pk is)
- In which normal form are the relations?
I have never been able to understand this fully and always got confused by the tutorials I found. I appreciate all answers!