Difficulties when creating a database

Question

1.00/5 (1 vote)

See more:

I made a tuition payment system application in vocational high schools using VB.NET and SQL Server database. I have a problem on the database, please help me create a database with a view Form (Name, Student Identification Number, Department, of Army, monthly fees, Pay per month, description)
I'm confused on Pay, when students want to pay three months at a time, whether the user must enter the data three times ..? If true, what about the database ...?
please, help me to solve this problem.

Posted 10-Mar-12 22:16pm

patar sii miaw

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Wayne Gaylard · Answer 1 · 2012-03-10T22:25:00

Solution 1

This would all depend on your requirements. Personally I would create another table altogether for payments, which would include a field for amount paid, and another field for next payment due, and I would link this table to students with the student id.

Posted 10-Mar-12 22:25pm

Wayne Gaylard

Comments

patar sii miaw 11-Mar-12 4:29am

If so, how will the report?
if the report does not fall apart ..?

Wayne Gaylard 11-Mar-12 4:33am

Sorry, your question does not make sense, but I assume you mean you want a report from both tables. You will have to create an SQL Join query like "SELECT s.studentid, p.amountpaid, p.nextpaymentdue FROM students s INNER JOIN payments p ON s.studentid = p.studentid" or similar.

patar sii miaw 11-Mar-12 4:41am

I want to group all in one page report that has. what should i do ...?

Wayne Gaylard 11-Mar-12 4:52am

I syggest you study up on database design a bit.

patar sii miaw 11-Mar-12 7:09am

Ok, thank you