Fee Management System Database

For that you have to check and compare from current date if due date is near or current date then you will send the notification to pay the instalment when they pay the instalment update the database with instalment count left and next due date. You can create event or webservice which will automatically check from database and send messages to the students

But the issue is every installment can have different due date and different due amount

Create three table one for course,students and for reminder Course table will contain courseid ,name and fee Student table will contain student id /admissionno , name ,courseid,discount,installment,dateof admission and date of course completion Reminder table will contain studentid ,courseid,no of installment,date upcoming installment So no of installment and date will updated when the student pay the fee