Click here to Skip to main content
15,896,730 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I designing a system where it will be used in the tutoring, the tutoring will be teach: Mathematics, English, Physic and Mandarin. I already designed the students registration, editing the students info or deleting the students info. But, I couldn't come up with the idea on how to design the students fee. (e.g: The Student Name "Kaoru" with the Student ID "TP024836" wants to pay his bills for month "January 2014", and the fee is $50 per month). How could I design like this? Should I design manually on Access Database, or I design it on Windows Forms and Insert it to Access Database and display it on DataGridView? And what components that I have to provide in order to achieve this student payment? Thank you.

Best Regards
Posted
Updated 2-May-14 0:20am
v2

1 solution

Probably a combination of the two: you certainly need a database element to record payments, and you probably need to include payments owed in that table.

But you probably want to include WinForms to enter the payment, and to add the "new" debts to the system at the appropriate time.

So what I'd do is play with it on paper, with a pencil. Try to handle the payments (and remember there could be deferments, pre-payments, overpayments, and underpayments as well as correct ones) on paper and see what you need. When you have a paper system that works, it should be pretty obvious what is DB and what is WinForms, and what you need to do from there.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900