Re: DBDesign Q
Date: 24 Nov 2003 12:39:50 -0800
Message-ID: <d17bad25.0311241239.5d5fbf4e_at_posting.google.com>
raghuraman_ace_at_rediffmail.com (Raghuraman) wrote in message news:<66c7bef8.0311240532.731c4819_at_posting.google.com>...
> Hi,
>
> I think i does'nt make sence.
>
> The reason is for the creation of each table , another table should
> exists already vice-versa.
>
> So i think u can not create even a single table as that regard.
>
>
>
>
> With thanks
It is still not unusual for two tables to cross with a foreign key in
each pointing to the other. Circular relationships are not rare. As
another example,
a table of a publishers books can be linked with a table of the
publishers authors (books have authors and authors write books).
They can be murder to load (chicken or egg type question) and maintain (deletes have the same problem), but they are not unusual. Received on Mon Nov 24 2003 - 21:39:50 CET