Catatan Kuliahku

SOURCE CODE :

create database rumkit;
use rumkit;
create table pasien (kode_pasien varchar (5) primary key not null,
nama_pasien varchar (19) not null, jk varchar (5),alamat varchar (20) not null,
kode_dokter varchar (10) not null,kode_penyakit varchar (5) not null,no_resep varchar (5) not null);
insert into pasien value
('P01','ira','P','jl.jeruk','D01','N01','RR1'),
('P02','maya','P','jl.mangga','D03','N02','RR2'),
('P03','hendra','L','jl.durian','D02','N05','RR3'),
('P04','putra','L','jl.nangka','D02','N02','RR4'),
('P05','lanang','L','jl.pisang','D05','N02','RR5');
select*from pasien;


create table dokter (kode_dokter varchar (5) primary key not null,
nama_dokter varchar (10) not null,alamat varchar (10) not null,
spesialisasi varchar (10) not null,tarif_dokter varchar (10) not null,
kode_penyakit varchar (5) not null,kode_pasien varchar (5) not null);
insert into dokter value
('D01','ardi','jl.mawar','jantung','150000','N01','P01'),
('D02','gilang','jl.anggrek','kulit','100000','N02','P02'),
('D03','era','jl.melati','paru-paru','125000','N03','P03'),
('D04','kiki','jl.kenanga','kandungan','200000','N04','P01'),
('D05','gunawan','jl.bougenvile','kelamin','250000','N05','P02');
select*from dokter;


create table penyakit (kode_penyakit varchar (5) primary key not null,
nama_penyakit varchar (20) not null);
insert into penyakit value
('N01','jantung'),
('N02','kulit'),
('N03','paru-paru'),
('N04','kandungan'),
('N05','kelamin'),
('N06','tulang');
select*from penyakit;


create table resep(no_resep varchar (10) primary key not null,
tanggal date  not null,kode_pasien varchar (5)not null,kode_dokter varchar (6) not null,
kode_penyakit varchar (5) not null, nama_obat varchar (10)not null);

describe resep;

insert into resep value
('R1','2012-05-12','P01','D02','N02','anti biotik'),
('R2','2012-06-10','P03','D03','N03','kaplet salut'),
('R3','2012-06-05','P04','D02','N02','anti jamur'),
('R4','2012-06-01','P01','D05','N05','anti biotik'),
('R5','2012-06-20','P02','D01','N01','anti sesak'),
('R6','2012-06-15','P02','D01','N01','anti sesak');
select*from resep;