Im trying to design a Logical Schema for a DB Design, I expect the DB to grow to a very large size, so I need to find the best possible design.
1. An Advertisement is charged a Fee always.
2. An Event is Charged a Fee if the listing is made by a Profitable Organization.
3. A Profitable Organizations Listing is charged a Fee.
4. All Fees are Charged to Accounts.
I Have used three associative entities, Listing_Fee, Event_Fee, and Ad_Fee, is this an OK design solution, are the joins a concern. I used this setup as opposed to a single table for all three, because each row, will always omit two other columns, (int* 2) * Number of Records, This cold be a Huge Number, and large amount of redundant space.
Its not exactly its own entity, it sits as ad_fee between an advertisement and the Account. So [PKFK] AD_ID and [PKFK] Account_ID. I Was thinking I could Assign the Price too the Associative Entities, so There will be an individual record of each charge (As there will be one for each time period). Or Should I use an Invoice or Something else?