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

44 comment:

Redy Djunizar / 29 / XI IPS 4 said...

1. PARAMETERS PAKET_PROGRAM Text ;
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([JAM_PULANG]-[JAM_MASUK])*24 AS LAMA_JAM_BELAJAR


FROM ((SISWA INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS)
INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU)
INNER JOIN PROGRAM ON
SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];

2. SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,
IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop",300000,200000)))
AS BIAYA_KURSUS

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

26 May, 2013
Anonymous said...

Nama: Sella Juel
Kelas XI IPS 4
Nomor Absen: 33

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
Tomy XI.S4 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;


Nama : Tomy
Kelas : XI.S4

27 May, 2013
Fablius Fernando XIS4/13 said...

Tugas 2 TIK

1.
PARAMETERS PAKET_PROGRAM Text ( 255 );
SELECT Siswa.nis, siswa.nama_siswa, program.paket_program, Guru.Nama_Guru, absen.Jam_masuk, absen.Jam_pulang, Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
FROM ((siswa INNER JOIN guru ON siswa.KD_Guru=guru.KD_guru) INNER JOIN program ON siswa.KD_program=program.KD_program) INNER JOIN absen ON siswa.NIS=absen.NIS
WHERE ((PROGRAM.PAKET_PROGRAM)=[PAKET_PROGRAM]);

2.
SELECT absen.NIS, siswa.Nama_Siswa, Siswa.tanggal_lahir, Year(now())-Year(siswa.Tanggal_lahir) AS Umur, Program.Paket_Program, iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) AS Biaya_Kursus
FROM (siswa INNER JOIN absen ON siswa.nis=absen.nis) INNER JOIN program ON siswa.KD_program=program.KD_program;

Nama: Fablius Fernando
Kelas/no:XIS4/13

28 May, 2013
Tomy XIS4/37 said...

tugas komputer
1.
PARAMETERS PAKET_PROGRAM Text ( 255 );
SELECT Siswa.nis, siswa.nama_siswa, program.paket_program, Guru.Nama_Guru, absen.Jam_masuk, absen.Jam_pulang, Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
FROM ((siswa INNER JOIN guru ON siswa.KD_Guru=guru.KD_guru) INNER JOIN program ON siswa.KD_program=program.KD_program) INNER JOIN absen ON siswa.NIS=absen.NIS
WHERE ((PROGRAM.PAKET_PROGRAM)=[PAKET_PROGRAM]);

2.
SELECT absen.NIS, siswa.Nama_Siswa, Siswa.tanggal_lahir, Year(now())-Year(siswa.Tanggal_lahir) AS Umur, Program.Paket_Program, iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) AS Biaya_Kursus
FROM (siswa INNER JOIN absen ON siswa.nis=absen.nis) INNER JOIN program ON siswa.KD_program=program.KD_program;

Nama:tomy
kelas/no: XIS4/37

28 May, 2013
Kevin han's said...

TUGAS KOMPUTER 2
1.
PARAMETERS PAKET_PROGRAM Text ( 255 );
SELECT Siswa.nis, siswa.nama_siswa, program.paket_program, Guru.Nama_Guru, absen.Jam_masuk, absen.Jam_pulang, Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
FROM ((siswa INNER JOIN guru ON siswa.KD_Guru=guru.KD_guru) INNER JOIN program ON siswa.KD_program=program.KD_program) INNER JOIN absen ON siswa.NIS=absen.NIS
WHERE ((PROGRAM.PAKET_PROGRAM)=[PAKET_PROGRAM]);

2.
SELECT absen.NIS, siswa.Nama_Siswa, Siswa.tanggal_lahir, Year(now())-Year(siswa.Tanggal_lahir) AS Umur, Program.Paket_Program, iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) AS Biaya_Kursus
FROM (siswa INNER JOIN absen ON siswa.nis=absen.nis) INNER JOIN program ON siswa.KD_program=program.KD_program;

NAMA:KEVIN HAN'S
KELAS/NO:XIS4/19

28 May, 2013
rika anjani chandra said...

TUGAS 2
1.
PARAMETERS PAKET_PROGRAM Text ( 255 );
SELECT Siswa.nis, siswa.nama_siswa, program.paket_program, Guru.Nama_Guru, absen.Jam_masuk, absen.Jam_pulang, Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
FROM ((siswa INNER JOIN guru ON siswa.KD_Guru=guru.KD_guru) INNER JOIN program ON siswa.KD_program=program.KD_program) INNER JOIN absen ON siswa.NIS=absen.NIS
WHERE ((PROGRAM.PAKET_PROGRAM)=[PAKET_PROGRAM]);

2.
SELECT absen.NIS, siswa.Nama_Siswa, Siswa.tanggal_lahir, Year(now())-Year(siswa.Tanggal_lahir) AS Umur, Program.Paket_Program, iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) AS Biaya_Kursus
FROM (siswa INNER JOIN absen ON siswa.nis=absen.nis) INNER JOIN program ON siswa.KD_program=program.KD_program;

NAMA:rika anjani chandra
KELAS/NO:XIS4/32

28 May, 2013
Reynaldo A L said...

Tugas Komputer 2
1.
PARAMETERS PAKET_PROGRAM Text ( 255 );
SELECT Siswa.nis, siswa.nama_siswa, program.paket_program, Guru.Nama_Guru, absen.Jam_masuk, absen.Jam_pulang, Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
FROM ((siswa INNER JOIN guru ON siswa.KD_Guru=guru.KD_guru) INNER JOIN program ON siswa.KD_program=program.KD_program) INNER JOIN absen ON siswa.NIS=absen.NIS
WHERE ((PROGRAM.PAKET_PROGRAM)=[PAKET_PROGRAM]);

2.
SELECT absen.NIS, siswa.Nama_Siswa, Siswa.tanggal_lahir, Year(now())-Year(siswa.Tanggal_lahir) AS Umur, Program.Paket_Program, iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) AS Biaya_Kursus
FROM (siswa INNER JOIN absen ON siswa.nis=absen.nis) INNER JOIN program ON siswa.KD_program=program.KD_program;

Nama:Reynaldo A.L
Kelas/no:XIS4/31

28 May, 2013
dirga prawira / XIS4 / 9 said...

1. PARAMETERS PAKET_PROGRAM Text ;
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([JAM_PULANG]-[JAM_MASUK])*24 AS LAMA_JAM_BELAJAR


FROM ((SISWA INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS)
INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU)
INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];

2. SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,
IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop",300000,200000)))
AS BIAYA_KURSUS

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

28 May, 2013
michael fu / XIS4 / 24 said...

1. PARAMETERS PAKET_PROGRAM Text ;
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([JAM_PULANG]-[JAM_MASUK])*24 AS LAMA_JAM_BELAJAR


FROM ((SISWA INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS)
INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU)
INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];

2. SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,
IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop",300000,200000)))
AS BIAYA_KURSUS

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

28 May, 2013
dedek chandra lee / XIS4 / 7 said...

1. PARAMETERS PAKET_PROGRAM Text ;
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([JAM_PULANG]-[JAM_MASUK])*24 AS LAMA_JAM_BELAJAR


FROM ((SISWA INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS)
INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU)
INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];

2. SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,
IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop",300000,200000)))
AS BIAYA_KURSUS

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

28 May, 2013
gregorius reynaldo /16 said...

1. PARAMETERS PAKET_PROGRAM Text ;
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([JAM_PULANG]-[JAM_MASUK])*24 AS LAMA_JAM_BELAJAR


FROM ((SISWA INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS)
INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU)
INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];

2. SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,
IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop",300000,200000)))
AS BIAYA_KURSUS

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

28 May, 2013
thessa pratama / 35 said...

1. PARAMETERS PAKET_PROGRAM Text ;
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([JAM_PULANG]-[JAM_MASUK])*24 AS LAMA_JAM_BELAJAR


FROM ((SISWA INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS)
INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU)
INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];

2. SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,
IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop",300000,200000)))
AS BIAYA_KURSUS

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

28 May, 2013
michael fu / 24 / XIS4 said...

1. PARAMETERS PAKET_PROGRAM Text ;
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([JAM_PULANG]-[JAM_MASUK])*24 AS LAMA_JAM_BELAJAR


FROM ((SISWA INNER JOIN ABSEN ON SISWA.NIS=ABSEN.NIS)
INNER JOIN GURU ON SISWA.KD_GURU=GURU.KD_GURU)
INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM
WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM];

2. SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,
IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop",300000,200000)))
AS BIAYA_KURSUS

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

28 May, 2013
Cicillia Novita said...

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

Query 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 :Cicillia Novita
Kelas : XI IPS 4 / 5

28 May, 2013
Fransiska Aventha Destriana said...

NAMA: Fransiska Aventha
Kelas:XIS4
Absen: 14
SQL No.1

PARAMETERS PAKET_PROGRAM Text ( 20 );
SELECT SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR


FROM (PROGRAM INNER JOIN (GURU INNER JOIN SISWA ON GURU.KD_GURU = SISWA.KD_GURU) ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM) INNER JOIN ABSEN ON SISWA.NIS = ABSEN.NIS

WHERE PROGRAM.PAKET_PROGRAM=[PAKET_PROGRAM]
;

SQL No.2

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


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

28 May, 2013
Kevin Johan XI S4 said...

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

29 May, 2013
MEILLA NOVIA IRAWAN XIS4-23 said...

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

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

29 May, 2013
Aster Pranita Juniar XI S4 said...

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

29 May, 2013
Marco Chandra 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 guru on siswa.kd_guru=guru.kd_guru) inner join absen on siswa.nis=absen.nis
;

2. SELECT
SISWA.nis,
SISWA.NAMA_SISWA,
siswa.tanggal_lahir,
Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS Umur,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-WINDOWS",75000,
IIf(PROGRAM.PAKET_PROGRAM="MS-OFFICE",150000,
IIf(PROGRAM.PAKET_PROGRAM="PHOTOSHOP",300000,200000))) AS BIAYA_KURSUS
FROM PROGRAM INNER JOIN (GURU INNER JOIN SISWA ON GURU.KD_GURU = SISWA.KD_GURU) ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;

29 May, 2013
andri febriyanto 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, Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
FROM ((siswa INNER JOIN guru ON siswa.KD_Guru=guru.KD_guru) INNER JOIN program ON siswa.KD_program=program.KD_program) INNER JOIN absen ON siswa.NIS=absen.NIS
WHERE ((PROGRAM.PAKET_PROGRAM)=[PAKET_PROGRAM]);

2.SELECT absen.NIS, siswa.Nama_Siswa, Siswa.tanggal_lahir, Year(now())-Year(siswa.Tanggal_lahir) AS Umur, Program.Paket_Program, iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) AS Biaya_Kursus
FROM (siswa INNER JOIN absen ON siswa.nis=absen.nis) INNER JOIN program ON siswa.KD_program=program.KD_program;

nama:Andri Febriyanto
kelas : XI IPS 4
Absen : 02

30 May, 2013
JUWANDI.S 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, Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
FROM ((siswa INNER JOIN guru ON siswa.KD_Guru=guru.KD_guru) INNER JOIN program ON siswa.KD_program=program.KD_program) INNER JOIN absen ON siswa.NIS=absen.NIS
WHERE ((PROGRAM.PAKET_PROGRAM)=[PAKET_PROGRAM]);

2. SELECT absen.NIS, siswa.Nama_Siswa, siswa.tanggal_lahir, Year(Now())-Year(siswa.Tanggal_lahir) AS Umur, program.Paket_Program, IIf(Program.paket_program="MS-Windows",75000,IIf(Program.Paket_Program="MS-Office",150000,IIf(Program.Paket_Program="Photoshop",300000,200000))) AS Biaya_Kursus
FROM (siswa INNER JOIN absen ON siswa.nis = absen.nis) INNER JOIN program ON siswa.KD_program = program.KD_program;

juwandi S
18/XIS4

30 May, 2013
Edbert Wijaya said...

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

30 May, 2013
Aloysius Krisna Prabowo said...

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

30 May, 2013
Virginia YP said...

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

2.SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, YEAR(NOW())-YEAR([SISWA.TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM, IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,IIf(PROGRAM.PAKET_PROGRAM="PhotoShop",300000,200000))) AS BIAYA_KURHUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;



Virginia Yovita Putri/39/XIs4

30 May, 2013
Davin Kurnia P said...

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

2.SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.TANGGAL_LAHIR, YEAR(NOW())-YEAR([SISWA.TANGGAL_LAHIR]) AS UMUR, PROGRAM.PAKET_PROGRAM, IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,IIf(PROGRAM.PAKET_PROGRAM="PhotoShop",300000,200000))) AS BIAYA_KURHUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;


Devin Kurnia Persadha
8
xis4

30 May, 2013
P.Arindra said...

SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;

SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

P.Arindra XI-S4/27

30 May, 2013
Anonymous said...

1.PARAMETERS program.paket_program Text ( 255 );
SELECT siswa.nis, siswa.nama_siswa, program.paket_program, guru.nama_guru, absen.jam_masuk, absen.jam_pulang, ([ABSEN.JAM_PULANG]-[ABSEN.JAM_MASUK])*24 AS LAMA_JAM_BELAJAR
FROM ((GURU INNER JOIN SISWA ON GURU.KD_GURU=SISWA.KD_GURU) INNER JOIN PROGRAM ON SISWA.KD_PROGRAM=PROGRAM.KD_PROGRAM) INNER JOIN ABSEN ON absen.nis=siswa.nis
WHERE program.paket_program=[paket_program];

2.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:Tjhin Giok Ke
Kelas : X1S4
Nomor Absen:36

30 May, 2013
Vivi said...

Vivi Verika(40)

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

30 May, 2013
Ulfa R. said...

SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

Ulfa xi-s4 38

30 May, 2013
Wendi said...

1.
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2.
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program; Wendi K S

30 May, 2013
Reandy HS said...

1.
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2.
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;
Reandy H.S.(28)

30 May, 2013
Yudith said...

1.
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2.
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

30 May, 2013
Claudia Alvisha / 06 said...

