I have designed a database with tables:
*Students
StudentID (PK), SName, DOB, .....
*Classes
ClassID(PK), Grade, Section, Session,....
*ClassStudents
StudentID (FK), CID(FK), RollNo, .....
and other tables regarding the Exams and results etc.
I want Fee submission and fee vouchers for students from varoius classes and for Annual fees, Monthly Fees, Fines and other charges be managed by the database. The tables I need include some like:
*FeesDetails:
FeeID (pk), FeeType (Annual, MOnthly, Fine, ...), Amount
What other tables should I need? Thanking in anticipation!