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.
Posted on 5/18/2013
Category:

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

23 May, 2013
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

23 May, 2013
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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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

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

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

25 May, 2013
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

25 May, 2013
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;

25 May, 2013
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;

25 May, 2013
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;

25 May, 2013
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;

25 May, 2013
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;

25 May, 2013
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

25 May, 2013
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 :)

25 May, 2013
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;

25 May, 2013
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

25 May, 2013
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

25 May, 2013
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;

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

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

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

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

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

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

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

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

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

28 May, 2013

Post a Comment

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

Terimakasih atas kunjungannya. Salam XAVEGA