i
KATA PENGANTAR
Segala sembah dan puji syukur penulis panjatkan kehadirat Allah SWT atas segala rahmat dan hidayah-Nya, sehingga penulis dapat menyelesaikan Tugas Akhir ini. Tugas Akhir ini disusun sebagai salah satu syarat untuk memperoleh gelar Ahli Madya (A.Md) pada progam studi D3 Manajemen Informatika, Jurusan Matematika, Fakultas Matematika dan Ilmu Pengetahuan Alam.
Dalam Penulisan Tugas Akhir ini penulis banyak mendapatkan bimbingan, bantuan, pengarahan dari berbagai pihak yang tidak ternilai harganya. Penulis mengucapkan banyak terima kasih kepada : 1. Dian Kurniasari, M.Sc, selaku pembimbing I yang turut memberikan saran, ide, dan meluangkan waktu dalam penyusunan Tugas Akhir ini. 2. Wamiliana, Ph.D , selaku pembimbing II yang telah memberikan bimbingan dan arahan dalam penyusunan tugas akhir ini. 3. Drs. Tiryono Ruby, M.Sc, Ph.D, selaku Ketua Jurusan Matematika. 4. Drs. Rudi Ruswandi,M.Sc, selaku pembimbing akademik. 5. Dr. Sutyarso, MS, selaku Dekan FMIPA Unila. 6. Ayah, ibu, dan keluargaku yang senantiasa membimbingku dan menantikan kelulusanku. 7. Pa’de sekeluarga, atas segala kebersamaan dan dukungan selama kuliah di Lampung.
ii
8. Eko, Deni, Rija, Hasan, Angger, dan semua teman-teman angkatan 2006 yang tidak dapat saya sebutkan satu per satu, atas kebersamaannya. 9. Semua pihak yang turut memberikan kenangan semasa kuliah.
Semoga Allah SWT membalas kebaikan dan bantuan yang telah diberikan kepada penulis dengan sebaik-baiknya serta semoga Tugas Akhir ini dapat bermanfaat. Amin.
Bandar Lampung, Juli 2010 Penulis
Aditya Wisnu Prihanto
iii
MOTO
Tiada kesuksesan tanpa berusaha dan berdo’a
iv
DAFTAR ISI
KATA PENGANTAR ................................................................................................... i MOTO ............................................................................................................................. iii DAFTAR ISI ................................................................................................................... iv DAFTAR GAMBAR ...................................................................................................... viii DAFTAR TABEL .......................................................................................................... ix BAB I PENDAHULUAN 1.1 Latar Belakang ........................................................................................................... 1 1.2 Perumusan Masalah ................................................................................................... 3 1.3 Batasan Masalah......................................................................................................... 3 1.4 Tujuan Penelitian ....................................................................................................... 4 1.5 Manfaat Penelitian ..................................................................................................... 4 BAB II TINJAUAN PUSTAKA 2.1 Sistem Informasi .................................................................................................. 5 2.1.1 Pengertian Sistem .............................................................................................. 5 2.1.2 Pengertian Informasi ......................................................................................... 6 2.1.3 Pengertian Sistem Informasi ............................................................................. 7 2.2 Pengembangan Sistem ......................................................................................... 7 2.3 Basis Data ............................................................................................................ 9 2.3.1 Tujuan Penerapan Basis Data ........................................................................... 11 2.3.2 Atribut Tabel ..................................................................................................... 12
v
2.3.3 Kardinalitas/Derajat Relasi ............................................................................... 14 2.4 Diagram Alir (Flow Chart) .................................................................................. 14 2.5 Program Visual Basic 6.0..................................................................................... 15 2.5.1 Memulai Program Visual Basic 6.0 .................................................................. 16 2.5.2 Intergrated Development Environment (IDE) Visual Basic ............................. 16 2.6 MySQL................................................................................................................. 19 2.7 SQL ...................................................................................................................... 19 BAB III ANALISIS DAN PERANCANGAN SISTEM 3.1 Analisis Sistem yang Sedang Berjalan................................................................. 21 3.2 Analisis Sistem yang Baru ................................................................................... 21 3.3 Diagram Use Case ............................................................................................... 22 3.4 Desain Database .................................................................................................. 23 3.4.1 Entity Relationship Diagram Basis Data .................................................... 23 3.4.2 Kamus Data................................................................................................. 24 3.5 Rancangan Logika Program ................................................................................. 28 3.5.1 Menu Utama ................................................................................................ 28 3.5.2 Modul Login .............................................................................................. 29 3.5.3 Menu Data Master ....................................................................................... 30 3.5.4 Modul Master Data Dokter ........................................................................ 30 3.5.5 Modul Master Ruang ................................................................................. 31 3.5.6 Modul Master Spesialis .............................................................................. 31 3.5.7 Modul Master Kasir .................................................................................... 32
vi
3.5.8 Modul Master Login ................................................................................... 33 3.5.9 Modul Data Pasien ..................................................................................... 34 3.5.10 Modul Transaksi Pasien Masuk ............................................................... 35 3.5.11 Modul Transaksi Pasien Keluar ............................................................... 36 3.5.12 Modul Cari Dokter .................................................................................... 36 3.5.13 Modul Cari Pasien ..................................................................................... 37 3.6 Desain Tampilan .................................................................................................. 37 3.6.1 Desain Form Login ..................................................................................... 37 3.6.2 Desain Form Pengelolaan Data Dokter ....................................................... 38 3.6.3 Desain Form Pengelolaan Data Ruang ...................................................... 38 3.6.4 Desain Form Pengelolaan Data Spesialis.................................................... 39 3.6.5 Desain Form Pengelolaan Data Kasir ......................................................... 39 3.6.6 Desain Form Pengelolaan Data Pasien ....................................................... 40 3.6.7 Desain Form Pengelolaan Data Login ....................................................... 40 3.6.8 Desain Form Pengelolaan Jadwal Dokter Jaga ........................................... 41 3.6.9 Desain Form Transaksi Pasien Masuk ....................................................... 41 3.6.10 Desain Form Transaksi Pasien Keluar ...................................................... 42 3.6.11 Desain Form Pencarian Dokter ................................................................. 42 3.6.12 Desain Form Pencarian Pasien ........................................................................ 43 BAB IV IMPLEMENTASI DAN PEMBAHASAN 4.1 Implementasi Sistem ............................................................................................ 44 4.2 Tampilan Program................................................................................................ 44
vii
4.2.1 Form Utama ................................................................................................ 44 4.2.2 Form Login ................................................................................................ 45 4.2.3 Form Data Dokter ....................................................................................... 46 4.2.4 Form Data Kasir .......................................................................................... 46 4.2.5 Form Data Pasien ........................................................................................ 47 4.2.6 Form Data Ruang ........................................................................................ 48 4.2.7 Form Data Spesialis .................................................................................... 49 4.2.8 Form Data User ........................................................................................... 49 4.2.9 Form Data Dokter Jaga ............................................................................... 50 4.2.10 Form Data Pasien Masuk .......................................................................... 51 4.2.11 Form Data Pasien Keluar .......................................................................... 52 4.2.12 Form Pencarian Pasien .............................................................................. 52 4.2.13 Form Pencarian Dokter ............................................................................. 53 4.2.14 Form Cetak Laporan Pasien ...................................................................... 53 4.2.15 Tampilan Cetak Laporan Pasien ............................................................... 54 BAB V KESIMPULAN DAN SARAN 5.1 Kesimpulan .......................................................................................................... 55 5.2 Saran..................................................................................................................... 55 DAFTAR PUSTAKA LAMPIRAN
viii
DAFTAR GAMBAR
Gambar 2.1 Model Air Terjun Rekayasa perangkat lunak .............................................. 9 Gambar 2.2 Memulai Visual basic ................................................................................... 16 Gambar 2.3 Pilihan Project Visual Basic ......................................................................... 17 Gambar 2.4 Lingkungan IDE Visual Basic...................................................................... 17 Gambar 3.1 Diagram Use Case ........................................................................................ 22 Gambar 3.2 ERD database rumah sakit ........................................................................... 23 Gambar 3.3 Rancangan Logika Menu Utama .................................................................. 28 Gambar 3.4 Rancangan Logika Modul Login.................................................................. 29 Gambar 3.5 Rancangan Logika Menu Data Master ......................................................... 30 Gambar 3.6 Rancangan Logika Modul Master Data Dokter ........................................... 30 Gambar 3.7 Rancangan Logika Modul Master Ruang..................................................... 31 Gambar 3.8 Rancangan Logika Modul Master Spesialis ................................................. 31 Gambar 3.9 Rancangan Logika Modul Master Kasir ...................................................... 32 Gambar 3.10 Rancangan Logika Modul Master Login ................................................... 33 Gambar 3.11 Rancangan Logika Modul Data Pasien ...................................................... 34 Gambar 3.12 Rancangan Logika Modul Transaksi Pasien Masuk .................................. 35 Gambar 3.13 Rancangan Logika Modul Transaksi Pasien Keluar .................................. 36 Gambar 3.14 Rancangan Logika Modul Cari Dokter ...................................................... 36 Gambar 3.15 Rancangan Logika Modul Cari Pasien ....................................................... 37 Gambar 3.16 Desain Form Login ................................................................................... 37
ix
Gambar 3.17 Desain Form Pengelolaan Data Dokter ..................................................... 38 Gambar 3.18 Desain Form Login Pengelolaan Data Ruang ........................................... 38 Gambar 3.19 Desain Form Pengelolaan Data Spesialis .................................................. 39 Gambar 3.20 Desain Form Pengelolaan Data Kasir ....................................................... 39 Gambar 3.21 Desain Form Pengelolaan Data Pasien...................................................... 40 Gambar 3.22 Desain Form Pengelolaan Data Login ...................................................... 40 Gambar 3.23 Desain Form Pengelolaan Jadwal Dokter Jaga ......................................... 41 Gambar 3.24 Desain Form Transaksi Pasien Masuk ...................................................... 41 Gambar 3.25 Desain Form Transaksi Pasien Keluar ...................................................... 42 Gambar 4.1 Form Utama.................................................................................................. 44 Gambar 4.2 Form Login................................................................................................... 45 Gambar 4.3 Form data dokter .......................................................................................... 46 Gambar 4.4 Form Data Kasir ........................................................................................... 47 Gambar 4.5 Form Data Pasien ......................................................................................... 48 Gambar 4.6 Form Data Ruang ......................................................................................... 48 Gambar 4.6 Form Data Ruang ......................................................................................... 49 Gambar 4.7 Form Data User ............................................................................................ 50 Gambar 4.8 Form Dokter Jaga ......................................................................................... 50 Gambar 4.9 Form Pasien Masuk ...................................................................................... 51 Gambar 4.11 Form Pasien Keluar .................................................................................... 52 Gambar 4.12 Form Pencarian Pasien ............................................................................... 52 Gambar 4.13 Form Pencarian Dokter .............................................................................. 53
x
Gambar 4.14 Form Cetak Laporan Pasien ...................................................................... 54 Gambar 4.15 Cetak Data Pasien....................................................................................... 54
xi
DAFTAR TABEL
Tabel 2.1 Simbol-simbol Diagram Alir (Flow Chart)..................................................... 15
