Re: Is this bad design ?

"ben brugman" <ben_at_niethier.nl> wrote in message news:40517714$0$281$4d4ebb8e_at_read.news.nl.uu.net...

> Just read what you wrote.

Ben, could you provide an actual or appropriately analogous physical organisational environment within which you "mothercentric"  application might exist? eg: a registrar of births?

Many applications use for example a 'person' table, which can be mother, but also child, father, teacher, etc. This one establishes unique identities. A second table 'mother' might hold the tuples 'person1' and 'person2'; 'person 1' and 'person 3' where 1 is mum and 2 and 3 are children.

Other tables, eg 'father', 'teacher' might be similarly structured.

However you sound like you are seeking a solution within an existent and specific data (schema) environment. If so, can you give some background to it.

-- 
Pete Brown
Winluck P/L
IT Managers & Engineers
Falls Creek
Australia
www.mountainman.com.au/software