Latihan Tabel Mahasiswa

1. isi dari tabel mahasiswa




INSERT INTO mahasiswa VALUES ('201381001','alfa');
INSERT INTO mahasiswa VALUES ('201381002','betta','Jl.malioboro No.10','Yogyakarta','23456');
INSERT INTO mahasiswa VALUES ('201381003','charly','Jl.Duri kosambi No.10','Jakarta','12345');
INSERT INTO mahasiswa VALUES ('201381004','delta','Jl.Riua No.10','Bandung','34567');
INSERT INTO mahasiswa VALUES ('201381005','echo');



2. isi dari tabel matakuliah



INSERT INTO matakuliah VALUES ('MK1001','SQL','4','2');
INSERT INTO matakuliah VALUES ('MK1002','sistem basis data','5','2');
INSERT INTO matakuliah VALUES ('MK1003','bahasa pemograman','6','3');
INSERT INTO matakuliah VALUES ('MK1004','perancangan basis data','4','2');
INSERT INTO matakuliah VALUES ('MK1005','perangkat lunak jaringan','3','3');
INSERT INTO matakuliah VALUES ('MK1006','pengantar TI','2','1');


3. isi dari tabel nilai




INSERT INTO nilai VALUES ('201381001','MK1001','90');
INSERT INTO nilai VALUES ('201381002','MK1002','85');
INSERT INTO nilai VALUES ('201381003','MK1003','95');
INSERT INTO nilai VALUES ('201381004','MK1004','75');
INSERT INTO nilai VALUES ('201381005','MK1001','70');
INSERT INTO nilai VALUES ('201381001','MK1002','75');
INSERT INTO nilai VALUES ('201381002','MK1003','50');
INSERT INTO nilai VALUES ('201381003','MK1004','80');
INSERT INTO nilai VALUES ('201381004','MK1005','65');



4. Perintah edit data dalam tabel



UPDATE mahasiswa
SET kota='bali'
WHERE nim='201381005'





UPDATE matakuliah
SET nama_mk='algoritma pemograman'
WHERE nama_mk='bahasa pemograman'





5. proses select dengan melibatkan ke 3 tabel



SELECT mahasiswa.nim,mahasiswa.nama,matakuliah.nama_mk
FROM mahasiswa,matakuliah,nilai
WHERE matakuliah.kode_mk=nilai.kode_mk and
mahasiswa.nim=nilai.nim and
nilai.nilai<=70