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