Tugas 2 "Membuat Tabel Data Pada Query Browser"

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~