Re: About many to many relationships

[Jonathan Shaltz]

Hello again, Mr Bouman.
I'm not sure you really have a many-many relationship here. To be many-many, each record in A must be able to correspond to zero or more records in B, and vice versa. In your sample schema, the only way to make a Child correspond to more than one _different_ Parent is by duplicating rows in the Child table.
Maybe I misunderstand your purpose, but it looks like your Child table is acting as the intersection table.
You could do this:

Parents (Name)
Bill
Mary

Children (Name, ParentName)
George, Bill
George, Mary

...but then your database won't be normalized.