Browsing "Tugas Kuliah"
Oct 23, 2012 - Tugas Kuliah    No Comments

[TUGAS] Pemrograman Basis Data 2 (Practice 1)

Dalam pertemuan kali ini saya sharing tentang soal Sertifikasi Oracle.

Nim : 10390100057
Nama : Rizal Miftahus Salmi
Email : rizallaros@facebook.com
Tugas Mata Kuliah : PDB 2
Materi Konsultasi : Practice 1
Tugas Minggu ke : -
Nama Dosen : Titik Lusiani, M.Kom.,OCA
Blog Dosen : http://blog.stikom.edu/lusiani

Silahkan download soal PDB2 – Practice 1.

Disini saya juga menyertakan jawaban Jawaban PDB 2 – Practice 1.

Mar 18, 2012 - Tugas Kuliah    No Comments

[LATIHAN] Pemrograman Basis Data 1 (Sabtu, 17 Maret 2012)

============================
Mata Kuliah : Pemrograman Basis Data 1
NIM : 10.39010.0057
Nama : Rizal Miftahus Salmi
Link Latihan : http://blog.stikom.edu/nunuk/2012/03/17/latihan/
============================

Sesuai dengan latihan dari blog Ibu Nunuk, saya posting jawaban saya.

1.
SELECT no_order, count(*) jumlah_order
FROM order
GROUP BY no_order
HAVING count(*) > 100;

2.
SELECT kode_mk, max(nilai)-min(nilai)
FROM transkrip
GROUP BY kode_mk;

3.
SELECT department_id, nama
FROM employees
WHERE department_id =
(SELECT department_id
FROM employees
WHERE nama = ‘ida’);

4.
SELECT a.nama
FROM master_mhs a, histori_mhs b
WHERE a.nim = b.nim and b.kode_mk = ’434′ and ((0.3*n_uts)+(0.3*n_uas)+(0.4*n_tugas)) > AVG((0.3*n_uts)+(0.3*n_uas)+(0.4*n_tugas));

Terimakasih. (/^_^)/

Mar 6, 2012 - Tugas Kuliah    No Comments

[TUGAS] Pemrograman Basis Data 1 (Selasa, 6 Maret 2012)

============================
Mata Kuliah : Pemrograman Basis Data 1
NIM : 10.39010.0057
Nama : Rizal Miftahus Salmi
Link Tugas : http://blog.stikom.edu/nunuk/2012/03/06/tugas-individu/
============================

Sesuai dengan tugas dari blog Ibu Nunuk, saya posting jawaban saya.

1.
select nim, nama, sex
from master_mhs
where (nim like ’00%’ or nim like ’01%’) and nim like ‘%39010%’ and tgl_lahir like ’01-May%’ and sts_marital=’M';

2.
select count(*) as “Jumlah Mahasiswa”
from master_mhs
where (nim like ’01%’ or nim like ’02%’) and (nim like ‘%39010%’ or nim like ‘%41010%’);

3.
select a.nim, b.nama
from master_mhs b, histori_mhs a
where a.nim = b.nim and nim like ’02%’
group by a.nim
order by a.nim;