School Monthly Fees Database

[mshakeelattari]

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!

[twinnyfo]

Your skeleton outline for the fees looks pretty good for a start.

I think you might have to figure out how to apply certain fees to certain students. For example, the Annual or monthly fees required of every student would apply to every student, and so you should have a way to charge the students for that fees automatically. However, a fine would only apply to certain students (and might vary in value), so these are things to think about when designing a fee table.

It may be wise to establish a true Fee Table (which would apply to all students) and would apply fees based on their status as students--I don't know if all students would be charged an annual and a monthly fee, but if a student was a full-time student who was charged an Annual fee, but no monthly fees, then you would build those rules into your DB.

Then, a second table for Fines, which might describe the infraction, with two additional fields for the lower and upper ranges of fines for such infractions.

Then, when a student received an invoice, it would list fees in one location and fines (if any) in another.

Maybe more for you to chew on than what you asked for, but these are things I would think about when building such a project.

Hope this hepps!