Re: 2nd Normal Form

Yes, I considered this, however, I'm going on the assumption that Anne is
only interested in the current owner (as in Anne, a fellow book store
owner, etc.) rather than the customer (or perhaps just which customer
bought it). Anyway. it's good to point this out so Anne can decide which
is best.

Liz


Jean Friedberg wrote:
>
> For that matter, since "The Book" can have more than one "The Owner", you
> might well put the Owners in their own table ("Book/Owners" Table) as well,
> and since Owners can have any number of phone numbers, it probably makes
> sense to put them in their own tables too ("Owners/Phone Numbers").
>
.

Relevant Pages