You are here: Re: Help with phoneBook db design « MsSQL Server « IT news, forums, messages
Re: Help with phoneBook db design

Posted by Tony Rogerson on 10/02/48 11:34

I'd certainly break the name up into first and last names, probably
nvarchar(50), also, you'll need other information to uniquely identify this
individual.

Phone number can be broken up into country code, area code and number as
well.

Do you need to think about extension number too?

I'd make the phone number (country code, area code, number) a primary key,
but use a surrogate key to foreign key between the individual and the phone
number.

So you will have 3 tables...

individual
other identifying cols...
first_name
last_name
id int not null identity constraint sk_individual unique nonclustered

phone_number
country_code
area_code
local_number
id int not null identity constraint sk_phone_number unique
nonclustered

individual_phone_number
individual_id int not null references individual( id ),
phone_number_id int not null references phone_number( id )

Tony.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"E B via SQLMonster.com" <u6539@uwe> wrote in message
news:58b8a9c7d1765@uwe...
> so this is my question, i need some advice for implementation.
>
>
>
> Tony Rogerson wrote:
>>How far have you got so far? Can you post your table designs.
>>
>>> Hi All!!
>>>
>>[quoted text clipped - 8 lines]
>>>
>>> TNX
>
> --
> Imagination is more important then knowledge. (A.Einshtein)
>
> Message posted via http://www.sqlmonster.com

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация