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 |
|
edi843
Starting Member
12 Posts |
 Posted - 2009-05-05 : 05:50:30
|
| i am building the part of the database that deal with the users. For the user i have to store the main field and the contact fields. My dilemma is if i have to store all the information in one table : tbl_user or in two diferent tables : tbl_user and tbl_contacts. The relation between the two tables is one to one. Any idea ? Thank you |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-05-05 : 07:01:52
|
Contacts can be adress, phone, eMail and what else...A User can have lots of eMail-adresses and lots of phonenummbers...So why you are sure this is always one to one?Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
edi843
Starting Member
12 Posts |
Posted - 2009-05-05 : 07:10:59
|
| Thank you for the reply.You are right, but let supose that the relation will be one to one (one user will have only one email, only one adress ect) In reality, it will be another table that can hold any amount of adresses, emails and other fields. But there will be some static fields like phone, adress. So the sitation is that the relation will be one to one. The question is , wich are the cases that i need another table for a one to one relation, and this one, is one of the cases. |
|
|
|
|
|
|
User Database