Re: How to insert values?

"Me" <me_at_privacy.net> schrieb im Newsbeitrag news:ahfhcvgeb6oohpvf0s7qv9bfv5fjlcv50l_at_4ax.com...
> On Sun, 18 May 2003 15:04:21 -0700, Ana C. Dent wrote:
>
> :No amount of hand waving makes a poor design "elegant".
>
> But this design is given in my text book and he uses it constantly to
> explain the rest of the queries in the book.
> He has given ER diagrams theory etc. all based on this example itself.
>
> Is the whole thing wrong?

If I understood You correct, You are using the data model and the queries given in the book,
which was very expensive, and now You are in trouble that the given queries do not run
as could be expected when published like this.

Sorry to say so, but even among the generally excellent books from Addison-Wesley,
there are errors still inside (in my case I found some in Oracle 8i Tuning and Administration by Thorpe,
due to printing mistakes in some example queries).

This does not mean that your book becomes unusuable (and you made me curious about it, btw).
It is just a pity that you maybe not able to follow the examples all the way.

In Your case, maybe I would start to modify the given examples to continue studying.

> And how does one create such tables?
>

There are many ways, starting from pen and paper to highly sophisticated third-party-tools
like Power Designer from Sybase. In any case You *can* construct circular constrained table sets.
But as far as I am concerned, I *would not* do that.

Correct SQL navigation with circular table sets and self references is very error-prown and tricky.
And this is what You experience right now.

> Thanks.
> --
> This is my last post in this thread.
> Thanks everyone, for your help.

hth, Jan (my last post here, too) Received on Tue May 20 2003 - 03:29:53 CDT