CREATE TABLE krs (nim char(10),kode char(10),nip char(10),uts int(50),uas int(50),akhir float,huruf char(10),bobot char(10)); 1. Field Akhir = (40/100*uts)+(60/100*uas) 2.Field Huruf = A : >= 85 B : 75-85 C : 60-74 D : 40-59 E : < 40 3.Field Bobot = A : 4 B : 3 C : 2 D : 1 E : 0 Sql nya adalah : 1.UPDATE krs SET akhir = ‘(40/100*uts)+(60/100*uas)’; 2.UPDATE krs SET huruf = “A” WHERE akhir >=85; UPDATE krs SET huruf = “B” WHERE (akhir < 85)&&(akhir >=75); UPDATE krs SET huruf = “C” WHERE (akhir < 75)&&(akhir >=60); UPDATE krs SET huruf = “D” WHERE (akhir < 60)&&(akhir >=40); UPDATE krs SET huruf = “E” WHERE akhir < 40; 3. UPDATE krs SET bobot = “4” WHERE huruf = “A”; UPDATE krs SET bobot = “3” WHERE huruf = “B”; UPDATE krs SET bobot = “2” WHERE huruf = “C”; UPDATE
membahas tentang teknologi