purwant's blog : DATABASE AKADEMIK, MENGHITUNG IPK,QUERY MENGHITUNG IPK DAN BOBOT NILAI

MENGHITUNG IPK PADA DATABASE AKADEMIK.

DATABASE AKADEMIK MEMILIKI KOMPLEKSITAS YANG LUMAYAN RUMIT. POSTINGAN KALI INI AKAN MEMBAHAS TENTANG MENGHITUNG NILAI IPK PER MAHASISWA .

SIAPKAN DATABASE AKADEMIK.

BUAT TABEL SEPERTI BERIKUT. KETIKAN PADA COMAN LINE MYSQL JAGAN COPAS !!!!!!!!!

CREATE TABLE `dosen` (

`KODEDOSEN` char(5) NOT NULL,

`NAMADOSEN` char(50) default NULL,

PRIMARY KEY (`KODEDOSEN`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `dosen` VALUES ('001', 'YOHAKIM');

INSERT INTO `dosen` VALUES ('002', 'SRI REJEKI');

INSERT INTO `dosen` VALUES ('003', 'BADIYANTO');

INSERT INTO `dosen` VALUES ('004', 'CUK SUBIANTORO');

CREATE TABLE `jurusan` (

`KODEJUR` char(2) NOT NULL,

`NAMAJUR` char(50) default NULL,

`JENJANG` enum('S1','DIII') default NULL,

PRIMARY KEY (`KODEJUR`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `jurusan` VALUES ('TI', 'TEKNIK INFORMATIKA', 'S1');

INSERT INTO `jurusan` VALUES ('MI', 'MANAJEMEN INFORMATIKA', 'DIII');

INSERT INTO `jurusan` VALUES ('SI', 'SISTEM INFORMASI', 'S1');

INSERT INTO `jurusan` VALUES ('TK', 'TEKNIK KOMPUTER', 'DIII');

INSERT INTO `jurusan` VALUES ('KA', 'KOMPUTERISASI AKUTANSI', 'DIII');

CREATE TABLE `kuliah` (

`NIM` char(9) default NULL,

`KODEMK` char(5) default NULL,

`KODEDOSEN` char(9) default NULL,

`NILAI` char(1) default NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `kuliah` VALUES ('095410163', 'PW01', '001', 'A');

INSERT INTO `kuliah` VALUES ('095410163', 'PW02', '002', 'A');

INSERT INTO `kuliah` VALUES ('095410163', 'MD01', '003', 'B');

INSERT INTO `kuliah` VALUES ('095410163', 'SD01', '004', 'B');

INSERT INTO `kuliah` VALUES ('095410163', 'PW11', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410163', 'PW12', '002', 'C');

INSERT INTO `kuliah` VALUES ('095410163', 'MJ01', '003', 'B');

INSERT INTO `kuliah` VALUES ('095410163', 'MK01', '004', 'B');

INSERT INTO `kuliah` VALUES ('095410163', 'SO01', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410163', 'SO11', '002', 'A');

INSERT INTO `kuliah` VALUES ('095410163', 'JK01', '003', 'A');

INSERT INTO `kuliah` VALUES ('095410163', 'BI01', '004', 'B');

INSERT INTO `kuliah` VALUES ('095410166', 'PW01', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410166', 'PW02', '002', 'B');

INSERT INTO `kuliah` VALUES ('095410166', 'MD01', '003', 'B');

INSERT INTO `kuliah` VALUES ('095410166', 'SD01', '004', 'C');

INSERT INTO `kuliah` VALUES ('095410166', 'PW11', '001', 'C');

INSERT INTO `kuliah` VALUES ('095410166', 'PW12', '002', 'B');

INSERT INTO `kuliah` VALUES ('095410166', 'MJ01', '003', 'A');

INSERT INTO `kuliah` VALUES ('095410166', 'MK01', '004', 'A');

INSERT INTO `kuliah` VALUES ('095410166', 'SO01', '001', 'A');

INSERT INTO `kuliah` VALUES ('095410166', 'SO11', '002', 'B');

INSERT INTO `kuliah` VALUES ('095410166', 'JK01', '003', 'B');

INSERT INTO `kuliah` VALUES ('095410166', 'BI01', '004', 'B');

INSERT INTO `kuliah` VALUES ('095410183', 'PW01', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410183', 'PW02', '002', 'A');

INSERT INTO `kuliah` VALUES ('095410183', 'MD01', '003', 'C');

INSERT INTO `kuliah` VALUES ('095410183', 'SD01', '004', 'B');

INSERT INTO `kuliah` VALUES ('095410183', 'PW11', '001', 'A');

INSERT INTO `kuliah` VALUES ('095410183', 'PW12', '002', 'A');

INSERT INTO `kuliah` VALUES ('095410183', 'MJ01', '003', 'B');

INSERT INTO `kuliah` VALUES ('095410183', 'MK01', '004', 'B');

INSERT INTO `kuliah` VALUES ('095410183', 'SO01', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410183', 'SO11', '002', 'A');

INSERT INTO `kuliah` VALUES ('095410183', 'JK01', '003', 'C');

INSERT INTO `kuliah` VALUES ('095410183', 'BI01', '004', 'A');

INSERT INTO `kuliah` VALUES ('095410189', 'PW01', '001', 'A');

INSERT INTO `kuliah` VALUES ('095410189', 'PW02', '002', 'A');

INSERT INTO `kuliah` VALUES ('095410189', 'MD01', '003', 'A');

INSERT INTO `kuliah` VALUES ('095410189', 'SD01', '004', 'B');

INSERT INTO `kuliah` VALUES ('095410189', 'PW11', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410189', 'PW12', '002', 'B');

INSERT INTO `kuliah` VALUES ('095410189', 'MJ01', '003', 'C');

INSERT INTO `kuliah` VALUES ('095410189', 'MK01', '004', 'B');

INSERT INTO `kuliah` VALUES ('095410189', 'SO01', '001', 'C');

INSERT INTO `kuliah` VALUES ('095410189', 'SO11', '002', 'B');

INSERT INTO `kuliah` VALUES ('095410189', 'JK01', '003', 'A');

INSERT INTO `kuliah` VALUES ('095410189', 'BI01', '004', 'A');

INSERT INTO `kuliah` VALUES ('095410162', 'PW01', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410162', 'PW02', '002', 'B');

INSERT INTO `kuliah` VALUES ('095410162', 'MD01', '003', 'B');

INSERT INTO `kuliah` VALUES ('095410162', 'SD01', '004', 'B');

INSERT INTO `kuliah` VALUES ('095410162', 'PW11', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410162', 'PW12', '002', 'C');

INSERT INTO `kuliah` VALUES ('095410162', 'MJ01', '003', 'B');

INSERT INTO `kuliah` VALUES ('095410162', 'MK01', '004', 'A');

INSERT INTO `kuliah` VALUES ('095410162', 'SO01', '001', 'A');

INSERT INTO `kuliah` VALUES ('095410162', 'SO11', '002', 'A');

INSERT INTO `kuliah` VALUES ('095410162', 'JK01', '003', 'A');

INSERT INTO `kuliah` VALUES ('095410162', 'BI01', '004', 'A');

INSERT INTO `kuliah` VALUES ('095410168', 'PW01', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410168', 'PW02', '002', 'B');

INSERT INTO `kuliah` VALUES ('095410168', 'MD01', '003', 'B');

INSERT INTO `kuliah` VALUES ('095410168', 'SD01', '004', 'B');

INSERT INTO `kuliah` VALUES ('095410168', 'PW11', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410168', 'PW12', '002', 'B');

INSERT INTO `kuliah` VALUES ('095410168', 'MJ01', '003', 'B');

INSERT INTO `kuliah` VALUES ('095410168', 'MK01', '004', 'B');

INSERT INTO `kuliah` VALUES ('095410168', 'SO01', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410168', 'SO11', '002', 'A');

INSERT INTO `kuliah` VALUES ('095410168', 'JK01', '003', 'B');

INSERT INTO `kuliah` VALUES ('095410168', 'BI01', '004', 'A');

INSERT INTO `kuliah` VALUES ('095410163', 'PW01', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410163', 'PW02', '002', 'A');

INSERT INTO `kuliah` VALUES ('095410163', 'MD01', '003', 'B');

INSERT INTO `kuliah` VALUES ('095410163', 'SD01', '004', 'B');

INSERT INTO `kuliah` VALUES ('095410163', 'PW11', '001', 'C');

INSERT INTO `kuliah` VALUES ('095410163', 'PW12', '002', 'A');

INSERT INTO `kuliah` VALUES ('095410163', 'MJ01', '003', 'A');

INSERT INTO `kuliah` VALUES ('095410163', 'MK01', '004', 'A');

INSERT INTO `kuliah` VALUES ('095410163', 'SO01', '001', 'A');

INSERT INTO `kuliah` VALUES ('095410163', 'SO11', '002', 'A');

INSERT INTO `kuliah` VALUES ('095410163', 'JK01', '003', 'A');

INSERT INTO `kuliah` VALUES ('095410163', 'BI01', '004', 'C');

INSERT INTO `kuliah` VALUES ('095410166', 'PW01', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410166', 'PW02', '002', 'C');

INSERT INTO `kuliah` VALUES ('095410166', 'MD01', '003', 'B');

INSERT INTO `kuliah` VALUES ('095410166', 'SD01', '004', 'C');

INSERT INTO `kuliah` VALUES ('095410166', 'PW11', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410166', 'PW12', '002', 'B');

INSERT INTO `kuliah` VALUES ('095410166', 'MJ01', '003', 'B');

INSERT INTO `kuliah` VALUES ('095410166', 'MK01', '004', 'B');

INSERT INTO `kuliah` VALUES ('095410166', 'SO01', '001', 'B');

INSERT INTO `kuliah` VALUES ('095410166', 'SO11', '002', 'A');

INSERT INTO `kuliah` VALUES ('095410166', 'JK01', '003', 'A');

INSERT INTO `kuliah` VALUES ('095410166', 'BI01', '004', 'A');

CREATE TABLE `mahasiswa` (

`NIM` char(9) NOT NULL default '',

`NAMAMHS` char(100) NOT NULL,

`TGLLAHIR` date NOT NULL,

`ALAMAT` char(150) NOT NULL,

`KODEJUR` char(2) default NULL,

PRIMARY KEY (`NIM`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `mahasiswa` VALUES ('095410168', 'PURWANTO', '1988-11-11', 'BANTUL,JOGJAKARTA', 'TI');

INSERT INTO `mahasiswa` VALUES ('095410163', 'CHRISTIAN PRAMUDITA', '1988-12-12', 'WESTPROG, JOGJAKARTA', 'TI');

INSERT INTO `mahasiswa` VALUES ('095410166', 'ELLEN A.P.', '1993-09-12', 'BANTUL, JOGJAKARTA', 'TI');

INSERT INTO `mahasiswa` VALUES ('095410183', 'IBNU DAMAR SAPUTRA', '1998-02-12', 'SLEMAN,JOGJAKARTA', 'TI');

INSERT INTO `mahasiswa` VALUES ('095410189', 'EKO SETIAWAN', '1991-02-01', 'BANTUL, JOGJAKARTA', 'TI');

INSERT INTO `mahasiswa` VALUES ('095410162', 'NUR WAHYUDI', '1989-02-16', 'KLATEN, JOGJAKARTA', 'TI');

CREATE TABLE `matakuliah` (

`KODEMK` char(5) NOT NULL default '',

`NAMAMK` char(50) NOT NULL,

`SKS` int(11) NOT NULL,

`KODEJUR` char(2) default NULL,

PRIMARY KEY (`KODEMK`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `matakuliah` VALUES ('PW01', 'PENGENALAN WEB', 3, 'TI');

INSERT INTO `matakuliah` VALUES ('PW02', 'PEMROGRAMAN WEB', 3, 'TI');

INSERT INTO `matakuliah` VALUES ('MD01', 'MATEMATIKA DISKRIT', 3, 'TI');

INSERT INTO `matakuliah` VALUES ('SD01', 'STATISTIKA DASAR', 3, 'TI');

INSERT INTO `matakuliah` VALUES ('PW11', 'PRAKTEK PENGENALAN WEB', 1, 'TI');

INSERT INTO `matakuliah` VALUES ('PW12', 'PRAKTEK PEMROGRAMAN WEB', 1, 'TI');

INSERT INTO `matakuliah` VALUES ('MJ01', 'MANAJEMEN DAN BISNIS', 2, 'TI');

INSERT INTO `matakuliah` VALUES ('MK01', 'METODE KUANTITATIF UNTUK BISNIS', 2, 'TI');

INSERT INTO `matakuliah` VALUES ('SO01', 'SISTEM OPERASI', 2, 'TI');

INSERT INTO `matakuliah` VALUES ('SO11', 'PRAKTEK SISTEM OPERASI', 1, 'TI');

INSERT INTO `matakuliah` VALUES ('JK01', 'JARINGAN KOMPUTER', 3, 'TI');

INSERT INTO `matakuliah` VALUES ('BI01', 'BAHASA INGGRIS 1', 3, 'TI');

SAATNYA BERMAIN-MAIN DENGAN QUERY.

TAMPILKAN NIM,NAMAMATAKULIAH,NAMADOSEN.

SELECT MAHASISWA.NIM,matakuliah.NAMAMK,DOSEN.NAMADOSEN

FROM MAHASISWA ,KULIAH,DOSEN,MATAKULIAH

WHERE MAHASISWA.NIM=KULIAH.NIM AND KULIAH.KODEMK=MATAKULIAH.KODEMK AND KULIAH.KODEDOSEN=DOSEN.KODEDOSEN

PROSES QUERY DIATAS DAPAT DIGAMABARKAN DENGAN RELASI.

SESUAI DENGAN GAMBAR DAPAT DILIHAT BAHWA KULIAH MERUPAKAN TABEL YANG MENGHUBUNGKAN ANTARA MAHASISWA KE MATAKULIAH DAN MAHASISWA KE DOSEN.

PERHATIKAN QUERY BERIKUT.

SELECT MAHASISWA.NIM,matakuliah.NAMAMK,DOSEN.NAMADOSEN

FROM MAHASISWA ,KULIAH,DOSEN,MATAKULIAH

PERINTAH QUERY DIATAS MERUPAKAN PERINTAH UNTUK MENAMPILKAN FIELD NIM DARI TABEL MAHASISWA,FIELD NAMAMK DARI TABEL MATAKULIAH ,FIELD NAMADOSEN DARI TABEL DOSEN.

PERHATIKAN PERINTAH QUERY BERIKUTNYA.

WHERE MAHASISWA.NIM=KULIAH.NIM AND KULIAH.KODEMK=MATAKULIAH.KODEMK AND KULIAH.KODEDOSEN=DOSEN.KODEDOSEN

NAH QUERY TERSEBUT MERUPAKAN PENGHUBUNG ATAR TABEL, MAKANYA DISETIAP KONDISI SELALU ADA TABEL KULIAH YANG MENGHUBUNGKAN KETIGA TABEL TERSEBUT. HASILNYA TAMPAK SEPERTI BERIKUT.

+-----------+---------------------------------+----------------+

| NIM | NAMAMK | NAMADOSEN |

+-----------+---------------------------------+----------------+

| 095410163 | PENGENALAN WEB | YOHAKIM |

| 095410163 | PRAKTEK PENGENALAN WEB | YOHAKIM |

| 095410163 | SISTEM OPERASI | YOHAKIM |

| 095410166 | PENGENALAN WEB | YOHAKIM |

| 095410166 | PRAKTEK PENGENALAN WEB | YOHAKIM |

| 095410166 | SISTEM OPERASI | YOHAKIM |

| 095410183 | PENGENALAN WEB | YOHAKIM |

| 095410183 | PRAKTEK PENGENALAN WEB | YOHAKIM |

| 095410183 | SISTEM OPERASI | YOHAKIM |

| 095410189 | PENGENALAN WEB | YOHAKIM |

| 095410189 | PRAKTEK PENGENALAN WEB | YOHAKIM |

| 095410189 | SISTEM OPERASI | YOHAKIM |

| 095410162 | PENGENALAN WEB | YOHAKIM |

| 095410162 | PRAKTEK PENGENALAN WEB | YOHAKIM |

| 095410162 | SISTEM OPERASI | YOHAKIM |

| 095410168 | PENGENALAN WEB | YOHAKIM |

| 095410168 | PRAKTEK PENGENALAN WEB | YOHAKIM |

| 095410168 | SISTEM OPERASI | YOHAKIM |

| 095410163 | PENGENALAN WEB | YOHAKIM |

| 095410163 | PRAKTEK PENGENALAN WEB | YOHAKIM |

| 095410163 | SISTEM OPERASI | YOHAKIM |

| 095410166 | PENGENALAN WEB | YOHAKIM |

| 095410166 | PRAKTEK PENGENALAN WEB | YOHAKIM |

| 095410166 | SISTEM OPERASI | YOHAKIM |

| 095410163 | PEMROGRAMAN WEB | SRI REJEKI |

| 095410163 | PRAKTEK PEMROGRAMAN WEB | SRI REJEKI |

| 095410163 | PRAKTEK SISTEM OPERASI | SRI REJEKI |

| 095410166 | PEMROGRAMAN WEB | SRI REJEKI |

| 095410166 | PRAKTEK PEMROGRAMAN WEB | SRI REJEKI |

| 095410166 | PRAKTEK SISTEM OPERASI | SRI REJEKI |

| 095410183 | PEMROGRAMAN WEB | SRI REJEKI |

| 095410183 | PRAKTEK PEMROGRAMAN WEB | SRI REJEKI |

| 095410183 | PRAKTEK SISTEM OPERASI | SRI REJEKI |

| 095410189 | PEMROGRAMAN WEB | SRI REJEKI |

| 095410189 | PRAKTEK PEMROGRAMAN WEB | SRI REJEKI |

| 095410189 | PRAKTEK SISTEM OPERASI | SRI REJEKI |

| 095410162 | PEMROGRAMAN WEB | SRI REJEKI |

| 095410162 | PRAKTEK PEMROGRAMAN WEB | SRI REJEKI |

| 095410162 | PRAKTEK SISTEM OPERASI | SRI REJEKI |

| 095410168 | PEMROGRAMAN WEB | SRI REJEKI |

| 095410168 | PRAKTEK PEMROGRAMAN WEB | SRI REJEKI |

| 095410168 | PRAKTEK SISTEM OPERASI | SRI REJEKI |

| 095410163 | PEMROGRAMAN WEB | SRI REJEKI |

| 095410163 | PRAKTEK PEMROGRAMAN WEB | SRI REJEKI |

| 095410163 | PRAKTEK SISTEM OPERASI | SRI REJEKI |

| 095410166 | PEMROGRAMAN WEB | SRI REJEKI |

| 095410166 | PRAKTEK PEMROGRAMAN WEB | SRI REJEKI |

| 095410166 | PRAKTEK SISTEM OPERASI | SRI REJEKI |

| 095410163 | MATEMATIKA DISKRIT | BADIYANTO |

| 095410163 | MANAJEMEN DAN BISNIS | BADIYANTO |

| 095410163 | JARINGAN KOMPUTER | BADIYANTO |

| 095410166 | MATEMATIKA DISKRIT | BADIYANTO |

| 095410166 | MANAJEMEN DAN BISNIS | BADIYANTO |

| 095410166 | JARINGAN KOMPUTER | BADIYANTO |

| 095410183 | MATEMATIKA DISKRIT | BADIYANTO |

| 095410183 | MANAJEMEN DAN BISNIS | BADIYANTO |

| 095410183 | JARINGAN KOMPUTER | BADIYANTO |

| 095410189 | MATEMATIKA DISKRIT | BADIYANTO |

| 095410189 | MANAJEMEN DAN BISNIS | BADIYANTO |

| 095410189 | JARINGAN KOMPUTER | BADIYANTO |

| 095410162 | MATEMATIKA DISKRIT | BADIYANTO |

| 095410162 | MANAJEMEN DAN BISNIS | BADIYANTO |

| 095410162 | JARINGAN KOMPUTER | BADIYANTO |

| 095410168 | MATEMATIKA DISKRIT | BADIYANTO |

| 095410168 | MANAJEMEN DAN BISNIS | BADIYANTO |

| 095410168 | JARINGAN KOMPUTER | BADIYANTO |

| 095410163 | MATEMATIKA DISKRIT | BADIYANTO |

| 095410163 | MANAJEMEN DAN BISNIS | BADIYANTO |

| 095410163 | JARINGAN KOMPUTER | BADIYANTO |

| 095410166 | MATEMATIKA DISKRIT | BADIYANTO |

| 095410166 | MANAJEMEN DAN BISNIS | BADIYANTO |

| 095410166 | JARINGAN KOMPUTER | BADIYANTO |

| 095410163 | STATISTIKA DASAR | CUK SUBIANTORO |

| 095410163 | METODE KUANTITATIF UNTUK BISNIS | CUK SUBIANTORO |

| 095410163 | BAHASA INGGRIS 1 | CUK SUBIANTORO |

| 095410166 | STATISTIKA DASAR | CUK SUBIANTORO |

| 095410166 | METODE KUANTITATIF UNTUK BISNIS | CUK SUBIANTORO |

| 095410166 | BAHASA INGGRIS 1 | CUK SUBIANTORO |

| 095410183 | STATISTIKA DASAR | CUK SUBIANTORO |

| 095410183 | METODE KUANTITATIF UNTUK BISNIS | CUK SUBIANTORO |

| 095410183 | BAHASA INGGRIS 1 | CUK SUBIANTORO |

| 095410189 | STATISTIKA DASAR | CUK SUBIANTORO |

| 095410189 | METODE KUANTITATIF UNTUK BISNIS | CUK SUBIANTORO |

| 095410189 | BAHASA INGGRIS 1 | CUK SUBIANTORO |

| 095410162 | STATISTIKA DASAR | CUK SUBIANTORO |

| 095410162 | METODE KUANTITATIF UNTUK BISNIS | CUK SUBIANTORO |

| 095410162 | BAHASA INGGRIS 1 | CUK SUBIANTORO |

| 095410168 | STATISTIKA DASAR | CUK SUBIANTORO |

| 095410168 | METODE KUANTITATIF UNTUK BISNIS | CUK SUBIANTORO |

| 095410168 | BAHASA INGGRIS 1 | CUK SUBIANTORO |

| 095410163 | STATISTIKA DASAR | CUK SUBIANTORO |

| 095410163 | METODE KUANTITATIF UNTUK BISNIS | CUK SUBIANTORO |

| 095410163 | BAHASA INGGRIS 1 | CUK SUBIANTORO |

| 095410166 | STATISTIKA DASAR | CUK SUBIANTORO |

| 095410166 | METODE KUANTITATIF UNTUK BISNIS | CUK SUBIANTORO |

| 095410166 | BAHASA INGGRIS 1 | CUK SUBIANTORO |

+-----------+---------------------------------+----------------+

96 rows in set (0.39 sec)

TAMPILKAN DENGAN NAMA “ELLEN A.P.”.

SELECT MAHASISWA.NIM,matakuliah.NAMAMK,DOSEN.NAMADOSEN

FROM MAHASISWA ,KULIAH,DOSEN,MATAKULIAH

WHERE MAHASISWA.NIM=KULIAH.NIM AND KULIAH.KODEMK=MATAKULIAH.KODEMK AND KULIAH.KODEDOSEN=DOSEN.KODEDOSEN

and MAHASISWA.NAMAMHS='ELLEN A.P.';

HASIL

+-----------+---------------------------------+----------------+

| NIM | NAMAMK | NAMADOSEN |

+-----------+---------------------------------+----------------+

| 095410166 | PENGENALAN WEB | YOHAKIM |

| 095410166 | PRAKTEK PENGENALAN WEB | YOHAKIM |

| 095410166 | SISTEM OPERASI | YOHAKIM |

| 095410166 | PENGENALAN WEB | YOHAKIM |

| 095410166 | PRAKTEK PENGENALAN WEB | YOHAKIM |

| 095410166 | SISTEM OPERASI | YOHAKIM |

| 095410166 | PEMROGRAMAN WEB | SRI REJEKI |

| 095410166 | PRAKTEK PEMROGRAMAN WEB | SRI REJEKI |

| 095410166 | PRAKTEK SISTEM OPERASI | SRI REJEKI |

| 095410166 | PEMROGRAMAN WEB | SRI REJEKI |

| 095410166 | PRAKTEK PEMROGRAMAN WEB | SRI REJEKI |

| 095410166 | PRAKTEK SISTEM OPERASI | SRI REJEKI |

| 095410166 | MATEMATIKA DISKRIT | BADIYANTO |

| 095410166 | MANAJEMEN DAN BISNIS | BADIYANTO |

| 095410166 | JARINGAN KOMPUTER | BADIYANTO |

| 095410166 | MATEMATIKA DISKRIT | BADIYANTO |

| 095410166 | MANAJEMEN DAN BISNIS | BADIYANTO |

| 095410166 | JARINGAN KOMPUTER | BADIYANTO |

| 095410166 | STATISTIKA DASAR | CUK SUBIANTORO |

| 095410166 | METODE KUANTITATIF UNTUK BISNIS | CUK SUBIANTORO |

| 095410166 | BAHASA INGGRIS 1 | CUK SUBIANTORO |

| 095410166 | STATISTIKA DASAR | CUK SUBIANTORO |

| 095410166 | METODE KUANTITATIF UNTUK BISNIS | CUK SUBIANTORO |

| 095410166 | BAHASA INGGRIS 1 | CUK SUBIANTORO |

+-----------+---------------------------------+----------------+

24 rows in set (0.06 sec)

PENGGUNAAN CASE.

mysql> SELECT NIM,NILAI,CASE

-> WHEN NILAI= 'A' THEN 'VERY GOOD'

-> WHEN NILAI= 'B' THEN 'GOOD'

-> WHEN NILAI= 'C' THEN 'ENOUGH'

-> ELSE

-> 'VERY BAD POINT'

-> END AS POINT

-> FROM KULIAH;

HASILNYA

+-----------+-------+-----------+

| NIM | NILAI | POINT |

+-----------+-------+-----------+

| 095410163 | A | VERY GOOD |

| 095410163 | B | GOOD |

| 095410163 | C | ENOUGH |

| 095410163 | B | GOOD |

| 095410163 | A | VERY GOOD |

| 095410163 | B | GOOD |

| 095410166 | B | GOOD |

| 095410166 | C | ENOUGH |

| 095410166 | B | GOOD |

MENGHITUNG JUMLAH SKS YANG DIAMBIL TIAP MAHASISWA.

mysql> SELECT MAHASISWA.NIM,SUM(MATAKULIAH.SKS) FROM MATAKULIAH,KULIAH

-> ,MAHASISWA

-> WHERE MAHASISWA.NIM=KULIAH.NIM AND KULIAH.KODEMK=MATAKULIAH.KODEMK

-> GROUP BY MAHASISWA.NIM;

+-----------+---------------------+

| NIM | SUM(MATAKULIAH.SKS) |

+-----------+---------------------+

| 095410162 | 27 |

| 095410163 | 54 |

| 095410166 | 54 |

| 095410168 | 27 |

| 095410183 | 27 |

| 095410189 | 27 |

+-----------+---------------------+

6 rows in set (0.11 sec)

MENGHITUNG BOBOT PER SKS

SELECT KULIAH.NIM,KULIAH.NILAI,MATAKULIAH.SKS,CASE

WHEN NILAI= 'A' THEN 4

WHEN NILAI= 'B' THEN 3

WHEN NILAI= 'C' THEN 2

WHEN NILAI= 'D' THEN 1

ELSE

END AS BOBOT ,CASE

WHEN NILAI= 'A' THEN 4*MATAKULIAH.SKS

WHEN NILAI= 'B' THEN 3*MATAKULIAH.SKS

WHEN NILAI= 'C' THEN 2*MATAKULIAH.SKS

WHEN NILAI= 'D' THEN 1*MATAKULIAH.SKS

ELSE

0*MATAKULIAH.SKS

END

AS POINT

FROM KULIAH,MATAKULIAH

WHERE KULIAH.KODEMK=MATAKULIAH.KODEMK

HASILNYA.

+-----------+-------+-----+-------+-------+

| NIM | NILAI | SKS | BOBOT | POINT |

+-----------+-------+-----+-------+-------+

| 095410163 | A | 3 | 4 | 12 |

| 095410163 | B | 3 | 3 | 9 |

| 095410163 | B | 1 | 3 | 3 |

| 095410163 | C | 1 | 2 | 2 |

| 095410163 | B | 2 | 3 | 6 |

| 095410163 | A | 1 | 4 | 4 |

| 095410163 | A | 3 | 4 | 12 |

| 095410163 | B | 3 | 3 | 9 |

| 095410166 | B | 3 | 3 | 9 |

| 095410166 | C | 3 | 2 | 6 |

| 095410166 | C | 1 | 2 | 2 |

| 095410166 | B | 1 | 3 | 3 |

| 095410166 | A | 2 | 4 | 8 |

| 095410166 | B | 1 | 3 | 3 |

| 095410166 | B | 3 | 3 | 9 |

| 095410183 | B | 3 | 3 | 9 |

| 095410183 | A | 3 | 4 | 12 |

| 095410183 | C | 3 | 2 | 6 |

| 095410183 | B | 3 | 3 | 9 |

| 095410183 | A | 1 | 4 | 4 |

| 095410183 | B | 2 | 3 | 6 |

| 095410183 | A | 1 | 4 | 4 |

| 095410183 | C | 3 | 2 | 6 |

MENGHITUNG IPK TIAP MAHASISWA

SELECT KULIAH.NIM,KULIAH.NILAI,MATAKULIAH.SKS,SUM(CASE

WHEN NILAI= 'A' THEN 4*MATAKULIAH.SKS

WHEN NILAI= 'B' THEN 3*MATAKULIAH.SKS

WHEN NILAI= 'C' THEN 2*MATAKULIAH.SKS

WHEN NILAI= 'D' THEN 1*MATAKULIAH.SKS

ELSE

0*MATAKULIAH.SKS

END)/SUM(MATAKULIAH.SKS)

AS POINT

FROM KULIAH,MATAKULIAH

WHERE KULIAH.KODEMK=MATAKULIAH.KODEMK

GROUP BY KULIAH.NIM

HASILNYA

+-----------+-------+-----+--------+

| NIM | NILAI | SKS | POINT |

+-----------+-------+-----+--------+

| 095410162 | B | 3 | 3.3704 |

| 095410163 | A | 3 | 3.3519 |

| 095410166 | B | 3 | 3.0556 |

| 095410168 | B | 3 | 3.1481 |

| 095410183 | B | 3 | 3.1111 |

| 095410189 | A | 3 | 3.4074 |

+-----------+-------+-----+--------+

6 rows in set (0.02 sec)

MOHON MAAF BILA ADA KESAMAAN BAIK NAMA MAHASISWA ATAU DOSEN DENGAN KAMPUS TERTENTU.

“SALAM BUAT ISTRIKU DAN ALUMNI STMIK AKAKOM YOGYAKARTA 2013.”

purwant's blog

Friday, 29 August 2014

DATABASE AKADEMIK, MENGHITUNG IPK,QUERY MENGHITUNG IPK DAN BOBOT NILAI

4 comments: