Re: Data denormalisation seems some attractive

2003-09-30 Thread Jared . Still
Stephane, From the limited information available, I will take a stab at what seems to be going on here. I don't think there are really 8 entities here first of all, at least not for the details given. No mention is made of the person being paid the commission, who the sale was too, the items

RE: Data denormalisation seems some attractive

2003-09-30 Thread Stephane Paquette
Hi Jared, Here are more details. One commission detail must be one of the types: manager override (12 fields) first year commission (15 fields), renewal service fee (10 fields), charge back (9 fields), vesting payment (1 field), subsidy (2 fields), supplementary commission

RE: Data denormalisation seems some attractive

2003-09-30 Thread Jared . Still
recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Data denormalisation seems some attractive Hi Jared, Here are more details. One commission detail must be one of the types: manager override (12 fields) first year commission (15 fields), renewal service fee (10