| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: A newbie paradox: is this a PK-FK (relationship) problem, or programming problem?
I don't see you making any suggestions. Surely you don't think that one
table per brokerage could ever be an appropriate answer!
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message news:476d71c2$0$5279$9a566e8b_at_news.aliant.net...Received on Sat Dec 22 2007 - 14:51:57 CST
>
> You also don't know a damned thing about his requirements. I find it
> absurd to offer a detailed design on the basis of complete ignorance.
>
>>>
>>>As I type this, I believe the cleanest approach is simply to have many
>>>tables for different stock accounts for this individual: one table
>>>per brokerage, say the person might have an IRA stock account, a
>>>speculative stock account, a conservative stock account, etc, with
>>>different stock brokerage account numbers, and with the accounts all
>>>buying on occasion the same stock (same stock symbol), and that's
>>>fine.
>>>
>>>Any thoughts?
>>>
>>>RL
>>
>>
![]() |
![]() |