�ݺ�ߣ

APLIKASI LATIHAN SOAL ONLINE

Nanda Patria Adikara 613102059
Dewa Nyoman Adi Santosa 613104061
Mita Pitria Heni 613104072
Muhammad Karimata 613110078
Muhammad Agung Laksono 613111044

APLIKASI LATIHAN SOAL ONLINE

 Aplikasi yang di dalamnya terdapat soal soal latihan
yang dapat di gunakan untuk melatih kemampuan
kita dalam belajar dan sebagai penunjang /
pelengkap kesiapan kita dalam menghadapi UTS /
UAS.
 Sasaran : Mahasiswa

DDL
DROP TABLE fakultas CASCADE CONSTRAINT;
CREATE TABLE fakultas (
id_fakultas char(5)constraint pk_fakultas primary key,
nama_fakultas varchar(20) NOT NULL
);

DROP TABLE jurusan CASCADE CONSTRAINT;
CREATE TABLE jurusan (
id_jurusan char(5) constraint pk_jurusan primary key,
nama_jurusan varchar(20) NOT NULL,
id_fakultas char(5) NOT NULL,
constraint fk_fakultas foreign key(id_fakultas) references fakultas on delete cascade
);

DROP TABLE matakuliah CASCADE CONSTRAINT;
CREATE TABLE matakuliah (
id_makul char(5) constraint pk_matakuliah primary key,
nama_makul varchar(20) NOT NULL,
jumlahsks char(1) NOT NULL
);

DROP TABLE punyamakul CASCADE CONSTRAINT;
CREATE TABLE punyamakul (
id_makul char(5) NOT NULL,
id_jurusan char(5) NOT NULL,
constraint fk_makul foreign key(id_makul) references matakuliah on delete cascade,
constraint fk_jurusan foreign key(id_jurusan) references jurusan on delete cascade
);

DROP TABLE soal CASCADE CONSTRAINT;
CREATE TABLE soal (
id_soal char(5) constraint pk_soal primary key,
tahun char(4) NOT NULL,
tipe_soal varchar(10) NOT NULL,
waktu_pengerjaan char(1),
id_makul char(5) NOT NULL,
id_jurusan char(5) NOT NULL,
constraint fk_makul foreign key(id_makul) references matakuliah on delete cascade,
constraint fk_jurusan foreign key(id_jurusan) references jurusan on delete cascade
);

DROP TABLE isisoal CASCADE CONSTRAINT;
CREATE TABLE isisoal (
id_isisoal char(5) constraint pk_isisoal primary key,
uraiansoal long NOT NULL,
option_A varchar(20) NOT NULL,
option_B varchar(20) NOT NULL,
option_C varchar(20) NOT NULL,
option_D varchar(20) NOT NULL,
jawaban char(1) NOT NULL,
id_soal char(5) NOT NULL,
constraint fk_soal foreign key(id_soal) references soal on delete cascade
);

DML
Fungsi insert :
insert into fakultas value ('F-001-FF','Fakultas Informatika');
insert into fakultas value ('F-002-FK','Fakultas Elektro');
insert into fakultas value ('F-003-FT','Fakultas Telekomunikasi');
insert into fakultas value ('F-004-FI','Fakultas Industri');

insert into jurusan value('FF-001-IF','Teknik Informatika',’F-001’);
insert into jurusan value('FK-002-TE','Teknik Elektro',’F-002’);
insert into jurusan value('FI-004-TI','Teknik Industri',’F-004’);
insert into jurusan value('FT-003-TT','Teknik Telekomunikasi',’F-003’);

insert into matakuliah value('F-KAL-01','Kalkulus','3');
insert into matakuliah value('F-BSD-02','Basis Data','3');
insert into matakuliah value('F-BHS-01','Bahasa Indonesia','2');
insert into matakuliah value('P-BSD-01','Praktikum BasDat','2');
insert into matakuliah value('F-NET','Network Programming','3')

DML
insert into punyamakul value('F-KAL-01','FK-002-TE');
insert into punyamakul value('F-BSD-02','FF-001-IF');
insert into punyamakul value('F-BHS-01','FT-003-TT');
insert into punyamakul value('F-NET','FF-001-IF');

