CREATE DATABASE DB_AGUNG1
ON
(name=DB_AGUNG1, filename="D:\agung db\DB_AGUNG1.mdf",size=10,
maxsize=100,filegrowth=2)
log on
(name=DB_AGUNG1_log, filename="D:\agung db\DB_AGUNG1.ldf",size=4,
maxsize=100,filegrowth=2)


CREATE TABLE pasien
(
kd_pasien char(5) primary key not null,
nama_pasien varchar(50) not null,
alamat varchar(50)not null
)
select * from pasien


CREATE TABLE obat
(
kd_obat char(10) primary key not null,
nama_obat varchar(50) not null,
satuan varchar(10) not null,
harga varchar(30) not null
)
select * from obat


CREATE TABLE ditail_obat
(
id_obat char(10) primary key not null,
kd_obat char(5) not null,
jumlah int not null,
harga varchar(30) not null
)

CREATE TABLE ruang
(
kd_ruang char(10) primary key not null,
nama_ruang varchar(20) not null,
harga_ruang float not null
)
CREATE TABLE dokter
(
id_dokter char(10) primary key not null,
nama_dokter varchar(20) not null,
biaya_dokter float not null
)

CREATE TABLE petugas
(
kd_petugas char(10) primary key not null,
nama_petugas varchar(20) not null
)

CREATE TABLE rawat_inap
(kd_rawat_inap char(10) primary key not null,
tgl_masuk datetime not null,
kd_pasien char(5) foreign key references pasien(kd_pasien)on delete cascade on update cascade,
kd_ruang char(10)foreign key references ruang(kd_ruang)on delete cascade on update cascade,
kd_petugas char(10)foreign key references petugas(kd_petugas)on delete cascade on update cascade
)



CREATE TABLE transaksi_obat
(id_transaksi_obat char(10) primary key not null,
tanggal datetime not null,
kd_pasien char(5) not null
)

CREATE TABLE kunjungan_dokter
(id_kunjungan char(10) primary key not null,
kd_pasien char(5) foreign key references pasien(kd_pasien)on delete cascade on update cascade,
kd_ruang char(10)foreign key references ruang(kd_ruang)on delete cascade on update cascade,
id_doker char(10)foreign key references dokter(id_dokter)on delete cascade on update cascade,
tanggal_kunjungan datetime not null,
hasil_kujungan varchar (50) not null
)

CREATE TABLE pembayaran
(id_pembayaran char(10) primary key not null,
tgl_pembayaran datetime not null,
kd_pasien char(5) foreign key references pasien(kd_pasien)on delete cascade on update cascade,
lama_inap smalldatetime not null,
biaya_kamar float not null,
biaya_kunjungan_dokter float not null,
biaya_obat float not null
)
select * from pembayaran

)