skripsi penerapan fuzzy database model tahani …eprints.umk.ac.id/5964/1/halaman_judul.pdf · 5.12...
TRANSCRIPT
SKRIPSI
PENERAPAN FUZZY DATABASE MODEL TAHANI UNTUK DANA
BANTUAN DESA DI KECAMATAN KALIWUNGU KABUPATEN KUDUS
BERBASIS WEB
Oleh :
WIWIN ANDARWATI
201251040
SKRIPSI DIAJUKAN SEBAGAI SALAH SATU SYARAT UNTUK
MEMPEROLEH GELAR SARJANA KOMPUTER
PROGRAM STUDI TEKNIK INFORMATIKA
FAKULTAS TEKNIK
UNIVERSITAS MURIA KUDUS
2016
ii
SKRIPSI
PENERAPAN FUZZY DATABASE MODEL TAHANI UNTUK DANA
BANTUAN DESA DI KECAMATAN KALIWUNGU KABUPATEN KUDUS
BERBASIS WEB
Oleh :
WIWIN ANDARWATI
201251040
SKRIPSI DIAJUKAN SEBAGAI SALAH SATU SYARAT UNTUK
MEMPEROLEH GELAR SARJANA KOMPUTER
PROGRAM STUDI TEKNIK INFORMATIKA
FAKULTAS TEKNIK
UNIVERSITAS MURIA KUDUS
2016
iv
PENGESAHAN STATUS SKRIPSI
v
vi
vi
vii
ABSTRACT
Fuzzy model database Tahani is one method that can be used in the decision-making
process. In this study, the application of fuzzy Tahani model database is used to
assist the district in knowing the details of the amount of aid in the can by the village
.By calculating the variables or rules used to determine how much money is in the
can by the village. So that the district work does not have to do it manually by
checking one by one fund in the can by each village. On the application of fuzzy this
database, the results can to determine the amount of funds that can be in every
village, why every village gets village grants differentiated from one another. By
applying fuzzy This database will be calculated variables used in declaring. So with
this implementation will help the district to find out why each village different
assistance.
Keywords: fuzzy database, tahani models, village grants
viii
ABSTRAK
Fuzzy database model Tahani merupakan salah satu metode yang dapat digunakan
pada proses pengambilan keputusan. Dalam penelitian ini, penerapan fuzzy database
model Tahani digunakan untuk membantu pihak kecamatan dalam mengetahui
rincian jumlah dana bantuan yang di dapat oleh desa. Dengan cara menghitung
variabel atau peraturan yang di gunakan untuk menentukan berapa banyak dana yang
di dapat oleh desa tersebut. Sehingga pihak kecamatan dalam bekerja tidak harus
melakukan secara manual dengan mengecek satu persatu dana yang di dapat oleh
setiap desa. Pada penerapan fuzzy database ini, hasil yang di dapat untuk mengetahui
jumlah dana bantuan yang di dapat pada setiap desa, mengapa setiap desa mendapat
dana bantuan desa beda satu sama lain. Dengan menerapkan fuzzy database ini akan
di hitung variabel yang digunakan pada perbup. Sehingga dengan penerapan ini akan
membantu pihak kecamatan dalam mengetahui mengapa setiap desa mendapatkan
bantuan yang berbeda.
Kata kunci : fuzzy database, model Tahani, dana bantuan desa
ix
KATA PENGANTAR
Puji syukur kehadirat Allah SWT karena atas Rahmat dan Hidayah-Nya, sehinnga
penulis dapat menyelesaikan penyusunan skripsi ini dengan judul “PENERAPAN
FUZZY DATABASE MODEL TAHANI UNTUK DANA BANTUAN DESA DI
KECAMATAN KALIWUNGU KABUPATEN KUDUS BERBASIS WEB”.
Skripsi ini disusun guna melengkapi salah satu persyaratan untuk
memperoleh Gelar Kesarjanaan Program Studi Teknik Informatika Fakultas Teknik
Universitas Muria Kudus. Pada kesempatan ini penulis ingin menyampaikan rasa
terima kasih yang sebesar – besarnya kepada :
1. Rektor Universitas Muria Kudus, bapak Dr. Suparnyo, SH, MS
2. Dekan Fakultas Teknik Universitas Muria Kudus, bapak Mohammad Dahlan,
S.T.,M.T.
3. Bapak Ahmad Jazuli, S.Kom, M.Kom, selaku Ketua Program Studi Teknik
Informatika Universitas Muria Kudus
4. Ibu Endang Supriyati, M.Kom, selaku dosen pembimbing pertama yang
senantiasa sabar dalam membimbing, memberi saran, dan pengarahannya.
5. Ibu Anastasya Latubessy, S.Kom, M.Cs, selaku dosen pembimbing kedua
yang telah memberikan saran dan pengarahan.
6. Kedua orang tua tercinta yang selalu mendukung penuh dan semangat
7. Kakak serta adikku tersayang yang selalu memberi semangat
8. Sahabatku yang selalu memberi semangat dan membantu menyelesaikan
skripsi ini (indah nur, fifit setyo, nadif ahmad).
9. Semua teman – temanku Teknik Informatika Angkatan 2012 yang tidak dapat
saya sebutkan satu persatu yang telah membantu dan memberi saran serta
semangat.
10. Semua pihak yang telah membantu penyusunan skripsi ini yang tidak bisa di
sebutkan satu persatu.
x
Dari penulis “Tiada Gading yang tak retak” sadar bahwa dalam penyusunan
skripsi ini masih jauh dari kesempurnaan. Oleh karena itu saran dan kritik yang
membangun senantiasa penulis harapkan dalam penyusunan skripsi ini untuk
yang lebih baik. Selain itu penulis juga berharap semoga karya tulis ini dapat
memberikan manfaat bagi semua.
Kudus , 20 Mei 2016
Penulis
xi
DAFTAR ISI
HALAMAN SAMPUL ................................................................................................. i
HALAMAN JUDUL .................................................................................................... ii
PENGESAHAN STATUS SKRIPSI ......................... Error! Bookmark not defined.
PERNYATAAN PENULISAN ................................. Error! Bookmark not defined.
PERSETUJUAN SKRIPSI ........................................ Error! Bookmark not defined.
PENGESAHAN SKRIPSI ......................................... Error! Bookmark not defined.
ABSTRACT ............................................................................................................... vii
ABSTRAK ................................................................................................................ viii
KATA PENGANTAR ................................................................................................ ix
DAFTAR ISI ............................................................................................................... xi
DAFTAR TABEL ....................................................................................................... xi
DAFTAR GAMBAR ................................................................................................. xii
DAFTAR LAMPIRAN .............................................................................................. xv
BAB I PENDAHULUAN ............................................................................................ 1
1.1 Latar Belakang .............................................................................................. 1
1.2 Rumusan Masalah ......................................................................................... 3
1.3 Batasan Masalah ............................................................................................ 3
1.4 Tujuan Penelitian ........................................................................................... 3
1.5 Manfaat Penelitian ......................................................................................... 3
1.6 Sistematika Penulisan .................................................................................... 4
BAB II TIJAUAN PUSTAKA .................................................................................... 5
2.1 Penelitian Terkait .......................................................................................... 5
2.2 Landasan Teori .............................................................................................. 6
2.2.1 Pengertian Alokasi Dana Desa ............................................................... 6
xii
2.2.2 Tujuan Alokasi Dana Desa..................................................................... 6
2.2.3 Metode Fuzzy ......................................................................................... 6
2.2.4 Tools Perancangan Aplikasi ................................................................. 14
2.3 Kerangka Pemikiran .................................................................................... 19
BAB III METODE PENELITIAN............................................................................. 21
3.1 Pengumpulan Data ...................................................................................... 21
3.2 Metode Pengerjaan ...................................................................................... 21
BAB IV ANALISIS, PERANCANGAN DAN DESAIN INPUT OUTPUT ............ 23
4.1 Deskripsi Masalah ....................................................................................... 23
4.2 Analisis Kebutuhan System ......................................................................... 23
4.2.1 Data Master .......................................................................................... 24
4.2.2 Grafik Derajat Keanggotaan ................................................................ 26
4.3 Perancangan Proses ..................................................................................... 34
4.3.1 Context Diagram (CD) ......................................................................... 34
4.3.2 Decomposition ..................................................................................... 35
4.3.3 Data Flow Diagram (DFD) Level 0 .................................................... 35
4.3.4 Data Flow Diagram (DFD) Level 1 Proses 1 ...................................... 37
4.3.5 Data Flow Diagram (DFD) Level 1 Proses 2 ..................................... 38
4.3.6 Data Flow Diagram (DFD) Level 1 Proses 3 ...................................... 38
4.3.7 Data Flow Diagram (DFD) Level 1 Proses 4 ...................................... 39
4.4 Perancangan Database ................................................................................. 40
4.4.1 Entity Relationship Diagram (ERD) .................................................... 40
4.4.2 Desain Tabel......................................................................................... 41
4.5 Perancangan Desain Interface, Input dan Output ........................................ 47
4.5.1 Form Utama ......................................................................................... 47
4.5.2 Form Login .......................................................................................... 47
xiii
4.5.3 Form Menu Admin ............................................................................... 48
4.5.4 Form Input Variabel ............................................................................. 48
4.5.5 Form Input Himpunan .......................................................................... 48
4.5.6 Form Input Batas Himpunan ................................................................ 49
4.5.7 Form Menghitung Derajat Keanggotaan .............................................. 49
4.5.8 Form Penerapan Operator Zedah ......................................................... 50
4.5.9 Form Data Variabel .............................................................................. 51
4.5.10 Form Data Himpunan ........................................................................... 51
4.5.11 Form Data Batas Himpunan ................................................................. 51
4.5.12 Laporan Data Desa ............................................................................... 52
4.5.13 Laporan Data Bantuan Dana Desa ....................................................... 52
4.5.14 Laporan Hasil Perhitungan Derajat Keanggotaan ................................ 52
BAB V IMPLEMENTASI SISTEM .......................................................................... 55
5.1 Tabel Database ............................................................................................ 55
5.1.1 Tabel Desa ............................................................................................ 55
5.1.2 Tabel Bantuan ...................................................................................... 55
5.1.3 Tabel Variabel ...................................................................................... 56
5.1.4 Tabel Himpunan ................................................................................... 56
5.1.5 Tabel Batas Himpunan ......................................................................... 57
5.1.6 Tabel Derajat Penduduk ....................................................................... 57
5.1.7 Tabel Derajat Luas ............................................................................... 58
5.1.8 Tabel Derajat Kesulitan........................................................................ 58
5.1.9 Tabel Derajat Angkamiskin ................................................................. 59
5.1.10 Tabel Derajat PBB ............................................................................... 59
5.1.11 Tabel Derajat ADD .............................................................................. 60
5.1.12 Tabel Derajat Pajak .............................................................................. 60
xiv
5.2 Tabel Relationship Diagram ........................................................................ 61
5.3 Halaman Menu Utama ................................................................................. 61
5.4 Halaman Menu Login .................................................................................. 62
5.5 Halaman Menu Admin ................................................................................ 63
5.6 Form Input Variabel ................................................................................... 64
5.7 Form Input Himpunan ................................................................................. 65
5.8 Form Input Batas Himpunan ...................................................................... 66
5.9 Form Data Variabel ..................................................................................... 66
5.10 Form Data Himpunan .................................................................................. 67
5.11 Form Data Batas Himpunan ........................................................................ 67
5.12 Form Menghitung Derajat Keanggotaan ..................................................... 68
5.13 Form Penerapan Fuzzy Tahani .................................................................... 71
5.14 Form Laporan .............................................................................................. 73
5.14.1 Laporan Data Desa ............................................................................... 73
5.14.2 Laporan Data Dana Bantuan Desa ....................................................... 74
5.14.3 Laporan Hasil Hitung Derajat Keanggotaan ........................................ 74
BAB VI PENUTUP ................................................................................................... 79
6.1 Kesimpulan .................................................................................................. 79
6.2 Saran ............................................................................................................ 79
DAFTAR PUSTAKA ................................................................................................ 80
LAMPIRAN ............................................................................................................... 81
xi
DAFTAR TABEL
Tabel 2.1 Simbol Context Diagram .......................................................................... 14
Tabel 2.2 Komponen Data Flow Diagram ................................................................ 14
Tabel 2.3 Notasi Entity Relationship Diagram ......................................................... 17
Tabel 4.1Data Desa .................................................................................................... 24
Tabel 4.2 Dana Bantuan Desa ................................................................................... 25
Tabel 4.3 Variabel Perbup Alokasi Dana Desa ......................................................... 26
Tabel 4.4 Variabel Perbup Bagi Hasil Pajak dan Retribusi Daerah .......................... 26
Tabel 4.5 Variabel Perbup Bagi Hasil Pajak dan Retribusi Daerah .......................... 26
Tabel 4.6Data Jumlah Penduduk................................................................................ 27
Tabel 4.7 Data Angka Kemiskinan ........................................................................... 28
Tabel 4.8 Data Luas Wilayah .................................................................................... 29
Tabel 4.9 Data Tingkat Kesulitan Geografis ............................................................ 30
Tabel 4.10 Data Jumlah PBB .................................................................................... 30
Tabel 4.11 Data Alokasi Dana Desa ......................................................................... 31
Tabel 4.12 Data Pajak dan Retribusi Daerah ............................................................ 33
Tabel 4.13 Perancangan Tabel desa .......................................................................... 41
Tabel 4.14 Perancangan Tabel bantuan .................................................................... 42
Tabel 4.15 Perancangan Tabel variabel .................................................................... 42
Tabel 4.16Perancangan Tabel himpunan ................................................................... 43
Tabel 4.17 Perancangan Tabel batas ......................................................................... 43
Tabel 4.18Perancangan Tabel Admin ........................................................................ 44
Tabel 4.19 Perancangan Tabel Derajat_penduduk.................................................... 44
Tabel 4.20 Perancangan Tabel Derajat_luas ............................................................. 44
Tabel 4.21 Perancangan Tabel Derajat_angkamiskin ............................................... 45
Tabel 4.22 Perancangan Tabel Derajat_kesulitan ..................................................... 45
Tabel 4.23 Perancangan Tabel Derajat_pbb ............................................................. 46
Tabel 4.24 Perancangan Tabel Derajat_add.............................................................. 46
Tabel 4.25 Perancangan Tabel Derajat_pajak ........................................................... 46
xii
DAFTAR GAMBAR
Gambar 2.1 Representasi Linear Naik ........................................................................ 8
Gambar 2.2Representasi Linear Turun ........................................................................ 9
Gambar 2.3 Kurva Segitiga ......................................................................................... 9
Gambar 2.4 Kurva Trapesium ..................................................................................... 9
Gambar 2.5 Tahapan Fuzzifikasi ................................................................................ 13
Gambar 2.6 Kerangka Pemikiran ............................................................................... 19
Gambar 4.1 Fungsi Keanggotaan Variabel Jumlah Penduduk................................... 27
Gambar 4.2 Fungsi Keanggotaan Variabel Angka Kemiskinan ................................ 28
Gambar 4.3 Fungsi Keanggotaan Variabel Luas Wilayah ......................................... 29
Gambar 4.4 Fungsi Keanggotaan Variabel Tingkat Kesulitan Geografis................. 30
Gambar 4.5 Fungsi Keanggotaan Variabel Jumlah Realisasi PBB........................... 31
Gambar 4.6 Fungsi Keanggotaan Variabel Output ADD ......................................... 32
Gambar 4.7 Fungsi Keanggotaan Variabel Output Pajak Daerah............................. 33
Gambar 4.8Context Diagram ..................................................................................... 34
Gambar 4.9Decomposition penerapan fuzzy database untuk dana bantuan desa ....... 35
Gambar 4.10 Data Flow Diagram Level 0 ................................................................ 36
Gambar 4.11 DFD Level 1 proses 1.......................................................................... 37
Gambar 4.12 DFD level 1 proses 2 ........................................................................... 38
Gambar 4.13 DFD level 1 proses 3 ........................................................................... 39
Gambar 4.14 DFD level 1 proses 4 ........................................................................... 40
Gambar 4.15Entity Relationship Diagram ................................................................. 41
Gambar 4.16 Desain form menu utama .................................................................... 47
Gambar 4.17 Desain form login ................................................................................ 47
Gambar 4.18 Desain form menu admin .................................................................... 48
Gambar 4.19 Desain form input variabel .................................................................. 48
Gambar 4.20 Desain form input himpunan ............................................................... 49
Gambar 4.21 Desain form input batas himpunan...................................................... 49
Gambar 4.22 Desain form hitung derajat keanggotaan ............................................. 50
Gambar 4.23Desain form operator zedah and_or ...................................................... 50
Gambar 4.24 Desain form data variabel ................................................................... 51
xiii
Gambar 4.25 Desain form data himpunan ................................................................ 51
Gambar 4.26 Desain form data batas himpunan ....................................................... 52
Gambar 4.27 Desain laporan data desa ..................................................................... 52
Gambar 4.28 Desain laporan data dana bantuan desa .............................................. 52
Gambar 4.29 Desain laporan hasil perhitungan derajat keanggotaan ....................... 53
Gambar 5.1 Implementasi Tabel Desa ...................................................................... 55
Gambar 5.2 Implementasi Tabel Bantuan ................................................................. 55
Gambar 5.3 Implementasi Tabel Variabel ................................................................ 56
Gambar 5.4Implementasi Tabel Himpunan ............................................................... 56
Gambar 5.5 Implementasi Tabel Batas Himpunan ................................................... 57
Gambar 5.6 Implementasi Tabel Derajat Penduduk ................................................. 57
Gambar 5.7 Implementasi Tabel Derajat Luas ......................................................... 58
Gambar 5.8 Implementasi Tabel Kesulitan ............................................................... 58
Gambar 5.9 Implementasi Tabel Angkamiskin ........................................................ 59
Gambar 5.10 Implementasi Tabel pbb ...................................................................... 59
Gambar 5.11 Implementasi Tabel add ...................................................................... 60
Gambar 5.12 Implementasi Tabel pajak ................................................................... 60
Gambar 5.13 Implementasi Tabel Relationship Diagram ......................................... 61
Gambar 5.14 Implementasi Menu Utama ................................................................. 62
Gambar 5.15 Potongan script form menu utama ...................................................... 62
Gambar 5.16 Implementasi Menu Login .................................................................. 62
Gambar 5.17 Potongan script menu login ................................................................. 63
Gambar 5.18 Implementasi Menu Admin ................................................................. 63
Gambar 5.19 Potongan script header menu admin ................................................... 64
Gambar 5.20 Implementasi Form Input Variabel ..................................................... 64
Gambar 5.21 Potongan script input variabel ............................................................. 65
Gambar 5.22 Implementasi Form Input Himpunan Fuzzy ....................................... 65
Gambar 5.23 Implementasi Form Input Batas Himpunan ........................................ 66
Gambar 5.24 Implementasi form menu data variabel ............................................... 66
Gambar 5.25 Potongan script data variabel .............................................................. 67
Gambar 5.26 Implementasi form menu data himpunan ............................................ 67
Gambar 5.27 Implementasi form menu data batas himpunan................................... 68
xiv
Gambar 5.28 Potongan script data batas himpunan .................................................. 68
Gambar 5.29 Implementasi form menghitung derajat keanggotaan ......................... 69
Gambar 5.30 Potongan script hitung derajat variabel jumlah penduduk .................. 69
Gambar 5.31 Potongan script hitung derajat variabel luas wilayah .......................... 69
Gambar 5.32 Potongan script hitung derajat variabel jumlah angka kemiskinan ..... 70
Gambar 5.33 Potongan script hitung derajat variabel angka kemiskinan ................. 70
Gambar 5.34 Potongan script hitung derajat variabel jumlah realisasi pbb .............. 70
Gambar 5.35 Potongan script hitung derajat variabel alokasi dana desa .................. 71
Gambar 5.36 Potongan script hitung derajat varibael hasil pajak dan retribusi daerah
.................................................................................................................................... 71
Gambar 5.37 Implementasi menu penerapan fuzzy tahani output alokasi dana desa 72
Gambar 5.38 Potongan script penerapan fuzzy tahani output alokasi dana desa...... 72
Gambar 5.39 Implementasi menu penerapan fuzzy tahani output hasil pajak dan
retribusi daerah ........................................................................................................... 73
Gambar 5.40 Potongan script penerapan fuzzy tahani output hasil pajak daerah ..... 73
Gambar 5.41 Output Laporan Data Desa .................................................................. 74
Gambar 5.42 Output Laporan dana bantuan desa ..................................................... 74
Gambar 5.43 Laporan nilai derajat keanggotaan variabel jumlah penduduk ............ 75
Gambar 5.44Laporan nilai derajat keanggotaan variabel luas wilayah ..................... 75
Gambar 5.45 Laporan nilai derajat keanggotaan variabel angka kemiskinan .......... 76
Gambar 5.46 Laporan nilai derajat keanggotaan variabel tingkat kesulitan geografis
.................................................................................................................................... 76
Gambar 5.47 Laporan nilai derajat keanggotaan variabel jumlah realisasi PBB ...... 77
Gambar 5.48 Laporan nilai derajat keanggotaan variabel alokasi dana desa ........... 77
Gambar 5.49 Laporan nilai derajat keanggotaan variabel bagi hasil pajak daerah ... 78
xv
DAFTAR LAMPIRAN
Lampiran 1 Buku Bimbingan
Lampiran 2 Lembar Revisi