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.
Author |
Topic |
jangozo
Starting Member
1 Post |
Posted - 2009-10-04 : 10:40:28
|
Hello,I'm trying to represent an instant messenger's network of contacts in a database. As most of you know each client will have many contacts who will also have many contacts.The design I'm thinking of now is the following:USERS| username | password || a | none || b | none || c | none |CONNECTIONS| connection id | username 1 | username 2 || 1 | a | b || 2 | a | c || 3 | b | c |Do you agree this is the best way to represent a network using a database? If not what would you suggest?Thanks,Vladimir |
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-10-04 : 15:55:24
|
HiTry this....User_TableUser_ID User_NAME10 raj11 daksha 12 yesvanth Connection_TableCon_ID Con_Desc110 xxx120 yyy130 zzzUser_Connections_TableUser_id Con_ID10 11010 12010 13011 11012 120 I have done with second normal form...Eliminate Redundant Data - If an attribute depends on only part of a multi-valued key, remove it to a separate table.-------------------------R... |
|
|
|
|
|