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

53 comment:

Stefanny Lawrencia Susanto (XI S6) 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
Sherly 34 said...

Nama : Sherly
Absen : 34
Kelas : XI IPS 6

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
Yuliana Kardi 45 said...

Nama : Yuliana Kardi
Kelas XI IPS 6
Absen : 45

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
Medita Fera 21 said...

Nama : Medita Fera
Absen : 21
Kelas : XI IPS 6

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
Patrick.Mandera 27 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: Patrick.M
Kelas: XI IPS 6
Absen: 27

26 May, 2013
stevanie maria leonardi / xis6 / 38 said...

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((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="PHOTOSHOP",300000,200000))) AS BIAYA_KURSUS
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM:PROGRAM.KD_PROGRAM;

26 May, 2013
winardi / XIS6 said...

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((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="PHOTOSHOP",300000,200000))) AS BIAYA_KURSUS
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM:PROGRAM.KD_PROGRAM;

26 May, 2013
Bernhardhito M.A.E Abs. 05 XI IPS 6 said...

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

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 PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

26 May, 2013
YOHANES ALDO PANGESTU XI IPS 6/44 said...

Nomor 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 ABSEN ON SISWA.NIS=ABSEN.NIS) INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU)INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM)
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM]


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

26 May, 2013
ADE PUTRY S.C XI IPS 6 / 01 said...

NO. 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]

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

26 May, 2013
Devita Agustina / XIS6 / 09 said...

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 ((SISWA INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS)
INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU)
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_KURSUS

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

26 May, 2013
Yoan Laura Angelia / 43 said...

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

26 May, 2013
M alif prasanto said...

Nama : m alif prasanto
kelas : XI.S6
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;

26 May, 2013
deka hadi saputra 07 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;

26 May, 2013
Julio Medy 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;

26 May, 2013
Haryanto XI IPS 6 / 15 said...

RUMUS SQL :

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
robert effendi 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
rudianto 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
Valnando Ignatius /XI IPS 6/39 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
Edbert Rob Giovan 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
Edbert Rob Giovan 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
kevin 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
Fenki Kutrismo/14 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
Antonius Saputra 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
ANTONIUS SAPUTRA/ XIS6 said...

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 ((SISWA INNER JOIN PROGRAMON 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="PHOTOSHOP",300000,200000))) AS BIAYA_KURSUS
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM:PROGRAM.KD_PROGRAM;

27 May, 2013
VINSENTIUS YOSEP said...

QUERY 1 :
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN_ID.JAM_MASUK,
ABSEN_ID.JAM_PULANG,
HOUR(ABSEN_ID.JAM_PULANG)-HOUR(ABSEN_ID.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_ID ON SISWA.NIS=ABSEN_ID.NIS;

QUERY 2 :
SELECT
ABSEN_ID.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_ID ON SISWA.NIS=ABSEN_ID.NIS) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM;

VINSENTIUS YOSEP / XIS6 / 41

27 May, 2013
ANTONIUS SAPUTRA/ XIS6 said...

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 ((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 SISEA.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 SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM:PROGRAM.KD_PROGRAM;

27 May, 2013
Elizabeth Jacilin said...

Nama : Eizabeth Jacilin
No : 12

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 ((SISWA INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS)
INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU)
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_KURSUS

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

27 May, 2013
Amelia Pramita said...

Nama : Amelia Pramita
No : 02

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 ((SISWA INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS)
INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU)
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_KURSUS

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

27 May, 2013
monica 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 (SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU;

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 PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM;

Nama : Monica Melvi
Kelas : XIS6
No. absen : 23

27 May, 2013
Anonymous 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
Satria Putratama Kelas:XI IPS 6 No.Absen:33 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
Rosahap PPS 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;

28 May, 2013
clara natasha / XIS6 / 7 said...

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 ((SISWA INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS)
INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU)
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_KURSUS

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

28 May, 2013
Novilia Gunawan 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;

28 May, 2013
Maria Inne Dwirama said...

NAMA: Maria Inne Dwirama
Kelas: XIS6
Absen:20

SQL No.1

PARAMETERS PAKET_PROGRAM Text ( 20 );
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]
;

SQL No.2

SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year(SISWA.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_KURSUS


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

28 May, 2013
robert effendi 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;

29 May, 2013
Jopy stefannus said...

Nama : Jopy Stefannus
Kelas: xis6
Absen: 16

SQL No.1

PARAMETERS PAKET_PROGRAM Text ( 20 );
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]
;

SQL No.2

SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year(SISWA.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_KURSUS


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

29 May, 2013
michael haryadi 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
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;

30 May, 2013
robert effendi 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
ega varian honora 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
M. ali jumardin 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
DENDY W 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;


DENDY WIJAYA
08
XI IPS 6

30 May, 2013
Anonymous said...

1.
PARAMETERS program.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 ((GURU INNER JOIN SISWA ON GURU.KD_GURU=SISWA.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON absen.nis=siswa.nis
WHERE program.paket_program=[paket_program];

2.
PARAMETERS program.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 ((GURU INNER JOIN SISWA ON GURU.KD_GURU=SISWA.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON absen.nis=siswa.nis
WHERE program.paket_program=[paket_program];

nama:phoebee , kelas:xis6 , absen 28

30 May, 2013
Ricky Vinando said...

RICKY VINANDO/29/XIS6

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
Novilia Gunawan said...

Novilia Gunawan/XIS6

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
Sherly Natasha said...

Sherly Natasha/XIS6

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

31 May, 2013
Vera Wijaya said...

Berikut hasil isian yang saya buat :

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

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

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

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

Nomor 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 : Vera Wijaya
Kelas : XI S6

31 May, 2013
nadya nikita bokong 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: nadya nikita bokong
absen : 25

31 May, 2013
STEFANIE said...

STEFANIE/ XIS6

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;

01 June, 2013
tiksmaxavega said...

Siswa yang telah mengumpulkan tugas (sd. tgl. 01 Juni 2013):
1. ADE PUTRY S.C
2. AMELIA PRAMITA
3. ANITA
4. ANTONIUS SAPUTRA
5. BERNHADHITO M.A.E
6. CLARA NATASHA
7. DEKA HADI SAPUTRA
8. DENDY WIJAYA
9. DEVITA AGUSTINA
10. EDBERT ROB GIOVAN
11. EGA VARIAN HONORA
12. ELIZABETH JACILIN
13. ERIK CHRISTIAN
14. FENKY KUTRISMO
15. HARYANTO
16. JOPY STEFANNUS
17. JULIO MEDY
18. KEVIN
19. M. ALI DJUMARDIN
20. M. ALIF PRASANTO
21. MARIA INNE DWIRAMA
22. MEDITA FERA
23. MICHAEL HARYADI
24. MONICA
25. NIKITA NADYA BOKONG
26. NOVILIA GUNAWAN
27. PATRICK MANDERA
28. PHOE BEE
29. RICKY VINANDO
30. ROBERT EFFENDI
31. ROSAHAP PPS
32. RUDIANTO
33. SATRIA PUTRATAMA
34. SHERLY
35. SHERLY NATASHA
36. STEFANIE
37. STEFANNY LAWRENCIA SUSANTO
38. STEVANIE MARIA LEONARDI
39. VALNANDO IGNATIUS
40. VERA WIJAYA
41. VINSENTIUS YOSEP
42. WINARDI
43. YOAN LAURA ANGELIA
44. YOHANES ALDO PANGESTU
45. YULIANA KARDI

01 June, 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