INSERT INTO SISWA (NO_SISWA,S_NAMA,S_ALAMAT,S_NOKTP,S_TELP,S_EMAIL,S_TGLDAFTAR) VALUES ('S0001','Rizka','Jl. Pondok Maritim II no 3','357820640797','081234789269','pelkenuk@gmail.com',STR_TO_DATE('24-07-2017','%d-%m-%Y'));
 INSERT INTO SISWA (NO_SISWA,S_NAMA,S_ALAMAT,S_NOKTP,S_TELP,S_EMAIL,S_TGLDAFTAR) VALUES ('S0002','Shafira','Jl. Dinoyo Sekolahan gg 1','647435981000','081198000287','wagoonlife@gmail.com',STR_TO_DATE('25-07-2017','%d-%m-%Y'));
 INSERT INTO SISWA (NO_SISWA,S_NAMA,S_ALAMAT,S_NOKTP,S_TELP,S_EMAIL,S_TGLDAFTAR) VALUES ('S0003','Nafiar','Jl. Keputih Perintis 5','729489301934','085253718192','nafiar_dedek@hotmail.com',STR_TO_DATE('31-07-2017','%d-%m-%Y'));
 INSERT INTO SISWA (NO_SISWA,S_NAMA,S_ALAMAT,S_NOKTP,S_TELP,S_EMAIL,S_TGLDAFTAR) VALUES ('S0004','Rafiar','Jl. Keputih Perintis 5','726842019719','088265319210','rafiar_kakak@hotmail.com',STR_TO_DATE('31-07-2017','%d-%m-%Y'));
 INSERT INTO SISWA (NO_SISWA,S_NAMA,S_ALAMAT,S_NOKTP,S_TELP,S_EMAIL,S_TGLDAFTAR) VALUES ('S0005','Nafia','Jl. Raya Mulyosari','351829198631','08562383719','naf_iya@yahoo.co.id',STR_TO_DATE('02-08-2017','%d-%m-%Y'));
 INSERT INTO SISWA (NO_SISWA,S_NAMA,S_ALAMAT,S_NOKTP,S_TELP,S_EMAIL,S_TGLDAFTAR) VALUES ('S0006','Cynthia','Jl. Ciputra 219','263638169991','0816763176883','cynd3@mhs.if.its.ac.id',STR_TO_DATE('08-08-2017','%d-%m-%Y'));
 INSERT INTO SISWA (NO_SISWA,S_NAMA,S_ALAMAT,S_NOKTP,S_TELP,S_EMAIL,S_TGLDAFTAR) VALUES ('S0007','Subhan','Jl. Manyar Selatan 21b','291028939713','081515580376','sabuncolek@yahoo.com',STR_TO_DATE('11-08-2017','%d-%m-%Y'));
 INSERT INTO SISWA (NO_SISWA,S_NAMA,S_ALAMAT,S_NOKTP,S_TELP,S_EMAIL,S_TGLDAFTAR) VALUES ('S0008','Brama','Jl. Gerbang Wetan 18','831719931804','08289372989','bramski@mhs.if.its.ac.id',STR_TO_DATE('11-08-2017','%d-%m-%Y'));

 INSERT INTO PENGAJAR (ID_PENGAJAR,P_NAMA,P_ALAMAT,P_TELP,P_EMAIL) VALUES ('P0001','Hari Sudirman','Perumdos blok U-9','081673176883','sudirman38@gmail.com');
 INSERT INTO PENGAJAR (ID_PENGAJAR,P_NAMA,P_ALAMAT,P_TELP,P_EMAIL) VALUES ('P0002','Sugeng','Jl. Kedung Doro 21','085739384826','sugenggeng@yahoo.com');
 INSERT INTO PENGAJAR (ID_PENGAJAR,P_NAMA,P_ALAMAT,P_TELP,P_EMAIL) VALUES ('P0003','Bondan Hatono','Jl. Achmad Yani 14','088975367131','bondan_ganz@yahoo.com');
 INSERT INTO PENGAJAR (ID_PENGAJAR,P_NAMA,P_ALAMAT,P_TELP,P_EMAIL) VALUES ('P0004','Hariyoso','Jl. Banyu Urip 119','081519848921','har_machester@ymail.com');
 INSERT INTO PENGAJAR (ID_PENGAJAR,P_NAMA,P_ALAMAT,P_TELP,P_EMAIL) VALUES ('P0005','Sulastrini','Jl. Siwalan Kerto 99','085649829199','sulastri11@google.com');

 INSERT INTO LEVEL_KURSUS (LV_ID,LV_NAMA,LV_DESKRIPSI) VALUES ('LV001','BEGINNER','Level ini diperuntukkan bagi pemula');
 INSERT INTO LEVEL_KURSUS (LV_ID,LV_NAMA,LV_DESKRIPSI) VALUES ('LV002','INTERMEDIATE','Level ini telah melewati jenjang beginner dengan standar yang telah ditentukan');
 INSERT INTO LEVEL_KURSUS (LV_ID,LV_NAMA,LV_DESKRIPSI) VALUES ('LV003','ADVANCE','Level ini telah melewati jenjang intermediate dengan standar yang telah ditentukan');

 INSERT INTO PAKET_KURSUS (ID_PK,LV_ID,ID_PENGAJAR,PK_NAMA,PK_TARIF,PK_TGLMULAI,PK_TGLSELESAI) VALUES ('PK001','LV001','P0001','Class Basic',1000000,STR_TO_DATE('01-08-2017','%d-%m-%Y'),STR_TO_DATE('01-09-2017','%d-%m-%Y'));
 INSERT INTO PAKET_KURSUS (ID_PK,LV_ID,ID_PENGAJAR,PK_NAMA,PK_TARIF,PK_TGLMULAI,PK_TGLSELESAI) VALUES ('PK002','LV001','P0005','Conversation Basic',1150000,STR_TO_DATE('01-08-2017','%d-%m-%Y'),STR_TO_DATE('01-09-2017','%d-%m-%Y'));
 INSERT INTO PAKET_KURSUS (ID_PK,LV_ID,ID_PENGAJAR,PK_NAMA,PK_TARIF,PK_TGLMULAI,PK_TGLSELESAI) VALUES ('PK003','LV001','P0004','Writing Basic',1200000,STR_TO_DATE('01-08-2017','%d-%m-%Y'),STR_TO_DATE('01-09-2017','%d-%m-%Y'));
 INSERT INTO PAKET_KURSUS (ID_PK,LV_ID,ID_PENGAJAR,PK_NAMA,PK_TARIF,PK_TGLMULAI,PK_TGLSELESAI) VALUES ('PK004','LV002','P0001','Class Mediate',2000000,STR_TO_DATE('11-08-2017','%d-%m-%Y'),STR_TO_DATE('11-09-2017','%d-%m-%Y'));
 INSERT INTO PAKET_KURSUS (ID_PK,LV_ID,ID_PENGAJAR,PK_NAMA,PK_TARIF,PK_TGLMULAI,PK_TGLSELESAI) VALUES ('PK005','LV002','P0003','Conversation Mediate',2000000,STR_TO_DATE('11-08-2017','%d-%m-%Y'),STR_TO_DATE('11-09-2017','%d-%m-%Y'));
 INSERT INTO PAKET_KURSUS (ID_PK,LV_ID,ID_PENGAJAR,PK_NAMA,PK_TARIF,PK_TGLMULAI,PK_TGLSELESAI) VALUES ('PK006','LV002','P0005','Writing Mediate',2200000,STR_TO_DATE('11-08-2017','%d-%m-%Y'),STR_TO_DATE('11-09-2017','%d-%m-%Y'));
 INSERT INTO PAKET_KURSUS (ID_PK,LV_ID,ID_PENGAJAR,PK_NAMA,PK_TARIF,PK_TGLMULAI,PK_TGLSELESAI) VALUES ('PK007','LV003','P0002','Class Pro',2500000,STR_TO_DATE('21-08-2017','%d-%m-%Y'),STR_TO_DATE('21-09-2017','%d-%m-%Y'));
 INSERT INTO PAKET_KURSUS (ID_PK,LV_ID,ID_PENGAJAR,PK_NAMA,PK_TARIF,PK_TGLMULAI,PK_TGLSELESAI) VALUES ('PK008','LV003','P0003','Conversation Pro',2800000,STR_TO_DATE('21-08-2017','%d-%m-%Y'),STR_TO_DATE('21-09-2017','%d-%m-%Y'));

 INSERT INTO DETIL_KURSUS (ID_PK,NO_SISWA,STATUS_TES) VALUES ('PK001','S0001','LULUS');
 INSERT INTO DETIL_KURSUS (ID_PK,NO_SISWA,STATUS_TES) VALUES ('PK003','S0003','LULUS');
 INSERT INTO DETIL_KURSUS (ID_PK,NO_SISWA,STATUS_TES) VALUES ('PK007','S0001','GAGAL');
 INSERT INTO DETIL_KURSUS (ID_PK,NO_SISWA,STATUS_TES) VALUES ('PK005','S0006','LULUS');
 INSERT INTO DETIL_KURSUS (ID_PK,NO_SISWA,STATUS_TES) VALUES ('PK002','S0008','LULUS');
 INSERT INTO DETIL_KURSUS (ID_PK,NO_SISWA,STATUS_TES) VALUES ('PK001','S0002','LULUS');
 INSERT INTO DETIL_KURSUS (ID_PK,NO_SISWA,STATUS_TES) VALUES ('PK004','S0001','LULUS');
 INSERT INTO DETIL_KURSUS (ID_PK,NO_SISWA,STATUS_TES) VALUES ('PK006','S0004','GAGAL');
 INSERT INTO DETIL_KURSUS (ID_PK,NO_SISWA,STATUS_TES) VALUES ('PK002','S0007','LULUS');
 INSERT INTO DETIL_KURSUS (ID_PK,NO_SISWA,STATUS_TES) VALUES ('PK007','S0005','GAGAL');
 INSERT INTO DETIL_KURSUS (ID_PK,NO_SISWA,STATUS_TES) VALUES ('PK001','S0003','LULUS');
 INSERT INTO DETIL_KURSUS (ID_PK,NO_SISWA,STATUS_TES) VALUES ('PK004','S0002','LULUS');