Tugas 2 Kelas XI IPS 5 : Membuat QUERY dengan SQL

Salam TIK SMA XAVEGA.
Kali ini saya ingin mengajak Anda untuk belajar membuat query menggunakan SQL (Structured Query Language).
Materi SQL secara lengkap silahkan anda baca pada buku modul pembelajaran TIK kelas XI, atau klik di sini juga boleh koq.

Sebelum mengerjakan tugas yang akan saya berikan, silahkan Anda buat dahulu sebuah file database dengan nama KURSUS.mdb seperti di bawah ini. (Apabila kurang jelas, silahkan lihat/baca buku Modul Pembelajaran TIK kelas XI pada halaman 19).
Di dalam database  KURSUS tersebut, buatlah 4 buah tabel sbb:

Tabel 1 : GURU


 

Tabel 2 : PROGRAM



Tabel 3 : SISWA



Tabel 4 : ABSEN



Setelah keempat tabel tersebut selesai anda buat, berikutnya buatlah relasional tabel seperti gambar di bawah ini!


Apabila tabel dan relasi tabel telah siap, sekarang silahkan Anda buat/kerjakan query berikut menggunakan SQL. Silahkan Anda publish/kirimkan syntax/rumus SQL yang Anda buat paling lambat tanggal 31 Mei 2013.

SOAL:

  1. Tampilkan siwa yang mengikuti paket program tertentu menggunakan parameter field PAKET_PROGRAM. Field yang ditampilkan adalah:NIS, NAMA_SISWA, PAKET_PROGRAM, NAMA_GURU, JAM_MASUK, JAM_PULANG, dan LAMA_JAM_BELAJAR.
  2. Tampilkan field NIS, NAMA_SISWA, TANGGAL_LAHIR, UMUR, PAKET_PROGRAM, dan BIAYA_KURSUS.
    Ketentuan/keterangan soal nomor 2 adalah sebagai berikut:
    • Perhitungan Umur menggunakan fungsi TAHUN SEKARANG - TAHUN TANGGAL_LAHIR.
    • BIAYA_KURSUS diperoleh dengan ketentuan sebagai berikut:
      - Jika PAKET_PROGRAM = MS-Windows, BIAYA_KURSUS = 75000,
      - Jika PAKET_PROGRAM = MS-Office, BIAYA_KURSUS = 150000,
      - Jika PAKET_PROGRAM = Photoshop, BIAYA_KURSUS = 300000,
      - Jika PAKET_PROGRAM = Web Design, BIAYA_KURSUS = 200000,

Selamat mengerjakan. Semoga berhasil.
Posted on 5/18/2013
Category:

37 comment:

Steven Wijaya said...

Nama: Steven Wijaya, Kelas: XI S5, Nomor Absen: 28

Soal 1:
PARAMETERS
SISWA.NAMA_SISWA Text ( 225 );
SELECT SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

