Re: A newbie paradox: is this a PK-FK (relationship) problem, or programming problem?

From: David Cressey <>
Date: Sun, 23 Dec 2007 13:00:59 GMT
Message-ID: <f_sbj.3263$pi7.1901_at_trndny02>

"raylopez99" <> wrote in message On Dec 23, 6:31 am, "David Cressey" <> wrote:

> Thanks David Cressey.

>I do have some books, and am working through the David Louison book,
>and at some point might buy more books, but it seems to me that there
>is no formal math you can learn to make a database normalized; indeed
> "trial and error" and intuition is what works.

Well, I tried... but that may have been my error.

>Obviously you, a 20+ year veteran, and some of the other posters here
>have a lot more trial and error experience than I do.

I had a lot of learning modes other than trial and error available to me 20+ years ago. The best was mentoring from people who knew more than I did.

>BTW I did like the solution by Tina--it seems to do the trick in
>segregating symbol from brokerage account, which was I think my
>problem in the original design.

>Also my proposed clean (dirty) solution in retrospect is not that

Good luck. Received on Sun Dec 23 2007 - 14:00:59 CET

Original text of this message