Tugas 2 Kelas XI IPA 1 : 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:

43 comment:

Alberthus Dimas said...

NAMA:ALBERTHUS DIMAS ANANTA
KELAS : XI IPA 1 / 03

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;

22 May, 2013
Charles said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

23 May, 2013
Margaretha A.K said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

23 May, 2013
Selvia P said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

23 May, 2013
Fernando said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

23 May, 2013
Fallicia A said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

23 May, 2013
Novia V said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

23 May, 2013
Chessie C said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

23 May, 2013
Ronny I said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

23 May, 2013
Yoseph Kurniawan said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

23 May, 2013
Richard S said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

23 May, 2013
Hani Effendi XI IPA 1 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;

23 May, 2013
Novita Sari Susanto said...

Nama : Novita Sari
Kelas : XI IPA 1
No. Absen : 25




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;

23 May, 2013
Unknown said...

QUERY PERTAMA

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

WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];


QUERY KE DUA

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

24 May, 2013
Nirwan Setiawan /XI A1/ 23 said...

Q1
PARAMETERS PAKET_PROGRAM TEXT;
SELECT

SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
HOUR(ABSEN.JAM_PULANG-ABSEN.JAM_MASUK) 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
WHERE PROGRAM.PAKET_PROGRAM=(PAKET_PROGRAM);




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

Nirwan Setiawan / XIA1 / 23

24 May, 2013
Willy / XIA1 / 38 said...

Q1
PARAMETERS PAKET_PROGRAM TEXT;
SELECT

SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
HOUR(ABSEN.JAM_PULANG-ABSEN.JAM_MASUK) 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
WHERE PROGRAM.PAKET_PROGRAM=(PAKET_PROGRAM);




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

Willy / XIA1 / 38

24 May, 2013
Yacintha Marsella (XI A1) (40) 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
Levita Tiara Yosefin (XI A1) (19) 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
Jessica 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 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.KD_PROGRAM=[PROGRAM.KD_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;

24 May, 2013
Ferryanto Santoso 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;

25 May, 2013
Septiany said...

sql 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

sql 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

25 May, 2013
Stefany said...

sql 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

sql 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

25 May, 2013
Ricky Saputra Salim / 27 / XI IPA 1 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;

25 May, 2013
Erick Jordan said...

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

25 May, 2013
Nindy Putri Ayu (22) said...

Q1 : 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;



Q2 : 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;

25 May, 2013
Sonny Y said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

25 May, 2013
Agnes D said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

25 May, 2013
Amelia Marines said...

QUERY 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, ([JAM_PULANG]-[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 PROGRAM.KD_PROGRAM=SISWA.KD_PROGRAM
WHERE PROGRAM.PAKET_PROGRAM =[PAKET_PROGRAM];

QUERY 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="A","Rp.75.000,00",IIf(SISWA.KD_PROGRAM="B","Rp.150.000,00",IIf(SISWA.KD_PROGRAM="C","Rp.300.000,00","Rp.250.000,00"))) AS BIAYA_KURSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

25 May, 2013
Amelia Marines said...

QUERY 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, ([JAM_PULANG]-[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 PROGRAM.KD_PROGRAM=SISWA.KD_PROGRAM
WHERE PROGRAM.PAKET_PROGRAM =[PAKET_PROGRAM];

QUERY 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="A","Rp.75.000,00",IIf(SISWA.KD_PROGRAM="B","Rp.150.000,00",IIf(SISWA.KD_PROGRAM="C","Rp.300.000,00","Rp.250.000,00"))) AS BIAYA_KURSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

25 May, 2013
Tomi said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

25 May, 2013
elizabeth widiastuti said...

nama:elizabeth widiastuti
kelas:XIA1
no.absen:10

scl 1:
PARAMETERS PAKET_PROGRAM Text ( 255 );
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 GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS) INNER JOIN PROGRAM ON PROGRAM.KD_PROGRAM=SISWA.KD_PROGRAM
WHERE PROGRAM.PAKET_PROGRAM =[PAKET_PROGRAM];

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

25 May, 2013
Adam S said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

26 May, 2013
Stevan Wilfredo N said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

26 May, 2013
Wim Benhard M said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

26 May, 2013
Franky Saputra 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.
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:Franky Saputra
Kelas:XIA1
Absen : 15

26 May, 2013
Selly Agustina said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

27 May, 2013
Chornellia Diwasasri Putri said...

1. PARAMETERS PROGRAM.KD_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=[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
Johanes P said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

27 May, 2013
Stefanus Evan said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

27 May, 2013
Dian F said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

29 May, 2013
Vinsensius K said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

30 May, 2013
M. Amanullah Abdussomad F said...

SQL 1
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIf(SISWA.KD_PROGRAM="A","200000",IIf(SISWA.KD_PROGRAM="B","300000",IIf(SISWA.KD_PROGRAM="C","400000","450000"))) AS BIAYA, ([ABSEN.JAM_PULANG]-[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;

SQL 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="A","75000",IIf(SISWA.KD_PROGRAM="B","150000",IIf(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM = PROGRAM.KD_PROGRAM;

01 June, 2013
tiksmaxavega said...

Siswa yang sudah mengumpulkan tugas(s/d tgl. 01 Juni 2013):
1. ADAM SATRIA
2. AGNES D.
3. ALBERTHUS DIMAS ANANTA
4. AMELIA MARINES
5. CHARLES
6. CHESSIE C
7. CHORNELIA DIWASASRI PUTRI
8. DAVID LIE
9. DIAN F
10. ELIZABETH WIDIASTUTI
11. ERICK JORDAN
12. FALLICIA ANGWEN
13. FERNANDO
14. FERYANTO SANTOSO
15. FRANKY SAPUTRA
16. HANI EFFENDI
17. JESSICA
18. JOHANNES PARLINDUNGAN
19. LEVITA TIARA YOSEFIN
20. M. AMANULLAH ABDUSSOMAD F.
21. MARGARETHA A.K
22. NINDY PUTRI AYU
23. NIRWAN SETIAWAN
24. NOVIA V.
25. NOVITA SARI SUSANTO
26. RICHARD S
27. RICKY SAPUTRA SALIM
28. RONNI IMMANUEL
29. SELLY AGUSTINA
30. SELVIA P.
31. SEPTIANI
32. SONNY Y
33. STEFANUS EVAN
34. STEFANY
35. STEVAN WILFREDO NENO
36. TOMI
37. VINSENSIUS K.
38. WILLY
39. WIM BENHARD M
40. YACHINTA MARSELLA
41. YOSEPH KURNIAWAN

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