disini
2.setelah selesai membuat tabel isi tabel dengan memasukan perintah berikut:
a. untuk mahasiswa
insert into Mahasiswa(Nim,Nama,alamat,agama)values('001','budi','semarang','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('002','ragil','kendal','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('003','udi','semarang','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('004','rani','singorojo','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('005','wawan','semarang','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('006','hendra','malang','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('007','nanik','semarang','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('008','herlina','semarang','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('009','yanto','semarang','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('010','panji','malang','islam');
b.untuk dosen
insert into Dosen(Nip,Nama,alamat,agama)values('001','santo','semarang','islam');
insert into Dosen(Nip,Nama,alamat,agama)values('002','santo1','malang','islam');
insert into Dosen(Nip,Nama,alamat,agama)values('003','santo2','kendal','islam');
insert into Dosen(Nip,Nama,alamat,agama)values('004','santo3','jakarta','islam');
insert into Dosen(Nip,Nama,alamat,agama)values('005','santo4','klaten','islam');
insert into Dosen(Nip,Nama,alamat,agama)values('005','santo5','jogja','islam');
insert into Dosen(Nip,Nama,alamat,agama)values('006','santo6','surabaya','islam');
insert into Dosen(Nip,Nama,alamat,agama)values('007','santo7','maluku','islam');
c.untuk mata kuliah
insert into MataKuliah(kode,Nama,sks) values('ABA','SistemBasisData1','3');
insert into MataKuliah(kode,Nama,sks) values('ABB','SistemBasisData2','4');
insert into MataKuliah(kode,Nama,sks) values('ABC','SistemBasisData3','2');
insert into MataKuliah(kode,Nama,sks) values('BAA','SistemBasisData4','3');
insert into MataKuliah(kode,Nama,sks) values('AAA','SistemBasisData5','5');
insert into MataKuliah(kode,Nama,sks) values('BBA','SistemBasisData6','3');
insert into MataKuliah(kode,Nama,sks) values('BBA','SistemBasisData7','2');
insert into MataKuliah(kode,Nama,sks) values('AAA','SistemBasisData8','1');
insert into MataKuliah(kode,Nama,sks) values('AAA','SistemBasisData9','4');
insert into MataKuliah(kode,Nama,sks) values('CCC','SistemBasisData10','2');
d.untuk krs
insert into krs(nim,nip,kode,uts,uas) values('001','aaa’,'x001',70,80);
insert into krs(nim,nip,kode,uts,uas) values('002','aaa’,'x001','75,85);
insert into krs(nim,nip,kode,uts,uas) values('003','aaa’,'x001','80,80);
insert into krs(nim,nip,kode,uts,uas) values('004','aaa’,'x001','90,85);
insert into krs(nim,nip,kode,uts,uas) values('005','aaa’,'x001','80,86);
insert into krs(nim,nip,kode,uts,uas) valueS('006','aaa’,'x001','60,75);
insert into krs(nim,nip,kode,uts,uas) values('007','aaa’,'x001','70,80);
insert into krs(nim,nip,kode,uts,uas) values('001','bbb’,'x002','70,80);
insert into krs(nim,nip,kode,uts,uas) values('002','bbb’,'x002','75,90);
insert into krs(nim,nip,kode,uts,uas) values('003','bbb’,'x002','60,70);
insert into krs(nim,nip,kode,uts,uas) values('004','bbb’,'x002','75,85);
insert into krs(nim,nip,kode,uts,uas) values('005','bbb’,'x002','90,80);
insert into krs(nim,nip,kode,uts,uas) values('006','bbb’,'x002','70,85);
insert into krs(nim,nip,kode,uts,uas) values('007','bbb’,'x002','60,80);
3.jangan lupa,setiap perintah di excute terlebih dahulu
4.untuk mnampilkan nip, nama dan alamat dosen yang beralamat di Surabaya
ketik perintah:
select nip,nama,alamat from dosen where alamat='surabaya'; tekan excute
5.Menampilkan kode, nama dan sks mata kuliah yang sks nya = 4ketik : select kode,nama,sks from matakuliah where sks=4;
6. Menampilkan nim mahasiswa yang mengambil kode mata kuliah ='aaa7.Tambah kolom/field "jenis_kelamin" di tabel mahasiswaketik; ALTER TABLE mahasiswa ADD jeniskelamin varchar(150);\
selesai,selamat mencoba,...