Endre
Registered User.
- Local time
- Today, 19:50
- Joined
- Jul 16, 2009
- Messages
- 137
How do you set up a contact database? A general discussion on normalising a "best" database design. Especially helpful for the noobies.
Setting up a contact database sounds nice and simple......However:
I have a business cellphone number and a personal cellphone number.
I have a deskphone at my office, and a shared fax number which is also used by other people in my office downtown at my corporate address.
I have 3 clients that I work for at their locations that also have deskphone numbers (also shared in open plan office). And eMail addresses - which do get forwarded to, but people need to know my alias email addresses.
I live at home, with my wife. The house also has a telephone and fax number and home address which our family shares.
My daughter has a cellphone, but she can't take it to school, so I must call the school if someone else must collect her from school and get a message to her.
So, is it still so easy? Should this be a subjective discussion, or is there technically "one (and only one) best design solution" for this? (I'm only talking table design) BTW, I really really really dislike autonumbering and never, ever use it. Is this a personal thing, or do others feel the same way?
Setting up a contact database sounds nice and simple......However:
I have a business cellphone number and a personal cellphone number.
I have a deskphone at my office, and a shared fax number which is also used by other people in my office downtown at my corporate address.
I have 3 clients that I work for at their locations that also have deskphone numbers (also shared in open plan office). And eMail addresses - which do get forwarded to, but people need to know my alias email addresses.
I live at home, with my wife. The house also has a telephone and fax number and home address which our family shares.
My daughter has a cellphone, but she can't take it to school, so I must call the school if someone else must collect her from school and get a message to her.
So, is it still so easy? Should this be a subjective discussion, or is there technically "one (and only one) best design solution" for this? (I'm only talking table design) BTW, I really really really dislike autonumbering and never, ever use it. Is this a personal thing, or do others feel the same way?