<\/p>\n\n\n\n
Contoh Database Rumah Sakit dengan MySQL – Pada kesempatan ini saya akan membahas Contoh Database Rumah Sakit Dengan MySQL. MySQL adalah salah satu sistem manajemen basis data relasional (RDBMS) yang sering digunakan untuk mengelola data dalam berbagai bidang, termasuk rumah sakit. Database rumah sakit digunakan untuk menyimpan informasi pasien, dokter, perawat, rawat inap, jadwal dokter, rekam medis, obat, dan resep obat, sehingga manajemen data menjadi lebih efektif dan efisien.<\/p>\n\n\n\n
<\/p>\n\n\n\n
Berikut ini adalah panduan untuk membuat database rumah sakit bisa lewat CMD maupun phpMyAdmin.<\/p>\n\n\n\n
Buat database baru:<\/p>\n\n\n\n
\nCREATE DATABASE RumahSakit;<\/p>\n\n\n\n
USE RumahSakit;<\/p>\n<\/blockquote>\n\n\n\n
Buat tabel pasien:<\/p>\n\n\n\n
\nCREATE TABLE Pasien (<\/p>\n\n\n\n
id INT AUTO_INCREMENT PRIMARY KEY,<\/p>\n\n\n\n
nama VARCHAR(100),<\/p>\n\n\n\n
tanggal_lahir DATE,<\/p>\n\n\n\n
jenis_kelamin ENUM(‘L’, ‘P’),<\/p>\n\n\n\n
alamat TEXT,<\/p>\n\n\n\n
no_telepon VARCHAR(15),<\/p>\n\n\n\n
riwayat_penyakit TEXT<\/p>\n\n\n\n
);<\/p>\n<\/blockquote>\n\n\n\n
Buat tabel dokter:<\/p>\n\n\n\n
\nCREATE TABLE Dokter (<\/p>\n\n\n\n
id INT AUTO_INCREMENT PRIMARY KEY,<\/p>\n\n\n\n
nama VARCHAR(100),<\/p>\n\n\n\n
spesialis VARCHAR(50),<\/p>\n\n\n\n
no_telepon VARCHAR(15)<\/p>\n\n\n\n
);<\/p>\n<\/blockquote>\n\n\n\n
Buat tabel perawat:<\/p>\n\n\n\n
\nCREATE TABLE Perawat (<\/p>\n\n\n\n
id INT AUTO_INCREMENT PRIMARY KEY,<\/p>\n\n\n\n
nama VARCHAR(100),<\/p>\n\n\n\n
no_telepon VARCHAR(15),<\/p>\n\n\n\n
shift ENUM(‘Pagi’, ‘Siang’, ‘Malam’)<\/p>\n\n\n\n
);<\/p>\n<\/blockquote>\n\n\n\n
Buat tabel rawat inap:<\/p>\n\n\n\n
\nCREATE TABLE RawatInap (<\/p>\n\n\n\n
id INT AUTO_INCREMENT PRIMARY KEY,<\/p>\n\n\n\n
pasien_id INT,<\/p>\n\n\n\n
dokter_id INT,<\/p>\n\n\n\n
kamar VARCHAR(10),<\/p>\n\n\n\n
tanggal_masuk DATE,<\/p>\n\n\n\n
tanggal_keluar DATE,<\/p>\n\n\n\n
FOREIGN KEY (pasien_id) REFERENCES Pasien(id),<\/p>\n\n\n\n
FOREIGN KEY (dokter_id) REFERENCES Dokter(id)<\/p>\n\n\n\n
);<\/p>\n<\/blockquote>\n\n\n\n
Buat tabel jadwal dokter:<\/p>\n\n\n\n
\nCREATE TABLE JadwalDokter (<\/p>\n\n\n\n
id INT AUTO_INCREMENT PRIMARY KEY,<\/p>\n\n\n\n
dokter_id INT,<\/p>\n\n\n\n
hari ENUM(‘Senin’, ‘Selasa’, ‘Rabu’, ‘Kamis’, ‘Jumat’, ‘Sabtu’, ‘Minggu’),<\/p>\n\n\n\n
jam_mulai TIME,<\/p>\n\n\n\n
jam_selesai TIME,<\/p>\n\n\n\n
FOREIGN KEY (dokter_id) REFERENCES Dokter(id)<\/p>\n\n\n\n
);<\/p>\n<\/blockquote>\n\n\n\n
Buat tabel rekam medis:<\/p>\n\n\n\n
\nCREATE TABLE RekamMedis (<\/p>\n\n\n\n
id INT AUTO_INCREMENT PRIMARY KEY,<\/p>\n\n\n\n
pasien_id INT,<\/p>\n\n\n\n
dokter_id INT,<\/p>\n\n\n\n
diagnosa TEXT,<\/p>\n\n\n\n
tindakan TEXT,<\/p>\n\n\n\n
tanggal_periksa DATE,<\/p>\n\n\n\n
FOREIGN KEY (pasien_id) REFERENCES Pasien(id),<\/p>\n\n\n\n
FOREIGN KEY (dokter_id) REFERENCES Dokter(id)<\/p>\n\n\n\n
);<\/p>\n<\/blockquote>\n\n\n\n
Buat tabel obat:<\/p>\n\n\n\n
\nCREATE TABLE Obat (<\/p>\n\n\n\n
id INT AUTO_INCREMENT PRIMARY KEY,<\/p>\n\n\n\n
nama VARCHAR(100),<\/p>\n\n\n\n
stok INT,<\/p>\n\n\n\n
harga DECIMAL(10,2)<\/p>\n\n\n\n
);<\/p>\n<\/blockquote>\n\n\n\n
Buat tabel resep obat:<\/p>\n\n\n\n
\nCREATE TABLE ResepObat (<\/p>\n\n\n\n
id INT AUTO_INCREMENT PRIMARY KEY,<\/p>\n\n\n\n
rekam_medis_id INT,<\/p>\n\n\n\n
obat_id INT,<\/p>\n\n\n\n
dosis VARCHAR(50),<\/p>\n\n\n\n
jumlah INT,<\/p>\n\n\n\n
FOREIGN KEY (rekam_medis_id) REFERENCES RekamMedis(id),<\/p>\n\n\n\n
FOREIGN KEY (obat_id) REFERENCES Obat(id)<\/p>\n\n\n\n
);<\/p>\n<\/blockquote>\n\n\n\n
Masukkan data dummy ke semua tabel diatas:<\/p>\n\n\n\n
\n— Data Pasien<\/p>\n\n\n\n
INSERT INTO Pasien (nama, tanggal_lahir, jenis_kelamin, alamat, no_telepon, riwayat_penyakit) VALUES<\/p>\n\n\n\n
(‘Ahmad Saputra’, ‘1985-07-12’, ‘L’, ‘Jakarta’, ‘081234567890’, ‘Diabetes’),<\/p>\n\n\n\n
(‘Siti Aminah’, ‘1990-03-20’, ‘P’, ‘Surabaya’, ‘081987654321’, ‘Hipertensi’);<\/p>\n\n\n\n
— Data Dokter<\/p>\n\n\n\n
INSERT INTO Dokter (nama, spesialis, no_telepon) VALUES<\/p>\n\n\n\n
(‘Dr. Budi Santoso’, ‘Kardiologi’, ‘081234123456’),<\/p>\n\n\n\n
(‘Dr. Rina Putri’, ‘Neurologi’, ‘081432654789’);<\/p>\n\n\n\n
— Data Perawat<\/p>\n\n\n\n
INSERT INTO Perawat (nama, no_telepon, shift) VALUES<\/p>\n\n\n\n
(‘Lisa Marlina’, ‘081234000111’, ‘Pagi’),<\/p>\n\n\n\n
(‘Adi Pratama’, ‘081234000222’, ‘Malam’);<\/p>\n\n\n\n
— Data Rawat Inap<\/p>\n\n\n\n
INSERT INTO RawatInap (pasien_id, dokter_id, kamar, tanggal_masuk, tanggal_keluar) VALUES<\/p>\n\n\n\n
(1, 1, ‘A101’, ‘2024-03-10’, ‘2024-03-15’),<\/p>\n\n\n\n
(2, 2, ‘B202’, ‘2024-03-12’, NULL); — Masih dirawat<\/p>\n\n\n\n
— Data Jadwal Dokter<\/p>\n\n\n\n
INSERT INTO JadwalDokter (dokter_id, hari, jam_mulai, jam_selesai) VALUES<\/p>\n\n\n\n
(1, ‘Senin’, ’08:00:00′, ’12:00:00′),<\/p>\n\n\n\n
(2, ‘Rabu’, ’13:00:00′, ’17:00:00′);<\/p>\n\n\n\n
— Data Rekam Medis<\/p>\n\n\n\n
INSERT INTO RekamMedis (pasien_id, dokter_id, diagnosa, tindakan, tanggal_periksa) VALUES<\/p>\n\n\n\n
(1, 1, ‘Penyakit jantung ringan’, ‘Pemberian obat’, ‘2024-03-10’),<\/p>\n\n\n\n
(2, 2, ‘Sakit kepala berat’, ‘CT Scan dilakukan’, ‘2024-03-12’);<\/p>\n\n\n\n
— Data Obat<\/p>\n\n\n\n
INSERT INTO Obat (nama, stok, harga) VALUES<\/p>\n\n\n\n
(‘Aspirin’, 50, 5000),<\/p>\n\n\n\n
(‘Paracetamol’, 100, 2000);<\/p>\n\n\n\n
— Data Resep Obat<\/p>\n\n\n\n
INSERT INTO ResepObat (rekam_medis_id, obat_id, dosis, jumlah) VALUES<\/p>\n\n\n\n
(1, 1, ‘2×1 sehari’, 10),<\/p>\n\n\n\n
(2, 2, ‘3×1 sehari’, 15);<\/p>\n<\/blockquote>\n\n\n\n
<\/p>\n\n\n\n
Kesimpulan<\/h4>\n\n\n\n
Database rumah sakit ini mencakup banyak aspek penting seperti data pasien, dokter, perawat, rekam medis, obat, hingga rawat inap. Dengan struktur database yang kompleks ini, manajemen rumah sakit bisa dilakukan lebih efisien.<\/p>\n","protected":false},"excerpt":{"rendered":"
Contoh Database Rumah Sakit dengan MySQL – Pada kesempatan ini saya akan membahas Contoh Database Rumah Sakit Dengan MySQL. MySQL adalah salah satu sistem manajemen basis data relasional (RDBMS) yang sering digunakan untuk mengelola data dalam berbagai bidang, termasuk rumah sakit. Database rumah sakit digunakan untuk menyimpan informasi pasien, dokter, perawat, rawat inap, jadwal dokter, […]<\/p>\n","protected":false},"author":1,"featured_media":208,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,5],"tags":[15],"class_list":["post-212","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrasi-server","category-news","tag-adm_server"],"_links":{"self":[{"href":"https:\/\/ontohood.my.id\/index.php?rest_route=\/wp\/v2\/posts\/212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ontohood.my.id\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ontohood.my.id\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ontohood.my.id\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ontohood.my.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=212"}],"version-history":[{"count":3,"href":"https:\/\/ontohood.my.id\/index.php?rest_route=\/wp\/v2\/posts\/212\/revisions"}],"predecessor-version":[{"id":217,"href":"https:\/\/ontohood.my.id\/index.php?rest_route=\/wp\/v2\/posts\/212\/revisions\/217"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ontohood.my.id\/index.php?rest_route=\/wp\/v2\/media\/208"}],"wp:attachment":[{"href":"https:\/\/ontohood.my.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ontohood.my.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ontohood.my.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}