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
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
PENGESAHAN STATUS SKRIPSI
iv
v
vi
vi
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
vii
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
viii
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.
ix
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
x
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
xi
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
xii
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
xiii
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
xiv
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
xi
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 xii
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
xiii
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 desa72 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
xiv
DAFTAR LAMPIRAN
Lampiran 1 Buku Bimbingan Lampiran 2 Lembar Revisi
xv