Re: A newbie paradox: is this a PK-FK (relationship) problem, or programming problem?
Date: Sat, 22 Dec 2007 18:37:47 -0400
Message-ID: <476d91bf$0$5296$9a566e8b_at_news.aliant.net>
Douglas J. Steele wrote:
> I don't see you making any suggestions. Surely you don't think that one
> table per brokerage could ever be an appropriate answer!
Douglas,
David Portas already covered everything quite well, and I didn't have much to add to his post.
Ray,
If you think about things for even a millisecond, you will recognize the importance and substance of the absurdity of lengthy and detailed design on the basis of complete ignorance. I think you will find the replies to the observation lack substance entirely. I will leave it for you to judge.
As for your original problem, your declared constraints do not match your conceptual model of how the system should behave. That is a clear sign that one or both are wrong.
I reiterate David's suggestion to learn the theory so you can understand and evaluate these things for yourself. I also draw your attention to David's predictions regarding guesswork. Received on Sat Dec 22 2007 - 23:37:47 CET