Perintah SQL berikut :
tabel mahasiswa
insert into Mahasiswa(Nim,Nama,alamat,agama)values('001','buny','semarang','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('002','rudi','demak','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('003','udin','purworejo','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('004','vani','purwodadi','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('005','hesti','semarang','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('006','hendi','jakarta','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('007','ruri','jogja','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('008','heri','semarang','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('009','yani','solo','islam');
insert into Mahasiswa(Nim,Nama,alamat,agama)values('010','parno','surabaya','islam');
tabel dosen
insert into Dosen(Nip,Nama,alamat,agama)values('001','muklas','semarang','islam');
insert into Dosen(Nip,Nama,alamat,agama)values('002','ilyas','surabaya','islam');
insert into Dosen(Nip,Nama,alamat,agama)values('003','yahya','jogja','islam');
insert into Dosen(Nip,Nama,alamat,agama)values('004','santoso','jakarta','islam');
insert into Dosen(Nip,Nama,alamat,agama)values('005','luky','rembang','islam');
insert into Dosen(Nip,Nama,alamat,agama)values('005','farid','solo','islam');
insert into Dosen(Nip,Nama,alamat,agama)values('006','dikky','semarang','islam');
insert into Dosen(Nip,Nama,alamat,agama)values('007','irfan','ambon','islam');
tabel mata kuliah
insert into MataKuliah(kode,Nama,sks) values('AAA','SistemBasisData','2');
insert into MataKuliah(kode,Nama,sks) values('AAB','StrukturBasisData','4');
insert into MataKuliah(kode,Nama,sks) values('ABB','OrganisasiBasisData','2');
insert into MataKuliah(kode,Nama,sks) values('BBB','PemrogramanBasisData','4');
insert into MataKuliah(kode,Nama,sks) values('BAA','StrukturData','4');
insert into MataKuliah(kode,Nama,sks) values('BBA','StrukturKomputer','2');
insert into MataKuliah(kode,Nama,sks) values('BBC','ArsitekturKomputer','2');
insert into MataKuliah(kode,Nama,sks) values('BCC','BahasaPemrograman','2');
insert into MataKuliah(kode,Nama,sks) values('CBC','Algoritma','4');
insert into MataKuliah(kode,Nama,sks) values('CCC','ImplementasiBasisData','4');
tabel krs
insert into krs(nim,nip,kode,uts,uas) values('001','001’,'aaa',80,80);
insert into krs(nim,nip,kode,uts,uas) values('002','002’,'aab','85,75);
insert into krs(nim,nip,kode,uts,uas) values('003','003’,'abb','70,85);
insert into krs(nim,nip,kode,uts,uas) values('004','004’,'baa','80,90);
insert into krs(nim,nip,kode,uts,uas) values('005','005’,'bba','75,95);
insert into krs(nim,nip,kode,uts,uas) values('006','006’,'bbb','75,75);
insert into krs(nim,nip,kode,uts,uas) values('007','007’,'ccc','80,85);
1. Menampilkan nip, nama dan alamat dosen yang beralamat di Surabaya
Caranya Ketik: "select nip,nama,alamat from dosen where alamat='surabaya';"
2. Menampilkan kode, nama dan sks mata kuliah yang sks nya = 4
Caranya Ketik: "select kode,nama,sks from matakuliah where sks=4;"
3. Menampilkan nim mahasiswa yang mengambil kode mata kuliah ='aaa'
Caranya Ketik: "select nim from krs where kode='aaa';"
4. Tambah kolom/field "jenis_kelamin" di tabel mahasiswa
Caranya Ketik: "ALTER TABLE mahasiswa ADD jeniskelamin varchar(150);"
5. Tambah kolom/field "email" di tabel dosen
Caranya Ketik: "ALTER TABLE dosen ADD email varchar(7);"
~Semoga Bermanfaat~
