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:
- Table Person is connected to two tables: Fax(id, number) and Phone(id, number) in relationship one-to-many.
- 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.