Hi,
I am trying to develop a database to record student fee for a school.
My database has three Tables;
1. Student Information (Name, Registration Number, Admission Date etc)
2. Student Fee Information for Each Student (Monthly Fee, Bi-Annually Fee, Registration Fee etc)
3. Transaction Detail (Amount Due, Amount Received etc)
I am facing below issue.
A. How to calculate Due amount as Tuition fee is recurring each month.
Thanks,