DAFTAR ISI

DAFTAR ISI
HALAMAN JUDUL........................................................................................... i
HALAMAN PERSETUJUAN ............................................................................ ii
HALAMAN PENGESAHAN ............................................................................. iii
HALAMAN PERSEMBAHAN ......................................................................... iv
MOTO ................................................................................................................. v
KATA PENGANTAR ........................................................................................ vi
INTISARI............................................................................................................ viii
DAFTAR ISI ....................................................................................................... ix
DAFTAR TABEL ............................................................................................... xiv
DAFTAR GAMBAR .......................................................................................... xv
BAB I PENDAHULUAN .................................................................................. 1
1.1 Tinjauan Umum ................................................................................... 1
1.2 Latar Belakang Masalah ....................................................................... 2
1.3 Pokok Masalah ..................................................................................... 3
1.4 Batasan Masalah................................................................................... 4
1.5 Tujuan Penulisan Karya Tulis .............................................................. 5
1.6 Metode Pengumpilan Data ................................................................... 5
1.7 Sistematika Karya Tulis ....................................................................... 6
ix
BAB II LANDASAN TEORI
2.1 Gambaran Umum Polres Ngada........................................................... 8
2.2 Sistematika Pengambilan Data ............................................................. 9
2.3 Gambaran Sistematika Pelaporan Data Kecelakaan ............................ 11
2.4 Langkah-Langkah Penanganan ............................................................ 12
2.4.1 Mempelajari Mekanisme Pengolahan Data .............................. 12
2.4.2 Metode Analisa Data ................................................................. 12
2.4.3 Konsep Dasar Pebgolahan Data ................................................ 13
2.4.4 Basis Data ................................................................................. 15
2.4.5 Teknik Normalisasi ................................................................... 16
2.4.6 Diagram Relasi Antar Tabel...................................................... 17
2.4.7 Pengolahan Data Elektronik ...................................................... 19
2.4.8 Pembuatan Laporan ................................................................... 21
2.5 Konsep Dasar Sistem Komputerisasi ................................................... 21
2.6 Konsep Database Multiuser ................................................................. 23
2.7 Sekilas Tentang ODBC ........................................................................ 24
2.8 Bahasa Pemrograman ........................................................................... 25
BAB III PERANCANGAN SISTEM ................................................................. 27
3.1 Pengertian Sistem ................................................................................. 27
3.2 Perangkat Pendukung ........................................................................... 27
3.2.1 Sistem Perangkat Lunak ............................................................ 27
3.2.2 Sistem Perangkat Keras............................................................. 28
3.3 Perencanaan Basis Data ....................................................................... 28
x
3.3.1 Tabel Petugas ............................................................................ 29
3.3.2 Tabel Kecelakaan ...................................................................... 31
3.3.3 Tebel Kendaraan ....................................................................... 33
3.3.4 Tabel Obyek .............................................................................. 34
3.3.5 Tabel Pelapor ............................................................................ 35
3.3.6 Tabel Gambar ............................................................................ 38
3.4 Relasi Antar Tabel................................................................................ 39
3.5 Diagram Alir Sistem ............................................................................ 40
3.6 Data Flow Diagram .............................................................................. 44
3.6.1 Diagram Korteks ....................................................................... 44
3.6.2 Diagram Level 0 ........................................................................ 44
3.6.3 Diagram Arus Data Level 1 Proses Edit Data ........................... 45
3.6.4. Diagram Arus Data Level 1 Proses Simpan Data Petugas ........ 47
3.6.5 Diagram Arus Data Level 1 Proses Simpan Data Kecelakaan . 48
3.6.6 Diagram Arus Data Level 1 Proses Simpan Data Kendaraan ... 49
3.6.7 Diagram Arus Data Level 1 Proses Simpan Data Obyek ......... 50
3.6.8 Diagram Arus Data Level 1 Proses Simpan Data Pelapor ........ 51
3.6.9 Diagram Arus Data Level 1 Proses Simpan Data Gambar ....... 52
3.7 Perancangan Masukan.......................................................................... 53
3.7.1 Perancangan Masukan Data Petugas ......................................... 53
3.7.2 Perancangan Masukan Data Kecelakaan ................................. 54
3.7.3 Perancangan Masukan Data Kendaraan .................................... 54
3.7.4 Perancangan Masukan Data Obyek .......................................... 55
xi
3.7.5 Perancangan Masukan Data Pelapor ......................................... 56
3.7.6 Perancangan Masukan Data Gambar ........................................ 56
3.8 Perancangan Keluaran .......................................................................... 57
3.8.1 Laporan Kecelakaan Berdasarkan Petuas Yang Menangani ..... 58
3.8.2 Laporan Kecelakaan Lalulintas Per Kecelakaan ....................... 59
3.8.3 Laporan Kecelakaan Lalulintas Per Periode ............................. 60
3.8.4 Laporan Kendaraan Kecelakaan Per Kecelakaan ..................... 60
3.8.5 Laporan Kendaraan Kecelakaan Per Periode ............................ 61
3.8.6 Laporan Korban Kecelakaan Per Kecelakaan ........................... 62
3.8.7 Laporan Pelaku Kecelakaan Per Kecelakaan ............................ 63
3.8.8 Laporan Korban Kecelakaan Per Periode ................................. 64
3.8.9 Laporan Pelaku Kecelakaan Per Periode .................................. 65
3.8.10 Laporan Rekapitulasi Kecelakaan ............................................. 66
3.8.11 Laporan Kecelakaan lalulintas Bedasarkan Lokasi Polsek ....... 67
BAB IV IMPLEMENTASI DAN PEMBAHASAN PROGRAM ..................... 68
4.1 Analisa Program ................................................................................... 68
4.2 Spesifikasi Program ............................................................................. 68
4.2.1 Program Kendali Utama ............................................................. 69
4.2.2 Program Pengolah Data ............................................................. 69
4.2.3 Program Laporan ......................................................................... 71
4.3 Prosedur Pelaksanaan Program ............................................................ 72
4.3.1 Menjalankan Program Kendali Utama ....................................... 72
4.3.2 Menjalankan Program Pengolah Data ........................................ 74
xii
4.3.2.1 Pemasukan Data Petugas................................................... 74
4.3.2.2 Pemasukan Data Kecelakaan ............................................ 82
4.3.2.3 Pemasukan Data Kendaraan .............................................. 83
4.3.2.4 Pemasukan Data Obyek .................................................... 84
4.3.2.5 Pemasukan Data Pelapor ................................................... 85
4.3.2.6 Pemasukan Data Gambar .................................................. 86
4.3.3 Program Laporan ........................................................................ 87
4.3.3.1 Laporan Kecelakaan Lalulintas ......................................... 87
4.3.3.2 Laporan Kendaraan ........................................................... 90
4.3.3.3 Laporan Korban ................................................................ 92
4.3.3.4 Laporan Pelaku.................................................................. 94
4.3.3.5 Laporan Kecelakaan Berdasarkan Petugas Yang
Menangani ......................................................................... 96
4.3.3.6 Laporan Rekapitulasi Kecelakaan ..................................... 98
4.3.3.7 Laporan Kecelakaan Lalulintas Bedasarkan Polsek ......... 98
BAB V PENUTUP
5.1 Kesimpulan .......................................................................................... 100
5.2 Saran ..................................................................................................... 101
DAFTAR PUSTAKA ......................................................................................... 102
LAMPIRAN
xiii