M ROBBY F (MI-1B) Tugas Praktikum BasisData

(17/06/2014)

Mapping :

Mahasiswa (Nim char(10), nama varchar(30), jk char(1), tmp_lahir varchar(20), tgl_lahir char(8))

Nilai (Nim char(10), KDMK char(5), uts char(2), uas char(2), nil_akhir char(2), nil_huruf

varchar(2))

MataKuliah (KDMK char(3), namamk varchar(30), sks char(2), jam char(1), jenis varchar(10))

DDL :

- Tabel Mahasiswa

create table mahasiswa(

Nim char(10),

Nama varchar(30),

jk char(1) default 'L',

tmp_lahir varchar(20),

tgl_lahir varchar(10),

primary key (nim));

insert into mahasiswa values (1331140019, 'M Robby F', 'L', 'Malang', '10-10-1995');

insert into mahasiswa values (1331140029, 'Amir', 'L', 'Surabaya', '01-01-1995');

insert into mahasiswa values (1331140039, 'Ana', 'P', 'Malang', '02-02-1995');

insert into mahasiswa values (1331140049, 'Budi', 'L', 'Blitar', '03-03-1994');

insert into mahasiswa values (1331140059, 'Wati', 'P', 'Surabaya', '04-04-1994');

insert into mahasiswa values (1331140069, 'Wina', 'P', 'Madura', '05-05-1995');

insert into mahasiswa values (1331140079, 'Rengga', 'L', 'Lamongan', '06-06-1994');

insert into mahasiswa values (1331140089, 'Ifta', 'P', 'Malang', '07-07-1995');

insert into mahasiswa values (1331140099, 'Rosyid', 'L', 'Bali', '08-08-1994');

insert into mahasiswa values (1331140100, 'Ika', 'P', 'Malang', '09-09-1995');

- Tabel MataKuliah :

create table MataKuliah(

KDMK char(3),

NamaMK varchar(30),

sks char(2),

jam char(1),

jenis varchar(10),

primary key (KDMK));

insert into MataKuliah values (101, 'Agama', '2', '3', 'Teori');

insert into MataKuliah values (102, 'Pendidikan Kewarganegaraan', '2', '3', 'Teori');

insert into MataKuliah values (103, 'Bahasa Inggris Informatika 1', '2', '3', 'Teori');

insert into MataKuliah values (104, 'BasisData', '2', '3', 'Teori');

insert into MataKuliah values (105, 'Praktikum BasisData', '2', '4', 'Praktek');

insert into MataKuliah values (106, 'Interaksi Manusia dan Komputer', '2', '4', 'Teori');

insert into MataKuliah values (107, 'Dasar Multimedia', '2', '4', 'Teori');

insert into MataKuliah values (108, 'Sistem Operasi', '3', '6', 'Praktek');

insert into MataKuliah values (109, 'Pemograman Berbasis Objek', '2', '3', 'Teori');

insert into MataKuliah values (110, 'Praktikum Pemograman Berbasis Objek', '2', '4', 'Praktek');

- Tabel Nilai :

create table Nilai(

Nim char(10),

KDMK char(5),

uts char(2),

uas char(2),

nil_akhir char(2),

nil_huruf varchar(2),

primary key (Nim, KDMK),

foreign key (Nim) references Mahasiswa (Nim),

foreign key (KDMK) references MataKuliah (KDMK));

insert into Nilai values (1331140019,101,75,80,78,’B’);

insert into Nilai values (1331140019,102,70,80,75,'B');

insert into Nilai values (1331140019,103,90,85,88,’B+’);

insert into Nilai values (1331140019,104,75,75,75,’B’);

insert into Nilai values (1331140019,105,80,80,80,'B+');

insert into Nilai values (1331140019,106,90,70,80,'B+');

insert into Nilai values (1331140019,107,95,90,92,'A');

insert into Nilai values (1331140019,108,80,90,85,'B+');

insert into Nilai values (1331140019,109,80,80,80,'B+');

insert into Nilai values (1331140019,110,75,85,80,'B+');

Table Mahasiswa

Table MataKuliah

Table Nilai

Insert Data Nilai

Update data Nilai

Delete data uts

Delete semua table Nilai