Tugas 2 Kelas XI IPS 3 : 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:

52 comment:

yuliani said...

Jawaban Soal No 1 :

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;


Jawaban Soal No 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;

19 May, 2013
Halwi Gopriadi Wijaya said...

Nama : Halwi Gopriadi Wijaya
Kelas: XI IPS 3
No. Absen : 14

Jawaban :
1. PARAMETERS PAKET_PROGRAM Text;

SELECT SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([JAM_PULANG]-[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([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;

22 May, 2013
mmm said...

Nama:Wendy Alexander Christanto
Kelas XI S3
No: 36

soal no 1
SELECT
absen.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 no 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 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;




22 May, 2013
dharmawanraka 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;


Nama : Raka Dharmawan
Kelas : XIS3
No Absn : 26

22 May, 2013
dharmawanraka 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

Nama : Raka Dharmawan
Kelas : XIS3
No Absn : 26

22 May, 2013
dharmawanraka 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

Viviana / XIS3

22 May, 2013
yulius william /xis3/44 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

23 May, 2013
silvia noviani xis3 29 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

23 May, 2013
rineke rilians XIS3 28 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

23 May, 2013
viviana XIS3 35 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

23 May, 2013
yesi veronica 39 XIS3 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

23 May, 2013
Stevanny tjiandra / XI S3 / 31 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

23 May, 2013
Sucipto 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

SUCIPTO XIS3

23 May, 2013
Yesi XIS3 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

23 May, 2013
Sep Ta Nus 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

23 May, 2013
Anggara 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

23 May, 2013
Budi said...

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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

23 May, 2013
Yohanes Stevens T 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, CSTR(HOUR(JAM_PULANG)-HOUR(JAM_MASUK))+"JAM" 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, PROGRAM.PAKET_PROGRAM, IIf([PROGRAM]![PAKET_PROGRAM]="MS-WINDOWS",75000,IIf([paket_program]="MS-OFFICE",150000,IIf([paket_program]="Photoshop",150000,IIf([paket_program]="MS-OFFICE",150000,200000)))) AS biaya_kursus, CStr(Year(Now())-Year([SISWA]![TANGGAL_LAHIR]))+" th" AS umur
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;


YOHANES STEVENS T/XIS3/41

23 May, 2013
Yohanes Stevens T 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, CSTR(HOUR(JAM_PULANG)-HOUR(JAM_MASUK))+"JAM" 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, PROGRAM.PAKET_PROGRAM, IIf([PROGRAM]![PAKET_PROGRAM]="MS-WINDOWS",75000,IIf([paket_program]="MS-OFFICE",150000,IIf([paket_program]="Photoshop",150000,IIf([paket_program]="MS-OFFICE",150000,200000)))) AS biaya_kursus, CStr(Year(Now())-Year([SISWA]![TANGGAL_LAHIR]))+" th" AS umur
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;


YOHANES STEVENS T/XIS3/41

23 May, 2013
Yohanes Stevens T 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, CSTR(HOUR(JAM_PULANG)-HOUR(JAM_MASUK))+"JAM" 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, PROGRAM.PAKET_PROGRAM, IIf([PROGRAM]![PAKET_PROGRAM]="MS-WINDOWS",75000,IIf([paket_program]="MS-OFFICE",150000,IIf([paket_program]="Photoshop",150000,IIf([paket_program]="MS-OFFICE",150000,200000)))) AS biaya_kursus, CStr(Year(Now())-Year([SISWA]![TANGGAL_LAHIR]))+" th" AS umur
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;


YOHANES STEVENS T/XIS3/41

23 May, 2013
Steven Candra (XIS3) said...

1. 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 ABSEN ON SISWA.NIS=ABSEN.NIS) INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU;
2. SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
PROGRAM.PAKET_PROGRAM,
Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR,
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;

24 May, 2013
Donny / XIS3 / 08 said...

1
SELECT
ABsen.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;

25 May, 2013
Steven Hidayat / XIS3 / 33 said...

1
SELECT
ABsen.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;

25 May, 2013
Henny.Junita 17 said...

Nama : Henny.Junita
Kelas: XI IPS 3
Absen: 17

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
Eko Wijaya Putra Utama said...

Nama : Eko Wijaya Putra Utama
Kelas : XI IPS 3
No.Absen : 9


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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

26 May, 2013
Franco Putra 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 (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;

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 (PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS = ABSEN.NIS;

Franco Putra Sidharta
XI.S3
10

26 May, 2013
Eko Wijaya Putra Utama said...

Nama : Eko Wijaya Putra Utama
Kelas : XI IPS 3
No.Absen : 9
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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

26 May, 2013
Devitha 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

27 May, 2013
Yudhita 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

27 May, 2013
Jovita 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

27 May, 2013
Franco Putra 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;

Franco Putra Sidharta
XI.S3
10

27 May, 2013
Jordy Malikulmulki Wicaksana said...

Nama : Jordy Malikulmulki Wicaksana
Kelas : XI IPS 3
Absen : 18

SQL untuk soal nomor 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 ((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];

dan SQL untuk soal nomor 2:
SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR, PROGRAM.PAKET_PROGRAM, IIF(SISWA.KD_PROGRAM="MS-WINDOWS",75000,IIF(SISWA.KD_PROGRAM="MS-OFFICE",150000,IIF(SISWA.KD_PROGRAM="PHOTOSHOP",300000,200000))) AS BIAYA_BELAJAR
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

27 May, 2013
Gesella Okita Andini said...

Nama : Gesella Okita Andini
Kelas : XI IPS 3
Absen : 12

SQL untuk soal nomor 1 adalah sebagai berikut

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 ((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];

dan SQL untuk soal nomor 2 adalah sebagai berikut
SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR, PROGRAM.PAKET_PROGRAM, IIF(SISWA.KD_PROGRAM="MS-WINDOWS",75000,IIF(SISWA.KD_PROGRAM="MS-OFFICE",150000,IIF(SISWA.KD_PROGRAM="PHOTOSHOP",300000,200000))) AS BIAYA_BELAJAR
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

27 May, 2013
Nadine Brillianta Hanifah/24/XI IPS 3 said...

Jawaban No. 1

PARAMETERS SISWA.NAMA_SISWA 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 SISWA.NAMA_SISWA=[NAMA_SISWA];


Jawaban No. 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",750000,
IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop",300000,200000))) AS BIAYA_PERPAKET
FROM PROGRAM INNER JOIN (GURU INNER JOIN SISWA ON GURU.KD_GURU = SISWA.KD_GURU) ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

27 May, 2013
Monika Tri Wahyu Ningsih said...

Nama : Monika Tri Wahyu Ningsih
Kelas : XI IPS 3
Absen : 23

SQL untuk soal nomor 1 yaitu

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 ((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];

dan SQL untuk soal nomor 2 yaitu
SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR, PROGRAM.PAKET_PROGRAM, IIF(SISWA.KD_PROGRAM="MS-WINDOWS",75000,IIF(SISWA.KD_PROGRAM="MS-OFFICE",150000,IIF(SISWA.KD_PROGRAM="PHOTOSHOP",300000,200000))) AS BIAYA_BELAJAR
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

27 May, 2013
Gesela Okita A/12 said...

PARAMETERS SISWA.NAMA_SISWA 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 SISWA.NAMA_SISWA=[NAMA_SISWA];

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",750000,
IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop",300000,200000))) AS BIAYA_PERPAKET
FROM PROGRAM INNER JOIN (GURU INNER JOIN SISWA ON GURU.KD_GURU = SISWA.KD_GURU) ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

27 May, 2013
Monika Triwahyu N/23 said...

PARAMETERS SISWA.NAMA_SISWA 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 SISWA.NAMA_SISWA=[NAMA_SISWA];

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",750000,
IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop",300000,200000))) AS BIAYA_PERPAKET
FROM PROGRAM INNER JOIN (GURU INNER JOIN SISWA ON GURU.KD_GURU = SISWA.KD_GURU) ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

27 May, 2013
Cindy Marvina :D said...

Nama : Cindy Marvina
Kelas : XI IPS 3
Absen : 4

Berikut adalah SQL untuk soal nomor 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 ((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];

dan yang ini adalah SQL untuk soal nomor 2
SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR, PROGRAM.PAKET_PROGRAM, IIF(SISWA.KD_PROGRAM="MS-WINDOWS",75000,IIF(SISWA.KD_PROGRAM="MS-OFFICE",150000,IIF(SISWA.KD_PROGRAM="PHOTOSHOP",300000,200000))) AS BIAYA_BELAJAR
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

^_^ :D XD :3

27 May, 2013
Daniel 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

28 May, 2013
Erik cristian said...

Erik cristian
xis6 13

1.
PARAMETERS PAKET_PROGRAM Text ( 255 );
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
WHERE ((PROGRAM.PAKET_PROGRAM)=[PAKET_PROGRAM]);

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
Desy Frans 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

28 May, 2013
Michael Bong/22/XIS3 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

28 May, 2013
fredy muliawan /XIS3/11 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
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 (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

28 May, 2013
Gustafianto Salim said...

1
SELECT
Siswa.NIS,
siswa.Nama_Siswa,
Program.Paket_Progra­m,
Guru.Nama_Guru,
absen.Jam_Masuk,
absen.Jam_Pulang,
Hour(absen.jam_Pulan­g)-Hour(absen.Jam_Ma­suk) 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(sis­wa.Tanggal_lahir) as Umur,
Program.Paket_Progra­m,
iif(Program.Paket_Pr­ogram = "MS-Windows" , 75000, iif(Program.Paket_Pr­ogram = "MS-Office" , 150000, iif(Program.Paket_Pr­ogram = "Photoshop", 300000, 200000))) as Biaya_Kursus

FROM (siswa inner join absen on siswa.nis=absen.nis)­ inner join program on siswa.KD_program=pro­gram.KD_program;

Nama : Gustafianto Salim
Kelas : XIS3 / 13

30 May, 2013
hendra 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
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_Pr­­ogram = "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:hendra
kelas:XIS3/16

30 May, 2013
maynardo said...

1
SELECT
Siswa.NIS,
siswa.Nama_Siswa,
Program.Paket_Progra­m,
Guru.Nama_Guru,
absen.Jam_Masuk,
absen.Jam_Pulang,
Hour(absen.jam_Pulan­g)-Hour(absen.Jam_Ma­suk) 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(sis­wa.Tanggal_lahir) as Umur,
Program.Paket_Progra­m,
iif(Program.Paket_Pr­ogram = "MS-Windows" , 75000, iif(Program.Paket_Pr­ogram = "MS-Office" , 150000, iif(Program.Paket_Pr­ogram = "Photoshop", 300000, 200000))) as Biaya_Kursus

FROM (siswa inner join absen on siswa.nis=absen.nis)­ inner join program on siswa.KD_program=pro­gram.KD_program;

nama:maynardo yaprian
kelas:XIS3/21

30 May, 2013
Maria Amelia 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;


Maria Amelia XI IPS 3/20

30 May, 2013
Wiwin said...

Nama : Wiwin
Kelas :XIS3
No : 38

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
harveyks 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;

30 May, 2013
Wina Desiana said...

1
SELECT
Siswa.NIS,
siswa.Nama_Siswa,
Program.Paket_Progra­m,
Guru.Nama_Guru,
absen.Jam_Masuk,
absen.Jam_Pulang,
Hour(absen.jam_Pulan­g)-Hour(absen.Jam_Ma­suk) 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(sis­wa.Tanggal_lahir) as Umur,
Program.Paket_Progra­m,
iif(Program.Paket_Pr­ogram = "MS-Windows" , 75000, iif(Program.Paket_Pr­ogram = "MS-Office" , 150000, iif(Program.Paket_Pr­ogram = "Photoshop", 300000, 200000))) as Biaya_Kursus

FROM (siswa inner join absen on siswa.nis=absen.nis)­ inner join program on siswa.KD_program=pro­gram.KD_program;

nama:wina desiana
kelas:XIS3/37

31 May, 2013
tiksmaxavega said...

Siswa yang telah mengumpulkan tugas (sd. tgl. 31 Mei 2013):
1. ANGGARA
2. BUDI SETIAWAN
3. CINDY MARVINA
4. DANIEL HERRY SUTANTO
5. DESY FRANS
6. DEVITA SISKA
7. DONNY
8. EKO WIJAYA PUTRA UTAMA
9. FRANCO PUTRA SIDHARTA
10. FREDY MULIAWAN
11. GESELA OKITA
12. GUSTAFIANTO SALIM
13. HALWI GOPRIADI WIJAYA
14. HARVEY KURNIA
15. HENDRA
16. HENNY JUNITA
17. JORDI MALIKULMULKI WICAKSANA
18. JOVITA
19. MARIA AMELIA
20. MAYNARDO YAPRIAN
21. MICHAEL BONG
22. MONIKA TRI WAHYUNI
23. NADINE BRILIANATA HANIFAH
24. RAKA DHARMAWAN
25. RINEKE RILIANCE
26. SEPTANUS
27. SILVIA NOVIANI
28. STEVANNY TJIANDRA
29. STEVEN CHANDRA
30. STEVEN HIDAYAT
31. SUCIPTO
32. VIVIANA
33. WENDY ALEXANDER CHRISTANTO
34. WINA DESIANA
35. WIWIN
36. YESI VERONICA
37. YOHANES STEVENS T
38. YUDHITA
39. YULIUS WILLIAM

31 May, 2013
tiksmaxavega said...

Siswa yang belum mengumpulkan tugas hingga tanggal 31 Mei 2013:
1. ALDIAN FEBRIZAL
2. PARLINDUNGAN LASE
3. SONNY JIWANATA
4. YOGI SAPUTRA
5. YULIANI

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