v create View vnilai as
Select
kuliah.nim,nama_mhs,kode_mk,sks,smt,tgs,quis,uts,uas from kuliah;
v create
View vskor as
Select
*,(0.15*tgs)+(0.15*quis)+(0.30*uts)+(0.40*uas)as skor from vnilai;
v .craete View vnh as
Select *, case
When skor>=86
then ‘A’
When skor>=70 then ‘B’
When
skor>=56then ‘C’
When skor>=40
then ‘D’
Else ‘E’
End as nh from
vskor;
v create View vbobot as
Select *, case nh
when’A’ then ‘4’
when’B’ then ‘3’
when’C’ then ‘2’
when’D’ then ‘1’
when’E’ then ‘0’
else ‘0’ end as bobot from vnh;
v create
View vnk as
Select
*,(bobot*sks) as vnk from vbobot;