Soal 2:
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year([TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM,
IIf(PAKET_PROGRAM="MS-Windows",75000,
IIf(PAKET_PROGRAM="Ms-Office",150000,
IIf(PAKET_PROGRAM="Photoshop",300000,200000))) AS BIAYA_KHUSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM=SISWA.KD_PROGRAM;

26 May, 2013
Revi Firindo said...

Nama: Revi Firindo
Kelas: XI S5
Nomor: 23

Soal 1:
PARAMETERS
SISWA.NAMA_SISWA Text ( 225 );
SELECT SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

Soal 2:
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year([TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM,
IIf(PAKET_PROGRAM="MS-Windows",75000,
IIf(PAKET_PROGRAM="Ms-Office",150000,
IIf(PAKET_PROGRAM="Photoshop",300000,200000))) AS BIAYA_KHUSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM=SISWA.KD_PROGRAM;

26 May, 2013
shavira prameswari said...

nama : shavira prameswari
kelas : XI.S5
abesn : 27

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

26 May, 2013
Jeffry Andrean Adi said...

Nama:Jeffry Andrean Adi
Kelas:XI S5
Nomor Absen:13

Soal 1:
PARAMETERS
SISWA.NAMA_SISWA Text(225);
SELECT SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

Soal 2:
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year([TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM,
IIf(PAKET_PROGRAM="MS-Windows",75000,
IIf(PAKET_PROGRAM="Ms-Office",150000,
IIf(PAKET_PROGRAM="Photoshop",300000,200000))) AS BIAYA_KHUSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM=SISWA.KD_PROGRAM;

26 May, 2013
Fitri Rusdi said...

Nama:Fitri Rusdi, Kelas:XI S5, Nomor:9

Soal 1:
PARAMETERS
SISWA.NAMA_SISWA Text (225);
SELECT SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

Soal 2:
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year([TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM,
IIf(PAKET_PROGRAM="MS-Windows",75000,
IIf(PAKET_PROGRAM="Ms-Office",150000,
IIf(PAKET_PROGRAM="Photoshop",300000,200000))) AS BIAYA_KHUSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM=SISWA.KD_PROGRAM;

26 May, 2013
Vincent Trihatmojo said...

Nama: Vincent Trihatmojo
Kelas: XI S5
Nomor: 34

Soal 1:
PARAMETERS
SISWA.NAMA_SISWA Text ( 225 );
SELECT SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

Soal 2:
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year([TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM,
IIf(PAKET_PROGRAM="MS-Windows",75000,
IIf(PAKET_PROGRAM="Ms-Office",150000,
IIf(PAKET_PROGRAM="Photoshop",300000,200000))) AS BIAYA_KHUSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM=SISWA.KD_PROGRAM;

26 May, 2013
Fryda Valen said...

Nama: Fryda Valen Kelas: XI S5 Nomor: 10

Soal 1:
PARAMETERS
SISWA.NAMA_SISWA Text ( 225 );
SELECT SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

Soal 2:
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year([TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM,
IIf(PAKET_PROGRAM="MS-Windows",75000,
IIf(PAKET_PROGRAM="Ms-Office",150000,
IIf(PAKET_PROGRAM="Photoshop",300000,200000))) AS BIAYA_KHUSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM=SISWA.KD_PROGRAM;

26 May, 2013
Elda Natalia Barasa said...

Nama: Elda Natalia Barasa
Kelas: XI S5
Nomor: 08

1.
PARAMETERS
SISWA.NAMA_SISWA Text ( 225 );
SELECT SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

2.
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year([TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM,
IIf(PAKET_PROGRAM="MS-Windows",75000,
IIf(PAKET_PROGRAM="Ms-Office",150000,
IIf(PAKET_PROGRAM="Photoshop",300000,200000))) AS BIAYA_KHUSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM=SISWA.KD_PROGRAM;

26 May, 2013
Priskilla Devie said...

Nama: Priskilla Devie, Kelas: XI S5, Nomor: 21

1.
PARAMETERS
SISWA.NAMA_SISWA Text ( 225 );
SELECT SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

2.
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year([TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM,
IIf(PAKET_PROGRAM="MS-Windows",75000,
IIf(PAKET_PROGRAM="Ms-Office",150000,
IIf(PAKET_PROGRAM="Photoshop",300000,200000))) AS BIAYA_KHUSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM=SISWA.KD_PROGRAM;

26 May, 2013
Dian Anggraeni said...

Nama: Dian Anggraeni
Kelas: XI S5
Nomor: 5

Soal 1:
PARAMETERS
SISWA.NAMA_SISWA Text ( 225 );
SELECT SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

Soal 2:
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year([TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM,
IIf(PAKET_PROGRAM="MS-Windows",75000,
IIf(PAKET_PROGRAM="Ms-Office",150000,
IIf(PAKET_PROGRAM="Photoshop",300000,200000))) AS BIAYA_KHUSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM=SISWA.KD_PROGRAM;

26 May, 2013
salim kusuma said...

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

27 May, 2013
handoko said...

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program
;

27 May, 2013
TEDDY HAWARI said...

1.
PARAMETERS PAKET_PROGRAM Text;
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];

2.
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
YEAR(NOW())-YEAR([SISWA.TANGGAL_LAHIR]) AS UMUR,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",75000,
IIf(PROGRAM.PAKET_PROGRAM="MS-OFFICE",150000,
IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",300000,200000))) AS BIAYA_KURSUS
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM;

27 May, 2013
SASTRA W said...

1.
PARAMETERS PAKET_PROGRAM Text;
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];

2.
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
YEAR(NOW())-YEAR([SISWA.TANGGAL_LAHIR]) AS UMUR,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",75000,
IIf(PROGRAM.PAKET_PROGRAM="MS-OFFICE",150000,
IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",300000,200000))) AS BIAYA_KURSUS
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM;

27 May, 2013
Vety Ayu Ningsih said...

Nama: Vety Ayu Ningsih
Kelas: XI S5
Nomor: 31

Soal 1:
PARAMETERS
SISWA.NAMA_SISWA Text ( 225 );
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRA­M, GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG, ([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*2­4 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.K­D_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

Soal 2:
SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR,­
Year(Now())-Year([TA­NGGAL_LAHIR]) AS UMUR,
PROGRAM.PAKET_PROGRA­M, IIF(PAKET_PROGRAM="M­S-Windows",75000,
IIF(PAKET_PROGRAM="Ms-O­ffice",150000,
IIF(PA­KET_PROGRAM="Photosh­op",300000,200000)))­ AS BIAYA_KHUSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM=SISWA.KD_PROGRAM;

27 May, 2013
Merli Revita said...

1. QUERY 1:
PARAMETERS SISWA.NAMA_SISWA;
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRA­M, GURU.NAMA_GURU, ABSEN.JAM_MASUK, ABSEN.JAM_PULANG, ([ABSEN.JAM_PULANG]-­[ABSEN.JAM_MASUK])*2­4 AS LAMA_JAM_BELAJAR

FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.K­D_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PRO­GRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

2. QUERY 2:
SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, Year(Now())-Year([TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM, IIf(PAKET_PROGRAM="MS-Windows",75000,IIf(PAKET_PROGRAM="Ms-Office",150000,IIf(PAKET_PROGRAM="Photoshop",300000,200000))) AS BIAYA_KHUSUS

FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM=SISWA.KD_PROGRAM;

Merli Revita
XI.S5
17

27 May, 2013
dorea della said...

QUERY 1:
PARAMETERS SISWA.NAMA_SISWA Text ( 225 );
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRA­­M, GURU.NAMA_GURU, ABSEN.JAM_MASUK, ABSEN.JAM_PULANG, ([ABSEN.JAM_PULANG]-­­[ABSEN.JAM_MASUK])*­2­4 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.K­­D_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM:pRO­­GRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

QUERY 2:
SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR,­ Year(Now())-Year([TA­NGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRA­M, IIf(PAKET_PROGRAM="M­S-Windows",75000,IIf­(PAKET_PROGRAM="Ms-O­ffice",150000,IIf(PA­KET_PROGRAM="Photosh­op",300000,200000)))­ AS BIAYA_KHUSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM:s­ISWA.KD_PROGRAM;

nama: dorea della
kelas: Xi IPS 5
np abs: 06

28 May, 2013
widya setiawan said...

QUERY 1:
PARAMETERS SISWA.NAMA_SISWA Text ( 225 );
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRA­­M, GURU.NAMA_GURU, ABSEN.JAM_MASUK, ABSEN.JAM_PULANG, ([ABSEN.JAM_PULANG]-­­[ABSEN.JAM_MASUK])*­2­4 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.K­­D_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM:pRO­­GRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

QUERY 2:
SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR,­ Year(Now())-Year([TA­NGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRA­M, IIf(PAKET_PROGRAM="M­S-Windows",75000,IIf­(PAKET_PROGRAM="Ms-O­ffice",150000,IIf(PA­KET_PROGRAM="Photosh­op",300000,200000)))­ AS BIAYA_KHUSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM:s­ISWA.KD_PROGRAM;

NAMA: WIDYA SETIAWAN
KELAS: XI.IPS 5
NO ABS: 35

28 May, 2013
Unknown said...

Berikut isian saya atas tugas yg Bapak berikan :
1. SELECT SISWA.NIS, SISWA.NAMA_SISWA, YEAR(NOW())-YEAR(SISWA.TANGGAL_LAHIR) AS USIA, GURU.NAMA_GURU, IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",200000,IIf(PROGRAM.PAKET_PROGRAM="MS-OFFICE",300000,IIf(PROGRAM.PAKET_PROGRAM="PHOTOSHOP",400000,450000))) AS BIAYA_PERPAKET
FROM (SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM;

2.PARAMETERS NAMA_GURU Text ( 255 );
SELECT GURU.NAMA_GURU, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM
FROM (GURU INNER JOIN SISWA ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM
WHERE GURU.NAMA_GURU=[NAMA_GURU];

3.SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, (ABSEN.JAM_PULANG-ABSEN.JAM_MASUK)*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

4.SELECT SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",2,IIf(PROGRAM.PAKET_PROGRAM="MS-OFFICE",3,IIf(PROGRAM.PAKET_PROGRAM="PHOTOSHOP",6,9))) AS LAMA_BULAN_BELAJAR, IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",200000,IIf(PROGRAM.PAKET_PROGRAM="MS-OFFICE",300000,IIf(PROGRAM.PAKET_PROGRAM="PHOTOSHOP",400000,450000))) AS BIAYA_PERPAKET, (LAMA_BULAN_BELAJAR*BIAYA_PERPAKET) AS TOTAL_BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM;

5.SELECT SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, YEAR(NOW())-YEAR(SISWA.TANGGAL_LAHIR) AS UMUR, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, ABSEN.JAM_MASUK, ABSEN.JAM_PULANG
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

Terima Kasih, Pak

Nama: Cindy Marcella T.
Kelas: XI S5
Absen: 3

28 May, 2013
Noviliana Rosita XIS5 said...

1. SELECT SISWA.NIS, SISWA.NAMA_SISWA, YEAR(NOW())-YEAR(SISWA.TANGGAL_LAHIR) AS USIA, GURU.NAMA_GURU, IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",200000,IIf(PROGRAM.PAKET_PROGRAM="MS-OFFICE",300000,IIf(PROGRAM.PAKET_PROGRAM="PHOTOSHOP",400000,450000))) AS BIAYA_PERPAKET
FROM (SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM;

2.PARAMETERS NAMA_GURU Text ( 255 );
SELECT GURU.NAMA_GURU, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM
FROM (GURU INNER JOIN SISWA ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM
WHERE GURU.NAMA_GURU=[NAMA_GURU];

3.SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, (ABSEN.JAM_PULANG-ABSEN.JAM_MASUK)*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

4.SELECT SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",2,IIf(PROGRAM.PAKET_PROGRAM="MS-OFFICE",3,IIf(PROGRAM.PAKET_PROGRAM="PHOTOSHOP",6,9))) AS LAMA_BULAN_BELAJAR, IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",200000,IIf(PROGRAM.PAKET_PROGRAM="MS-OFFICE",300000,IIf(PROGRAM.PAKET_PROGRAM="PHOTOSHOP",400000,450000))) AS BIAYA_PERPAKET, (LAMA_BULAN_BELAJAR*BIAYA_PERPAKET) AS TOTAL_BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM;

5.SELECT SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, YEAR(NOW())-YEAR(SISWA.TANGGAL_LAHIR) AS UMUR, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, ABSEN.JAM_MASUK, ABSEN.JAM_PULANG
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

28 May, 2013
Ricky Darmawan said...

Nama : Ricky Darmawan
Kelas : XI.S5
Absen : 24

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

28 May, 2013
Viktorine Ditha Novena said...

Nama : Viktorine Ditha Novena
Kelas : XI.S5
Absen : 33

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

28 May, 2013
Lolyta Destiana said...

Nama : Lolyta Destiana
Kelas : XI.S5
Absen : 16

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

28 May, 2013
Julian Aswar said...

@tiksmaxavega:

soal 1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
soal 2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

29 May, 2013
Yolanda Marisca said...

Tugas-tugas Query, sbb:
1. SELECT Siswa.NIS, Siswa.NAMA_Siswa, YEAR(NOW())-YEAR(Siswa.Tanggal_Lahir) AS Usia, Guru.Nama_Guru, IIf(Program.PAKET_PROGRAM="MS-WINDOWS",200000,IIf(Program.PAKET_PROGRAM="MS-OFFICE",300000,IIf(Program.PAKET_PROGRAM="PHOTOSHOP",400000,450000))) AS Biaya_Perpaket
FROM (Siswa INNER JOIN Guru ON Siswa.KD_Guru=Guru.KD_Guru) INNER JOIN Program ON Siswa.KD_Program=Program.KD_Program;

2.PARAMETERS NAMA_GURU Text ( 255 );
SELECT GURU.NAMA_GURU, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM
FROM (GURU INNER JOIN SISWA ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM
WHERE GURU.NAMA_GURU=[NAMA_GURU];

3.SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, (ABSEN.JAM_PULANG-ABSEN.JAM_MASUK)*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

4.SELECT SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",2,IIf(PROGRAM.PAKET_PROGRAM="MS-OFFICE",3,IIf(PROGRAM.PAKET_PROGRAM="PHOTOSHOP",6,9))) AS LAMA_BULAN_BELAJAR, IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",200000,IIf(PROGRAM.PAKET_PROGRAM="MS-OFFICE",300000,IIf(PROGRAM.PAKET_PROGRAM="PHOTOSHOP",400000,450000))) AS BIAYA_PERPAKET, (LAMA_BULAN_BELAJAR*BIAYA_PERPAKET) AS TOTAL_BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM;

5.SELECT SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, YEAR(NOW())-YEAR(SISWA.TANGGAL_LAHIR) AS UMUR, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, ABSEN.JAM_MASUK, ABSEN.JAM_PULANG
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

Terima kasih,Pak

Nama: Yolanda Marisca
Kelas:XIS5

29 May, 2013
Jessica/14 said...

Jessica/XI IPS 5/ 14

1.PARAMETERS PROGRAM.PAKET_PROGRAM TEXT;
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU,
ABSEN.JAM_MASUK, ABSEN.JAM_PULANG, ([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];

2.SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, YEAR(NOW())-YEAR([SISWA.TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM, IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,IIf(PROGRAM.PAKET_PROGRAM="PhotoShop",300000,200000))) AS BIAYA_KURHUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

30 May, 2013
Putri DS said...

1.PARAMETERS PROGRAM.PAKET_PROGRAM TEXT;
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU,
ABSEN.JAM_MASUK, ABSEN.JAM_PULANG, ([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];

2.SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, YEAR(NOW())-YEAR([SISWA.TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM, IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,IIf(PROGRAM.PAKET_PROGRAM="PhotoShop",300000,200000))) AS BIAYA_KURHUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;


Putri DanaShielvi.XIS5.22

30 May, 2013
Unknown said...

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

Nama: Nikko Suhardy
Kelas/No: XI IPS 5 / 18

30 May, 2013
tarsisius risky kristian/XIs5/01 said...

ABSEN_ID NIS JAM_MASUK JAM_PULANG
1 1001 7:00:00 13:00:00
2 1002 6:30:00 12:00:00
3 1003 7:15:00 14:30:00
4 1004 7:30:00 11:15:00


KD_GURU NAMA_GURU
1 Seto
2 Rosi
3 Hary

KD_PROGRAM PAKET_PROGRAM
A MS-Windows
B MS-Office
C Photoshop
D Web Design

NIS NAMA_SISWA TANGGAL_LAHIR KD_PROGRAM KD_GURU
1001 Ani 01/12/1983 B 1
1002 Ali 09/09/1990 A 1
1003 Badu 10/12/1991 C 2
1004 Citra 10/01/1993 D 3
1005 Dewi 12/06/1996 A 3
1006 Doni 10/10/1989 D 2
1007 Felix 18/12/1985 D 3
1008 Indri 05/10/1982 B 3
1009 Toni 06/07/1988 A 2
1010 Zubadiah 09/12/1994 C 1


nis nama_siswa usia paket_program nama_guru biayaperpaket
1001 Ani 30 MS-Office Seto 300000
1002 Ali 23 MS-Windows Seto 200000
1003 Badu 22 Photoshop Rosi 400000
1004 Citra 20 Web Design Hary 450000
1005 Dewi 17 MS-Windows Hary 200000
1006 Doni 24 Web Design Rosi 450000
1007 Felix 28 Web Design Hary 450000
1008 Indri 31 MS-Office Hary 300000
1009 Toni 25 MS-Windows Rosi 200000
1010 Zubadiah19 Photoshop Seto 400000


NIS NAMA_SISWAPAKET_PROGRAM NAMA_GURU LAMA_JAM_BELAJA
1001 Ani MS-Office Seto 6
1002 Ali MS-WindowsSeto 5,5
1003 Badu Photoshop Rosi 7,25
1004 Citra Web DesignHary 3,75

30 May, 2013
Viky fernando said...

1.
PARAMETERS PAKET_PROGRAM Text;
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];

2.
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
YEAR(NOW())-YEAR([SISWA.TANGGAL_LAHIR]) AS UMUR,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",75000,
IIf(PROGRAM.PAKET_PROGRAM="MS-OFFICE",150000,
IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",300000,200000))) AS BIAYA_KURSUS
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM;

30 May, 2013
TARSISIUS RISKY KRISTIAN/ XIS5/01 said...

SELECT siswa.nis, siswa.nama_siswa, Year(Now())-Year(siswa.tanggal_lahir) AS usia, program.paket_program, guru.nama_guru, IIf(program.paket_program="ms-windows",200000,
IIf(program.paket_program="ms-office",300000,
IIf(program.paket_program="photoshop",400000,450000))) AS biayaperpaket
FROM (siswa INNER JOIN program ON siswa.kd_program = program.kd_program) INNER JOIN guru ON siswa.kd_guru = guru.kd_guru;

30 May, 2013
Unknown said...

1.PARAMETERS PAKET_PROGRAM Text ( 255 );
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, ABSEN.JAM_MASUK, ABSEN.JAM_PULANG, (ABSEN.JAM_PULANG-ABSEN.JAM_MASUK)*24 AS LAMA_JAM_BELAJAR
FROM (PROGRAM INNER JOIN (GURU INNER JOIN SISWA ON GURU.KD_GURU = SISWA.KD_GURU) ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS = ABSEN.NIS
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];



2.SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR, PROGRAM.PAKET_PROGRAM, IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,(IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,(IIf(PROGRAM.PAKET_PROGRAM="Photoshop",300000,200000))))) AS BIAYA_KURSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

31 May, 2013
Cakra Mandala Aura Wijaya said...

1.PARAMETERS PAKET_PROGRAM Text ( 255 );
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, ABSEN.JAM_MASUK, ABSEN.JAM_PULANG, (ABSEN.JAM_PULANG-ABSEN.JAM_MASUK)*24 AS LAMA_JAM_BELAJAR
FROM (PROGRAM INNER JOIN (GURU INNER JOIN SISWA ON GURU.KD_GURU = SISWA.KD_GURU) ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS = ABSEN.NIS
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];



2.SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR, PROGRAM.PAKET_PROGRAM, IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,(IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,(IIf(PROGRAM.PAKET_PROGRAM="Photoshop",300000,200000))))) AS BIAYA_KURSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

31 May, 2013
David Herry Sutanto said...

1.PARAMETERS PAKET_PROGRAM Text ( 255 );
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, ABSEN.JAM_MASUK, ABSEN.JAM_PULANG, (ABSEN.JAM_PULANG-ABSEN.JAM_MASUK)*24 AS LAMA_JAM_BELAJAR
FROM (PROGRAM INNER JOIN (GURU INNER JOIN SISWA ON GURU.KD_GURU = SISWA.KD_GURU) ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS = ABSEN.NIS
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];

2.SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR, PROGRAM.PAKET_PROGRAM, IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,(IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,(IIf(PROGRAM.PAKET_PROGRAM="Photoshop",300000,200000))))) AS BIAYA_KURSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

31 May, 2013
Jessica Stefanus said...

1.PARAMETERS PAKET_PROGRAM Text ( 255 );
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, ABSEN.JAM_MASUK, ABSEN.JAM_PULANG, (ABSEN.JAM_PULANG-ABSEN.JAM_MASUK)*24 AS LAMA_JAM_BELAJAR
FROM (PROGRAM INNER JOIN (GURU INNER JOIN SISWA ON GURU.KD_GURU = SISWA.KD_GURU) ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS = ABSEN.NIS
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];

2.SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR, PROGRAM.PAKET_PROGRAM, IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,(IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,(IIf(PROGRAM.PAKET_PROGRAM="Photoshop",300000,200000))))) AS BIAYA_KURSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

31 May, 2013
tiksmaxavega said...

Siswa yang telah mengumpulkan tugas (sd. tgl. 31 Mei 2013):
1. CAKRA MANDALA AURA WIJAYA
2. CINDY MARCELLA
3. DAVID HERRY SUTANTO
4. DIAN ANGGRAENI
5. DOREA DELLA
6. EDWARD SALIM
7. ELDA NATALIA BARASA
8. FITRI RUSDI
9. FRYDA VALEN
10. HANDOKO
11. JEFFRI ANDREAN ADI
12. JESSICA STEFANUS
13. JULIAN ASHAR
14. LOLYTA DESTIANA
15. MERLI REVITA
16. NIKKO SUHARDY
17. NOVILIANA ROSITA
18. PRISKILLA DEVIE
19. PUTRI DANA SHELVI
20. REVI FIRINDO
21. RICKY DHARMAWAN
22. SALIM KUSUMA
23. SASTRA WIJAYA
24. SHAVIRA PRAMESWARI
25. STEVEN WIJAYA
26. TEDY HAWARI
27. VETY AYU NINGSIH
28. VIKY FERNANDO
29. VIKTORINE DHITA NOVENA
30. VINCENT TRIHATMOJO
31. WIDYA SETYAWAN
32. YOLANDA MARISCA
33. TARSISIUS RISKY KRISSTIAN

31 May, 2013
tiksmaxavega said...

Siswa yang belum mengumpulkan tugas hingga tanggal 31 Mei 2013:
1. I GUSTI NGURAH MADE WIJAYA K.
2. PETRUS BENNY PARULIAN S.
3. VERA RICA YAYANI

Silahkan segera mengerjakan dan mengumpulkan tugas di atas, diberi waktu hingga tanggal 02 Juni 2013.

31 May, 2013

Post a Comment

Silahkan tuliskan komentar Anda dengan sopan dan bijak, tidak menyinggung pihak lain, tidak berisi link aktif sehingga dapat dianggap spam.
Anda tidak punya ID khusus untuk berkomentar?
Gunakan pilihan Name / URL, URL bisa dkosongkan atau diisi dengan alamat Facebook Anda..

Terimakasih atas kunjungannya. Salam XAVEGA