I'm trying to create a database that can store client, employee and sales data. I also need to have the database calculate the quarterly commissions the sales employees have earned.
However, the commissions are deferred over future quarters and I need the database to calculate future quarterly...