I have a student.dbf with fields 1.Regno 2.Name 3.hscboard 4.maths 5.Physics 6.chemistry, the hscboard having three types Namely 1. 01 2.02 3.03. I have 500 records for hscboard(01) and 250 records for(02) and 100 records for (03).

I want to change the three subject marks after normalisation for three hscboards. nomalisation for three hscboards given below

for hscboard(01)

maths =(maths*200)/100
physics =(physics*200)/100
chemistry =(chemistry*200)/100

for hscboard(02)

maths =(maths*200)/300
physics =(physics*200)/150
chemistry =(chemistry*200)/150

for hscboard(03)

maths =(maths*200)/150
physics =(physics*200)/150
chemistry =(chemistry*200)/150

I want to update these calculation values into my stduent.dbf for three hscboards.

can anyone help me How to write progamme