Tugas UAS Basis Data

mysql> create database rm110A428B;

mysql> use rm110A428B;

mysql> create table tbl_spesialis(kode_spesialis varchar(3) not null primary key

, Spesialis varchar(10) not null);

mysql> insert into tbl_spesialis values('KDG','Kandungan');

mysql> insert into tbl_spesialis values('ANK','Anak');

mysql> insert into tbl_spesialis values('GIG','Gigi');

mysql> insert into tbl_spesialis values('JTG','Jantung');

mysql> select*from tbl_spesialis;

mysql> create table tbl_dokter(Kode_dokter varchar(3) not null primary key, Nama

_dokter varchar(30) not null, Alamat varchar(20) not null, Telepon int(9) not nu

ll, Jam_Jaga varchar(5) not null, kode_spesialis varchar(3) not null);

mysql> insert into tbl_dokter values('D01','Dr.Atid Nurus','Surabaya','081222225

','10:00','ANK');

mysql> insert into tbl_dokter values('D02','Dr.Faikar Abduh','Surabaya','0892223

23','08:00','GIG');

mysql> insert into tbl_dokter values('D03','Dr.Senior Raga','Sidoarjo','08722222

2','15:00','JTG');

mysql> insert into tbl_dokter values('D04','Dr.Eko Prasetyo','Sidoarjo','0832000

20','10:00','ANK');

mysql> insert into tbl_dokter values('D05','Dr.Hadi Irawan','Gresik','081233326'

,'10:00','KDG');

mysql> insert into tbl_dokter values('D06','Dr.Badruzzaman','Surabaya','08139032

7','10:00','ANK');

mysql> insert into tbl_dokter values('D07','Dr.Andi Irawan','Surabaya','08904442

3','08:00','GIG');

mysql> select*from tbl_dokter;

mysql> select Nama_dokter,Jam_Jaga from tbl_dokter where Jam_Jaga like '10:00';

mysql> select*from tbl_dokter where kode_spesialis>all(select Nama_dokter from t

bl_dokter);

mysql> select*from tbl_dokter where kode_spesialis<any(select Nama_dokter from t

bl_dokter);

mysql> select*from tbl_dokter where Nama_dokter like'Dr.%Irawan';

mysql> select Alamat,count(Nama_dokter)from tbl_dokter group by Alamat;

mysql> insert into tbl_dokter values('D08','dr.Nisa','Semarang','089777777

','12:00','KDG');

mysql> update tbl_dokter set Nama_dokter='Dr.Boyke' where Kode_dokter='D08';

mysql> delete from tbl_dokter where kode_dokter like'D08';

mysql> select tbl_dokter.nama_dokter,tbl_spesialis.spesialis from tbl_spesialis,

tbl_dokter where tbl_spesialis.kode_spesialis=tbl_dokter.kode_spesialis;