Fee Management System Database

Question

Student Gets Admission One course is assigned him and fee is decided on admission time not course creation time, Some discount offered sometime after that due amount is converted to number of installments Installment Reminders will be sent via sms Automatically There are no fix instalments these will decided on admission time how to create database for this can any body help

Vertika Chauhan · Answer

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

Vertika Chauhan · Answer

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

Balwant Singh · Answer

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

Fee Management System Database

Answers (3)