Re: Designing a structure for a personal database

"Stefan Ram" <ram@[EMAIL PROTECTED]
> wrote in message 
news:join-20080505155910@[EMAIL PROTECTED]
> "Arved Sandstrom" <asandstrom@[EMAIL PROTECTED]
> writes:
>>named relation****ps [...] so the join tables will
>>often have at least one extra attribute.
>
>  Which is the same as keeping a single join table
>  per named relation****p without an extra attribute.

This is true. But you'd want to ask whether or not you want one join table

for for work phone numbers, one for personal phone numbers, and possibly 
others for other phone numbers. Easier to have one join table for 
PersonInfo - PhoneNum, and keep an attribute in there that describes the 
nature of the phone number.

AHS