insert into soal value('s001','2004','UTS','60','F-NET',’FF-001-IF’);

insert into isisoal(‘i001’,’ Setiap inerface yang berisi method untuk RMI harus …’,’ Meng-extends
UnicastRemoteObject’,’ Meng-implements UnicastRemoteObject’,’ Meng-implements Remote,’
Meng-implements Remote’,’ Meng-extends Remote’,’ d’,’ s001’);

insert into isisoal(‘i002’,’ fitur pada Java yang membantu membatasi pihak yang boleh mengakses
server RMI yaitu’,’ Jproxy’,’ JAAS’,’ Jsecurity’,’ Jauth’,’ b’,’ s001’);

insert into isisoal(‘i003’,’ Protokol TCP/IP yang digunakan CORBA untuk komunikasi clien-server
yaitu …’,’ IIOP’,’ IDL’,’ ORB’,’ POA’,’ a’,’s001’);

insert into isisoal(‘i004’,’ Salah satu service di antara CORBA Object Services
’,’ Lookup Service’,’ Security Service’,’ Rebind Service’,’ Garbage Collecting Service
’,’ b’,’s001’);

DML
Fungsi Update

Update matakuliah
Set jumlahsks=’3’
Where id_makul=’F-BHS-01’;

Fungsi Select

SELECT * FROM soal s WHERE s.id_makul = ( SELECT id_makul
FROM matakuliah m WHERE m.nama_makul LIKE "Matdis" ) and
s. id_jurusan =( SELECT id_jurusan FROM jurusan WHERE
jurusan.nama_jurusan LIKE 'Informatika' );

SELECT * FROM `isisoal` where id_soal = 'S001';

RANCANGAN USER INTERFACE &
DML
PADA ANDROID & WEB

SEARCH

SELECT tahun from soal where id_jurusan =
SELECT nama_makul from matakuliah
(select id_jurusan from jurusan where
m, punyamakul p where m.id_makul =
select nama_jurusan from jurusan where
nama_jurusan like "D3 INFORMATIKA") and
id_fakultas = (select id_fakultas(select
p.id_makul and p.id_jurusan = from
select nama_fakultas from fakultas ;
id_makul = (select id_makul from matakuliah
id_jurusan from jurusan where
fakultas where nama_fakultas like "
where nama_makul like “NETWORK
INFORMATIKAlike " D3 INFORMATIKA ");
nama_jurusan ");
PROGRAMING");

DETAIL

SELECT tipe_soal from soal where
id_jurusan = (select id_jurusan from jurusan
where nama_jurusan like "D3
INFORMATIKA") and id_makul = (select
id_makul from matakuliah where
nama_makul like “NETWORK
PROGRAMING");

SOAL
select uraiansoal, option_A, option_B, option_C, option_D from isisoal where
id_soal = (SELECT id_soal from soal where id_jurusan = (select id_jurusan from
jurusan where nama_jurusan like "D3 INFORMATIKA") and id_makul = (select
id_makul from matakuliah where nama_makul like “NETWORK
PROGRAMING");
);

HASIL

select jawaban from isisoal where id_soal =
(SELECT id_soal from soal where id_jurusan =
(select id_jurusan from jurusan where
nama_jurusan like "D3 INFORMATIKA") and
id_makul = (select id_makul from matakuliah
where nama_makul like “NETWORK
PROGRAMING");
);

1. INSERT

 HALAMAN AWAL

 INSERT INTO jurusan
(id_jurusan,nama_jurusan,id_fakultas)
VALUES('$txtidjur','$txtnama','$txtidfak')

2. Update

 Tampilan formulir update

 UPDATE jurusan SET
nama_jurusan='$txtnamajur',id_fakultas='$txtidfak‘ WHERE
id_jurusan='$txtidjur'

 Halaman output ketika di update

3. Delete

 Delete id jurusan J002
DELETE FROM jurusan WHERE id_jurusan='$idhapus'

 Halaman output setelah di delete

�ݺ�ߣ

Aplikasi latihan soal online

More Related Content

Featured (20)

Aplikasi latihan soal online