Matt,
A table is missing. You need a third table to tie things together. In that
table is going to be:
BUYER | SELLER | ITEM, and anything else relavent to the sale. Your items
table needs to just have the attributes of the item and not things like
buyer, seller, etc.
Now for a turn to my favorite subject, data warehouse design. You have an
Item dimension, a Participant dimension, an Event dimension (bid, end of
auction, sale, payment made, etc.), a Time dimension and probably some
others that escape me at the moment (Geography?). Your measured fact(s) are
sale price, fees, number of bids . . . dunno what you need. So that's four
tables with the fact table at the center.
If it's too late to change the schema then I'd do the first option and split
my item table into two--piece one would be item information and piece two
would be sale information like I describe above.
"Matt Furze" <ma*******@cox.net> wrote in message
news:plbjd.89111$bk1.25078@fed1read05...
Hi, all,
I'm helping a friend with an auction database, and am stuck on this. Any
thoughts/suggestions would be appreciated!
Two tables - first is a table of Participants, with name, address, etc.,
including an ID number. Second table is a table of items, including
description, price, buyer #, seller #, etc. The buyer # and seller #
correspond to the ID number in the participant table. And participants
can be both buyers and sellers in the auction, or they may be only one or
the other.
What we want to do is produce a report when the participant checks out
showing items purchased, items sold, the amounts of each, and the net owed
the participant or net due from the particpant, depending on whether or
not he sold more than he purchased.
Any thoughts?
TIA
Matt