What can I do at this situation?

kishor choure

14y3.2k

I create feetbl having following fields:

f_id bigint

f_receipt char

f_totalfee bigint

f_paidfee bigint

f_remainingfee bigint

f_paid_date datetime

f_due_date datetime

when I insert records in feetbl by following values

1 rec1 40000 20000 20000 20/07/2012 30/09/2012

Here I added one record but when candidate approach to me for giving all remaining fees with new receipt number then How can I update this remaining fees by new receipt number??

Give me solution of this by considering multiple records.

Thanks in advance.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sukesh Marla14y ago
Accepted answer
Select StudentId ,TotalFee-Sum( PaidFee ) From
Fees_Master inner join Fee_detail
On Fees_Master. FeeId = Fee_detail.FeeId
group by StudentId , TotalFee

Please mark this as correct answer if it helepd
Sukesh Marla14y ago
Any time dear..
let me knw if anythng required.
kishor choure14y ago
Thank you sir again. you solved my problem.
kishor choure14y ago
sir I have one question that How I know the remaining fees of each student if he given fees in 4 installment.
Sukesh Marla14y ago
Always welcome dear.

Please mark this as correct answer if it helepd
kishor choure14y ago
Thank you sukesh sir.
Sukesh Marla14y ago
First Change your Table Structure as follows

Table Fees_Master
Fields
FeeId----------->PK
StudentId
TotalFee

Fee_detail
FeeDetailId-------->Pk
FeeId-------------->FK
PaidFee
PaidDAte
DueDate

For every student say with total fee of 50000, there will be multiple entries for everry fee paid
Dont use separate column for Remaining fee

Always try to create normalized database...Try to avoid redundant data, By removing repeating rows and avoiding unecessary columns

http://www.sukesh-marla.com/2010/12/normalization.html

Refer above link for normalization..

Please check this answer as correct answer