Posted by Tony Rogerson on 09/29/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

[Back to original message]