Hi all,
I came up with the following design for the internal BI system.
The first table is used to store the payments. (Payments table)
I also need to calculate the monthly sales statistics for each sales representative along with their quota (a pre...