use akademik
create trigger masuk on tabel_nilai for insert
as
set new.nilai_angka = (new.tugas + new.uts + new.uas)/3
if new.nilai_angka > 0 and new.nilai_angka < 1 then
set new.nilai_huruf = 'e'
else if new.nilai_angka >1 and new.nilai_angka <2 then
set new.nilai_huruf = 'd'
else if new.nilai_angka > 2 and new.nilai_angka <2.5 then
set new.nilai_huruf ='c'
else if new.nilai_angka > 2.5 and new.nilai_angka <3.5 then
set new.nilai_huruf = 'b'
else set new.nilai_huruf ='a'
end if
end