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

From: raylopez99 <raylopez99_at_yahoo.com>
Date: Sun, 23 Dec 2007 03:47:40 -0800 (PST)
Message-ID: <e4020d50-9327-4597-8be6-414c771b829e@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.

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

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...

RL Received on Sun Dec 23 2007 - 05:47:40 CST