Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Relations, dependencies and normal form

Author  Topic 

diydave
Starting Member

1 Post

Posted - 2013-08-16 : 10:19:19
Hi everybody! 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 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!

/David
   

- Advertisement -