@tiksmaxavega:


Claudia Alvisha
6
XI IPS 4




1. PARAMETERS PAKET_PROGRAM TEXT;
SELECT SISWA.NIS, SISWA.NAMA_SISWA, SISWA.PAKET_PROGRAM, GURU.NAMA_GURU, ABSEN.JAM_MASUK, ABSEN.JAM_PULANG, ([JAM_PULANG]-[JAM_MASUK])* 24 AS LAMA_JAM_MASUK
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,
IF (PROGRAM.PROGRAM_PAKET="MS-Windows", 75000, IF(PROGRAM.PROGRAM_PAKET="MS-Office", 150000, IF(PROGRAM.PROGRAM_PAKET="Photoshop", 300000, IF(PROGRAM.PROGRAM_PAKET="Web Design", 200000)))) AS BIAYA_KHUSUS

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

30 May, 2013
Wirawan M said...

No1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
No2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

Wirawan M XI-S4/42

31 May, 2013
Emi said...

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;
Emmylien K

31 May, 2013
Emi said...

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;
Emmylien K

31 May, 2013
MK said...

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;
Michael K.

31 May, 2013
Enestasia A. said...

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;
Enestasia Angelika XI-S4 12

31 May, 2013
Annisa (3) said...

1
SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;
2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;
Annisa Nitami

31 May, 2013
YOHANEZ PATRIO DANANTA / XI IPS 4 / 44 said...

SELECT
Siswa.nis,
siswa.nama_siswa,
program.paket_program,
Guru.Nama_Guru,
absen.Jam_masuk,
absen.Jam_pulang,
Hour(absen.Jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
from ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;

2
SELECT
absen.NIS,
siswa.Nama_Siswa,
Siswa.tanggal_lahir,
Year(now())-Year(siswa.Tanggal_lahir) as Umur,
Program.Paket_Program,
iif(Program.paket_program = "MS-Windows" , 75000, iif(Program.Paket_Program = "MS-Office" , 150000, iif(Program.Paket_Program = "Photoshop", 300000, 200000))) as Biaya_Kursus
from (siswa inner join absen on siswa.nis=absen.nis) inner join program on siswa.KD_program:program.KD_program;

31 May, 2013
tiksmaxavega said...

Siswa yang telah mengumpulkan tugas (sd. tgl. 31 Mei 2013):
1. ALOYSIUS KRISNA PRABOWO
2. ANDRI FEBRIYANTO
3. ANNISA NITAMI
4. ASTER PRANITA JUNIAR
5. CICILIA NOVITA
6. CLAUDIA ALVISHA
7. DEDEK CHANDRA LIE
8. DEVIN KURNIA PERSADHA
9. DIRGA PRAWIRA
10. EDBERT WIJAYA
11. EMMYLIEN KUSNO
12. ENESTASIA A
13. FABLIUS FERNANDO
14. FRANSISKA AVENTHA DESTRIANA
15. GREGORIUS REYNALDO
16. JUWANDI S
17. KEVIN HAN'S
18. KEVIN JOHAN
19. MARCO CHANDRA
20. MEILLA NOVIA IRAWAN
21. MICHAEL FU
22. MICHAEL KURNIAWAN
23. P. ARINDRA
24. REANDY HS
25. REDY DJUNIZAR
26. REYNALDO AL.
27. RIKA ANJANI CHANDRA
28. SHELLA JUEL
29. THESSA PRATAMA GURNITA
30. THJIN GIOK KE
31. TOMY
32. ULFA RAMADHONA
33. VIRGINIA YOVITA PUTRI
34. VIVI FERIKA
35. WENDY KARTA SAPUTRA
36. WIRAWAN MULYA
37. YUDHIT KRISTA PRADIPTA
38. YOHANES PATRIO DANANTA

31 May, 2013
tiksmaxavega said...

Siswa yang belum mengumpulkan tugas hingga tanggal 31 Mei 2013:
1. FRENDY
2. HENRY YAHYA CHRISTIAN
3. LOUIS RAINALDO LAKSANA S.
4. MONIKA UTAMI WIBOWO
5. REVERDY WINADI
6. SHERLY MARGARETA LESTARI

Silahkan segera mengerjakan dan mengumpulkan tugas di atas, diberi waktu hingga tanggal 02 Juni 2013.

31 May, 2013
Anonymous said...

1.Rumus
SELECT
SISWA.NIS,
SISWA.NAMA_SISWA,
PROGRAM.PAKET_PROGRAM,
GURU.NAMA_GURU,
ABSEN.JAM_MASUK,
ABSEN.JAM_PULANG,
(ABSEN.JAM_PULANG)-(ABSEN_JAM_MASUK)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 ABSEN.NIS=SISWA.NIS

2.Rumus SQL:
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

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