Cara menambah Vnilai di phpMyAdmin

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;