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

41 comment:

Hana Effendi XI.A2 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,
([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;


NAMA : HANA EFFENDI
KELAS : XI.A2
NO.ABSEN : 12

RIKO said...

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

2.SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR, Year(Now())-Year([SISWA.TANGGAL_LAHIR]) AS UMUR,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",2*75000,IIf(PROGRAM.PAKET_PROGRAM=" MS-Office",3*150000,IIf(PROGRAM.PAKET_PROGRAM=" Photoshop",6*300000,9*200000))) AS TOTAL_BIAYA
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
;

NAMA : Riko.Tannuwijaya
KELAS : XI IPA 2
NO : 27

M.Eldhi Putra said...

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

2.
SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, Year(Now())-Year([SISWA.TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM, IIf(PROGRAM.PAKET_PROGRAM="MS-Windows","2"*75000,IIf(PROGRAM.PAKET_PROGRAM=" MS-Office","3"*150000,IIf(PROGRAM.PAKET_PROGRAM=" Photoshop","6"*300000,"9"*200000))) AS TOTAL_BIAYA
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;


M. Eldhi Putra
XI IPA 2
20

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




WEIDY CHANDRA
XI IPA 2
37

Malvin Salim/ XI IPA 2/ 21 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;

Vany Yuliana / XI IPA 2 / 36 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;

Anonymous said...

NAMA: BAYU PRATAMA
KELAS: XI IPA 2
NOMOR ABSEN: 04

JAWABAN:
1. QUERY 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;

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;

Anonymous said...

NAMA: WINDA SARI
KELAS: XI IPA 2
NOMOR ABSEN: 40

JAWABAN:
1. QUERY 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;

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;

Anonymous said...

NAMA: ASTRI WIDI ASTUTI
KELAS: XI IPA 2
NOMOR ABSEN: 03

JAWABAN:
1. QUERY 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;

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;

Anonymous said...

NAMA: ANDREAS EKO SAPUTRO
KELAS: XI IPA 2
NOMOR ABSEN: 02

JAWABAN:
1. QUERY 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;

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;

Anonymous said...

NAMA: TIARA OVIYANI
KELAS: XI IPA 2
NOMOR ABSEN: 34

JAWABAN:
1. QUERY 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;

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;

Kezia Athalia (XI A2) 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;

Nama : Kezia Athalia
Kelas : XI A2
Absen : 19

Novika Anggrilita (XI A2) 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;

Sachin Sabloak said...

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

2.
SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, Year(Now())-Year([SISWA.TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM, IIf(PROGRAM.PAKET_PROGRAM="MS-Windows","2"*75000,IIf(PROGRAM.PAKET_PROGRAM=" MS-Office","3"*150000,IIf(PROGRAM.PAKET_PROGRAM=" Photoshop","6"*300000,"9"*200000))) AS TOTAL_BIAYA
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;

Sachin Sabloak
XI IPA 2
28

Stephen sanjaya sunyata said...

1.
SELECT
SISWA.NIS, SISWA.NAMA_SISWA, YEAR(NOW())-YEAR(SISWA.TANGGAL_LAHIR) AS USIA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIF(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",200000,
IIF(PROGRAM.PAKET_PROGRAM="MS-OFFICE",300000,
IIF(PROGRAM.PAKET_PROGRAM="PHOTOSHOP",400000,450000))) AS BIAYA_PERPAKET
FROM (SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM;
2.
SELECT SISWA.NIS, 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)))*30 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, IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",2*200000,IIf(PROGRAM.PAKET_PROGRAM="MS-OFFICE",3*300000,IIf(PROGRAM.PAKET_PROGRAM="PHOTOSHOP",6*400000,9*450000))) AS TOTAL_BIAYA
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;


STEVEN said...

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

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;
STEVEN/32 XIA2

JERRY said...

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

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;

JERRY

diana said...

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

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;

DIANA WIJAYA

Anonymous said...

NAMA: IVAN SUPARTO
KELAS: XI IPA 2
NO ABSEN: 14
JAWABAN:
1.QUERY 1:
=>PARAMETERS SISWA.NAMA_SISWA Text ( 225 );
SELECT SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS;

2.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;

Jennyver 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 : Jennyver Seztiani Luxman
Kelas : XIA2
No : 16

Indri 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 : Indri
Kelas : XIA2
No. Absen : 13

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

Darwin Susilo said...

Nama : Darwin Susilo
Kelas : XI IPA 2
No : 6

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

wim pratama wijaya said...

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



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

Olivia Windiyanto (25) said...

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



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;

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

Denny Wijaya said...

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

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

dari Denny Wijaya absen:08 XI ipa2

Aileen Novera said...

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

Soal 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_KURSUS

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

Nama : Aileen Novera
Kelas : XIA2/01

Terima kasih :)

Bella Puspita X1A2 / 05 said...

Jawaban soal nomor 1.
Query 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 GURU ON SISWA.KD_GURU=GURU.KD_GURU) INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS

Jawaban soal nomor 2.
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","75000",
IIF(SISWA.KD_PROGRAM="B","150000",
IIF(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA_KURSUS

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

selly susanto 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;


selly susanto/29

tari alvita 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;


tari alvita/33

Renaldo Novianto said...

NAMA : RENALDO NOVIANTO
KELAS/NO.ABSEN : XI IPA 2 / 26

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



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","75000",
IIF(SISWA.KD_PROGRAM="B","150000",
IIF(SISWA.KD_PROGRAM="C","300000","200000"))) AS BIAYA_KURSUS

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

Anonymous said...

NAMA: JEFFRY PUTRATAMA
NOMOR ABSEN: 15
KELAS: XI IPA 2

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

2.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;

Doni Mikha said...

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

2.SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year([SISWA.TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",2*75000,IIf(PROGRAM.PAKET_PROGRAM=" MS-Office",3*150000,IIf(PROGRAM.PAKET_PROGRAM=" Photoshop",6*300000,9*200000))) AS TOTAL_BIAYA
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
;

Doni Mikha
XI IPA 2
10

Anonymous said...

Nama: Farhan Akmal
Kelas: XI IPA 2
Nomor Absen: 11

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

2. 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;

Stephen Taslim kohar said...

Q1 : PARAMETERS SISWA.NAMA_SISWA Text ( 225 );
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRA­M, GURU.NAMA_GURU, ABSEN.JAM_MASUK, ABSEN.JAM_PULANG, ([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*2­4 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.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([TA­NGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRA­M, IIf(PAKET_PROGRAM="M­S-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;

Stephen Taslim kohar
XI IPA2
31

Anonymous said...

Delizea Albertha/XIA2/7
Q1 : PARAMETERS SISWA.NAMA_SISWA Text ( 225 );
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRA­M, GURU.NAMA_GURU, ABSEN.JAM_MASUK, ABSEN.JAM_PULANG, ([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*2­4 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.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([TA­NGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRA­M, IIf(PAKET_PROGRAM="M­S-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;

Willy Leo Purnama said...

Q1 : PARAMETERS SISWA.NAMA_SISWA Text ( 225 );
SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRA­­M, GURU.NAMA_GURU, ABSEN.JAM_MASUK, ABSEN.JAM_PULANG, ([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*2­­4 AS LAMA_JAM_BELAJAR
FROM ((SISWA INNER JOIN GURU ON SISWA.KD_GURU=GURU.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([TA­­NGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRA­­M, IIf(PAKET_PROGRAM="M­­S-Windows",75000,II­f(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;



Nama : Willy Leo Purnama
Kelas : XI IPA 2
No.Absen : 38

tomi trio saputra said...

2. SELECT SISWA.NIS, SISWA.NAMA_SISWA, YEAR(NOW())-YEAR(SISWA.TANGGAL_LAHIR) AS USIA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, IIF(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",75000,
IIF(PROGRAM.PAKET_PROGRAM="MS-OFFICE",150000,
IIF(PROGRAM.PAKET_PROGRAM="PHOTOSHOP",300000,200000))) 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;
1. SELECT SISWA.NIS, SISWA.NAMA_SISWA, PROGRAM.PAKET_PROGRAM, GURU.NAMA_GURU, HOUR(ABSEN.JAM_PULANG)-HOUR(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;

Jimmy Arifin / XIA2 / 18 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;

Jimmy Arifin / XIA2/ 18

tiksmaxavega said...

Siswa yang telah mengumpulkan tugas (sd. tgl 28 Mei 2013):
1. AILEEN NOVERA
2. ANDREAS EKO SAPUTRO
3. ASTRI WIDI ASTUTI
4. BAYU PRATAMA
5. BELLA PUSPITA
6. DARWIN SUSILO
7. DELIZEA ALBERTHA
8. DENNY WIJAYA
9. DIANA
10. DONI MIKHA
11. FARHAN AKMAL
12. HANA EFFENDI
13. INDRI
14. IVAN SUPARTO
15. JEFFRY PUTRATAMA
16. JENNYVER SEZTIANI LUXMAN
17. JERRY
18. JIMMY ARIFIN
19. KEZIA ATHALIA
20. M. ELDHI PUTRA
21. MALVIN SALIM
22. NESYA PUTRI AYU
23. NICOLAS
24. NOVIKA ANGGRILITA
25. OLIVIA WINDIYANTO
26. RENALDO NOVIANTO
27. RIKO TANUWIJAYA
28. SACHIN SABLOAK
29. SELLY SUSANTO
30. STEPHEN SANJAYA SUNYATA
31. STEPHEN TASLIM KOHAR
32. STEVEN
33. TARI ALVITA
34. TIARA OVIYANI
35. TOMI TRIO SAPUTRA
36. VANY YULIANA
37. WEIDY
38. WILLY LEO PURNAMA
39. WIM PRATAMA WIJAYA
40. WINDA SARI

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