Which method is better?

[undrcvr]

Hi,


I'm creating table Person and each person can have 0-or-more phone numbers and 0-or-more fax numbers. My question is which method is better to acheive that:

1. Table Person is connected to two tables: Fax(id, number) and Phone(id, number) in relationship one-to-many.
2. Table Person is connected to one table: Contact(id, number, [id type]) in relationship one-to-many and table Contact is connected to another table [Contact Type]([id type], type) in relationship one-to-many to determine if contact is fax or phone number.

I'm wondering which way is more efficient.

Thanks in advance.

[kimmer]

I'm not sure I understand your table names. You have a people table.
Add a VirtualAddresses table: PeopleId, VirtualAddress, VirtualAddressTypeId.
Also a virtualAddressTypes table: VirtualAddressTypeId, VirtualAddressType.

Now you can put your home email, work email, web address etc in the VirtualAddresses table if you want.

[undrcvr]

So you recommend 2nd method?

Ok, thx for the answer.

[kimmer]

yep, the second one.