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

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


"raylopez99" <raylopez99_at_yahoo.com> wrote in message news:e4020d50-9327-4597-8be6-414c771b829e_at_f3g2000hsg.googlegroups.com... On Dec 23, 6:31 am, "David Cressey" <cresse..._at_verizon.net> 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
>scalable...

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

Original text of this message