Commissions Paid & Discounts in Payment DB

I'm creating a financial db that includes the tracking of commissions paid out & discounts given.

Referrals of clients will most likely be clients themselves. That is why the referrals table has 2 fields that are foreign keys from the org table. How would you track commissions paid? Just add a field to transaction table or create a new table?

As far as discounts given, clients are given a percentage that will be discounted until thier total discount is met. Is my implementation adequete?

organization
a) id
b) name
c) web

contact
a) id
b) org_id
c) name
d) phone
e) email
j) username
k) password

service
a) id
b) name

org-serv
a) id
b) org_id
c) serv_id
d) frequency
0 (one-time)
1 (annually)
4 (quarterly)
12 (monthly)
e) pres_cost
f) beg_date
g) end_date (stops billing, but yet records past subscriptions)

Discount
a) Id
b) org_id
c) percent
d) cum_disc
e) tot_disc

transaction
a) id
b) o-s_id
c) date
d) cost
e) discount
f) amt_paid

referral
a) id
b) referrer (org_id)
c) client (org_id)
d) comm_rate

I APPRECIATE ANY ASSISTANCE.

I do not understand exactly what the database should store, so I can only
give a shot in the dark.

As long as the database design is normalized up to the 3th normal form, the database design is okay.

http://www.guides.sk/reldb_dsgn/rdbd_l1.htm#start

Thread resolve by inactivity from original poster.

If you still need help, please change the status back to unresolved.