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

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

46 comment:

Vanny Julianti said...: Nama : Vanny Julianti
Kelas : XIS2

Jawaban Soal No 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 (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;

Jawaban Soal No 2

SELECT SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,(IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,(IIf(PROGRAM.PAKET_PROGRAM="Photoshop",300000,200000))))) AS BIAYA_KURSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;; 09 May, 2013
Steven William / XI IPS 2 / 34 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. SISWA.TANGGAL_LAHIR,
YEAR(NOW())-YEAR([SISWA.TANGGAL_LAHIR]) AS USIA,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows","Rp 75.000",
IIf(PROGRAM.PAKET_PROGRAM="MS-Office","Rp 150.000",
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop","Rp 300.000","Rp
200.000"))) AS BIAYA

FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM =
PROGRAM.KD_PROGRAM;; 09 May, 2013
Steven William / XI IPS 2 / 34 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 USIA,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows","Rp 75.000",
IIf(PROGRAM.PAKET_PROGRAM="MS-Office","Rp 150.000",
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop","Rp 300.000","Rp
200.000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM =
PROGRAM.KD_PROGRAM;; 09 May, 2013
Ryo Kianto / XI IPS 2 / 29 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 USIA,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows","Rp 75.000",
IIf(PROGRAM.PAKET_PROGRAM="MS-Office","Rp 150.000",
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop","Rp 300.000","Rp
200.000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM =
PROGRAM.KD_PROGRAM;; 09 May, 2013
Shanella W / XI IPS 2 / 31 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 USIA,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows","Rp 75.000",
IIf(PROGRAM.PAKET_PROGRAM="MS-Office","Rp 150.000",
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop","Rp 300.000","Rp
200.000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM =
PROGRAM.KD_PROGRAM;; 09 May, 2013
Ferdinand Gustian / XI IPS 2 / 14 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 USIA,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows","Rp 75.000",
IIf(PROGRAM.PAKET_PROGRAM="MS-Office","Rp 150.000",
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop","Rp 300.000","Rp
200.000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM =
PROGRAM.KD_PROGRAM;; 09 May, 2013
Vinni Tjindar Bumi / XI IPS 2 / 39 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 USIA,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows","Rp 75.000",
IIf(PROGRAM.PAKET_PROGRAM="MS-Office","Rp 150.000",
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop","Rp 300.000","Rp
200.000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM =
PROGRAM.KD_PROGRAM;; 09 May, 2013
Dwiky Darmawan/X1.S2/10 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. SISWA.TANGGAL_LAHIR,
YEAR(NOW())-YEAR([SISWA.TANGGAL_LAHIR]) AS USIA,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows","Rp 75.000",
IIf(PROGRAM.PAKET_PROGRAM="MS-Office","Rp 150.000",
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop","Rp 300.000","Rp
200.000"))) AS BIAYA

FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM =
PROGRAM.KD_PROGRAM;; 09 May, 2013
Sugianto/XIS2/35 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 (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.
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
;; 09 May, 2013
Veronica.N.D/XIS2/38 said...: 09 May, 2013
Vanny Julianti / XIS2 said...: 09 May, 2013
Renaldy Saputra / XI IPS 2 / 25 said...: 09 May, 2013
Lily Marlina / XIS2/ 21 said...: 10 May, 2013
jennifer destera/20 XIS2 said...: 10 May, 2013
tiali / 36 /XIS2 said...: 10 May, 2013
Jenni/XIS2/19 said...: 10 May, 2013
Chinthya/XIS2/07 said...: 10 May, 2013
Maria P/XIS2/23 said...: 10 May, 2013
catherina tri wahyuni / XIS2 / 06 said...: 10 May, 2013
Sonya Carolina/XIS2/32 said...: 10 May, 2013
Evens Dominius/12/IPS2 said...: 10 May, 2013
Andre P.P/02/IPS2 said...: 10 May, 2013
Ardyanto/05/IPS2 said...: 10 May, 2013
Sandy Tirta Adikusuma / XI.S2 / 30 said...: 10 May, 2013
Maria P. / XIS2 / 23 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 USIA,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows","Rp 75.000",
IIf(PROGRAM.PAKET_PROGRAM="MS-Office","Rp 150.000",
IIf(PROGRAM.PAKET_PROGRAM="PhotoShop","Rp 300.000","Rp
200.000"))) AS BIAYA
FROM SISWA INNER JOIN PROGRAM ON SISWA.KD_PROGRAM =
PROGRAM.KD_PROGRAM;; 10 May, 2013
Ade said...: 10 May, 2013
Erwin K./XIS2/11 said...: 10 May, 2013
Ricky Aprilyanto / 26 said...: 10 May, 2013
Rizki Noviyanti / XI.S2/ 27 said...: 10 May, 2013
ANDRE.PP/XIS2/02 said...: 10 May, 2013
Hendrikus Ricky Prayudha said...: 10 May, 2013
Andyka.M/XIs2/04 said...: 10 May, 2013
Wendy.C/XIs2/40 said...: 10 May, 2013
Denny Wijaya/XIs2/9 said...: 10 May, 2013
Anonymous said...: 10 May, 2013
deni cornelius/XIS2/08 said...: 11 May, 2013
Roberto Tansir. XI IPS2/27 said...: 12 May, 2013
Stephen Wijaya said...: 14 May, 2013
Anonymous said...: 14 May, 2013
Hardy Wijaya / XI S2 / 16 said...: 14 May, 2013
FITRIANI BUDIMAN said...: 17 May, 2013
yuliana said...: Jawaban Soal No 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 (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;

Jawaban Soal No 2

SELECT SISWA.NIS,
SISWA.NAMA_SISWA,
SISWA.TANGGAL_LAHIR,
Year(Now())-Year(SISWA.TANGGAL_LAHIR) AS UMUR,
PROGRAM.PAKET_PROGRAM,
IIf(PROGRAM.PAKET_PROGRAM="MS-Windows",75000,(IIf(PROGRAM.PAKET_PROGRAM="MS-Office",150000,(IIf(PROGRAM.PAKET_PROGRAM="Photoshop",300000,200000))))) AS BIAYA_KURSUS
FROM PROGRAM INNER JOIN SISWA ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;; 19 May, 2013
Anonymous said...: 1
SELECT
Siswa.NIS,
siswa.Nama_Siswa,
Program.Paket_Program,
Guru.Nama_Guru,
absen.Jam_Masuk,
absen.Jam_Pulang,
Hour(absen.jam_Pulang)-Hour(absen.Jam_Masuk) AS lama_jam_belajar
FROM ((siswa INNER JOIN guru ON siswa.KD_Guru = guru.KD_guru) INNER JOIN program ON siswa.KD_program = program.KD_program) INNER JOIN absen ON siswa.NIS = absen.NIS;

2
SELECT
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 absen on siswa.nis=absen.nis) inner join program on siswa.KD_program=program.KD_program;

William Saputra; 27 May, 2013
Manahap SP Sihaloho said...: Nama : Manahap SP Sihaloho
No : 22

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

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

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

FROM PROGRAM INNER JOIN SISWA
ON PROGRAM.KD_PROGRAM = SISWA.KD_PROGRAM;; 27 May, 2013
tiksmaxavega said...: Siswa yang telah mengumpulkan tugas (sd. tgl. 31 Mei 2013):
1. ADE
2. ANDHIKA MAKNAWIJAYA
3. ANDRE PP
4. ARDYANTO
5. CATHERINA TRI WAHYUNI
6. CHINTHYA
7. DENI CORNELIUS
8. DENY WIJAYA
9. DWIKY DARMAWAN
10. ERWIN K.
11. EVENS DOMINIUS
12. FERDINAND GUSTIAN
13. FITRIANI BUDIMAN
14. HARDI WIJAYA
15. JENNI
16. JENNIFER DESTERA LUMBANGAOL
17. LILI MARLINA
18. MANAHAP SP SIHALOHO
19. MARIA P
20. OKTAVIANUS ADRIAN
21. RENALDY SAPUTRA
22. RICKY APRILYANTO
23. RIZKY NOVIANTI
24. ROBERTO TANSIR
25. RYO KIANTO
26. SANDI TIRTA ADI KUSUMA
27. SHANELLA WARTONO
28. SONYA CAROLINA
29. STEPHEN WIJAYA
30. STEVEN WILLIAM
31. SUGIANTO
32. TIALI
33. VANNY JULIANTI
34. VERONIKA N.D
35. VINNY TJINDAR BUMI
36. WENDY CHRISTIAN
37. WILLIAM SAPUTRA; 31 May, 2013
tiksmaxavega said...: Siswa yang belum mengumpulkan tugas hingga tanggal 31 Mei 2013:
1. ANDREAN VALENTINUS
2. FANDY FRANSISCO
3. IMELDA
4. PRASETYO AWAL
5. WENNICA
6. YELKY LIANSYAH
7. YULIANA

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

Tugas 2 Kelas XI IPS 2 : Membuat QUERY dengan SQL

Tabel 1 : GURU

Tabel 2 : PROGRAM

Tabel 3 : SISWA

Tabel 4 : ABSEN

SOAL:

46 comment:

Post a Comment

INFORMASI PSB

Download Year Book

Kategori Label

Message Box

DOWNLOAD

Link Banner

Langganan Artikel

Followers

Last Visitors

Jumlah Pembaca !