i
L A P O R A N S K R I P S I
SISTEM INFORMASI PELAYANAN SURAT KETERANGAN
DESA BERBASIS ANDROID DI DESA KEDUNGBANG
KECAMATAN TAYU KABUPATEN PATI
AH ARIF MUSTIKA AJI
NIM 201551100
DOSEN PEMBIMBING
Mukhamad Nurkamid, S.Kom., M.Cs
Wibowo Harry Sugiharto, M.Kom
PROGRAM STUDI TEKNIK INFORMATIKA
FAKULTAS TEKNIK
UNIVERSITAN MURIA KUDUS
2020
ii
iii
iv
SISTEM INFORMASI PELAYANAN SURAT KETERANGAN
DESA BERBASIS ANDROID DI DESA KEDUNGBANG
KECAMATAN TAYU KABUPATEN PATI
Nama Mahasiswa : Ah Arif Mustika Aji
NIM : 201551100
Pembimbing :
1. Mukhamad Nurkamid, S.Kom., M.Cs
2. Wibowo Harry Sugiharto, M.Kom
ABSTRAK
Setiap pelayanan masyarakat pasti terdapat suatu pemasalahan apalagi
pelayanan ditingkat desa terutama pelayanan pembuatan surat keterangan desa
yang proses pembuatannya terkadang harus kembali dua kali bahkan lebih. Desa
Kedungbang merupakan lembaga tingkat desa yang terletek di Kecamatan Tayu
Kabupaten Pati. Adapun pelayanan masyarakat disana masih menggunakan cara
manual, yaitu pelayanan masih menggunakan Microsoft Office Word sehingga
terjadi penumpukan file dan sering hilangnya file surat. Maka dari itu dibuatlah
Sistem Informasi Pelayanan Surat Keterangan Desa Berbasis Android di Desa
Kedungbang Kecamatan Tayu Kabupaten Pati agar nantinya masyarakat lebih
mudah memproses pembuatan surat keterangan dari desa. Tujuan dari penelitian
yang dilakukan peneliti dengan membuat aplikasi sistem informasi pelayanan
surat keterangan desa bertujuan memberikan kontribusi positif bagi masyarakat
desa terutama di bagian pelayanan permohonan pembuatan surat keterangan dari
desa agar lebih mudah efektif dan efisien dengan memanfaatkan kemajuan
teknologi. Metode penelitian yang digunakan yaitu waterfall. Hasil dari penelitian
dan pengujian yang dilakukan ini dapat ditarik kesimpulan yaitu Aplikasi Sistem
Informasi Layanan Surat Keterangan Desa Berbasis Android di Desa Kedungbang
Kecamatan Tayu Kabupaten Pati dapat diimplementasikan pada platform android,
dan dapat membantu pihak aparatur dalam proses pembuatan surat.
Kata kunci : Pelayanan, Masyarakat, Android
v
SISTEM INFORMASI PELAYANAN SURAT KETERANGAN
DESA BERBASIS ANDROID DI DESA KEDUNGBANG
KECAMATAN TAYU KABUPATEN PATI
Student Name : Ah Arif Mustika Aji
Student Identity Number : 201551100
Supervisor :
1. Mukhamad Nurkamid, S.Kom., M.Cs
2. Wibowo Harry Sugiharto, M.Kom
ABSTRACT
Every community service must be included as an issue that is raised by the
government in the place of making a statement of the village, which is making
more than twice as much. Kedungbang Village is a village level institution that is
located in the District of Tayu, Pati Regency. How do community services still use
manual methods, namely services still use Microsoft Office Word so that there is a
buildup of files and letter files often occur. Therefore, a Village-Based
Information Service Information System was made in Kedungbang Village, Tayu
Subdistrict, Pati Regency so that the community could more easily produce a
certificate from the village. The aim of the research conducted by the researcher
is to make the village certificate information system give a positive response to the
village community about making the village certificate easier and more efficient
by utilizing advanced technology. The research method used is a waterfall. The
results of this research and testing can be concluded that the Information System
Application for Android-Based Village Information Services in the Village of
Kedungbang Tayu District Pati District can be implemented on the Android
platform, and can help the apparatus in the process of making a letter.
Keyword : Services, Community, Android
vi
KATA PENGANTAR
Puji syukur kehadirat Allah SWT atas Rahmat dan Hidayah-Nya peneliti
mampu menyelesaikan penyusunan skripsi ini dengan judul “Sistem Informasi
Pelayanan Surat Keterangan Desa Berbasis Android di Desa Kedungbang
Kecamatan Tayu Kabupaten Pati”. Penelitian Skripsi ini dapat peneliti selesaikan
sesuai dengan yang direncanakan berkat dukungan dari beberapa pihak yang tak
ternilai besarnya. Oleh karena itu tak lupa peneliti mengucapkan banyak
terimakasih kepada:
1. Allah SWT yang telah memberikan Rahmat dan Hidayah-Nya.
2. Kedua Orang tua yang selalu mendukung dan mendoakan saya.
3. Bapak Dr. Suparnyo, S.H., M.S., selaku Rektor Universitas Muria Kudus.
4. Bapak Mohammad Dahlan, S.T., M.T., selaku Dekan Fakultas Teknik
Informatika Universitas Muria Kudus.
5. Bapak Ahmad Jazuli, M.Kom., selaku Ketua Proggram Studi Teknik
Informatika Universitas Muria Kudus.
6. Bapak Mukhamad Nurkamid, S.Kom., M.Cs., selaku Dosen Pembimbing I
7. Bapak Wibowo Harry Sugiharto, M.kom., selaku Dosen Pembimbing II
8. Bapak Maskuri selaku kepala desa Kedungbang beserta jajarannya
9. Teman-teman seperjuangan yang telah membantu dalam penyusunan
skripsi ini.
Semoga beliau-beliau mendapatkan balasan yang lebih dari Allah SWT
melebihi apa yang diberikan kepada peneliti.
Kudus, 25 Februari 2020
Ah Arif Mustika Aji
vii
DAFTAR ISI
HALAMAN PENGESAHAN ............................................................................... ii
PERNYATAAN KEASLIAN .............................................................................. iii
ABSTRAK ............................................................................................................ iv
ABSTRACT ........................................................................................................... v
KATA PENGANTAR .......................................................................................... vi
DAFTAR ISI ........................................................................................................ vii
DAFTAR TABEL ................................................................................................. x
DAFTAR GAMBAR ........................................................................................... xii
DAFTAR LAMPIRAN ....................................................................................... xv
BAB I PENDAHULUAN ...................................................................................... 1
1.1 Latar Belakang ............................................................................................ 1
1.2 Rumusan Masalah ....................................................................................... 2
1.3 Batasan Masalah .......................................................................................... 2
1.4 Tujuan .......................................................................................................... 3
1.5 Manfaat ........................................................................................................ 3
BAB II TINJAUAN PUSTAKA ........................................................................... 5
2.1 Penelitian Terkait ........................................................................................ 5
2.2 Landasan Teori ............................................................................................ 5
2.2.1 Pelayanan ................................................................................................ 5
2.2.2 Masyarakat.............................................................................................. 6
2.2.3 Sistem Informasi ..................................................................................... 6
2.2.4 Data ......................................................................................................... 6
2.3 Sistem Operasi yang Digunakan ................................................................. 6
2.3.1 Android ................................................................................................... 6
2.4 Peralatan yang Digunakan ........................................................................... 7
2.4.1 Visual Studio Code ................................................................................. 7
2.4.2 Typesccript ............................................................................................. 7
2.4.3 Framework Ionic .................................................................................... 8
2.4.4 Perl Hypertext Prepocessor (PHP) ......................................................... 8
2.4.5 XAMPP ................................................................................................... 9
viii
2.4.6 JSON ....................................................................................................... 9
2.4.7 MySQL .................................................................................................... 9
2.5 Desain Struktur .......................................................................................... 10
2.5.1 Flowchart ............................................................................................. 10
2.5.2 ERD (Entity Relationship Diagram) .................................................... 12
2.5.3 DFD (Data Flow Diagram) .................................................................. 14
2.6 Metode Waterfall ....................................................................................... 15
2.7 The V-Model of Software Testing .............................................................. 16
2.8 Kerangka Pikir ........................................................................................... 19
BAB III METODOLOGI PENELITIAN ......................................................... 21
3.1 Metodologi Pengumpulan Data ................................................................. 21
3.2 Metode Pengembangan Sistem ................................................................. 21
3.2.1 Tahapan Requirement Analysis and Definition .................................... 22
3.2.2 Tahapan System and Software Design .................................................. 23
3.2.3 Tahapan Implementation and System Testing ...................................... 23
3.2.4 Tahapan Integration and System Testing.............................................. 24
3.2.5 Tahapan Operation and Maintenance .................................................. 24
3.3 Perancangan Aplikasi ................................................................................ 24
3.3.1 Flowchart ............................................................................................. 25
3.3.2 ERD (Entity Relationship Diagram) .................................................... 27
3.3.3 DFD (Data Flow Diagram) .................................................................. 28
3.4 Perancangan Basis Data ............................................................................ 31
3.4.1 Relasi Tabel ......................................................................................... 31
3.4.2 Struktur Basis Data ............................................................................... 32
3.5 Desain Antarmuka ( Interface ) ................................................................. 35
3.5.1 Desain Antarmuka Aparatur Desa ........................................................ 35
3.5.2 Desain Antarmuka User ....................................................................... 39
3.5.3 Desain Antarmuka Admin .................................................................... 42
BAB IV HASIL DAN PEMBAHASAN ............................................................ 45
4.1. Implementasi Aplikasi ............................................................................... 45
4.2. Pengujian Aplikasi .................................................................................... 63
4.2.1. The V-Model Testing of Software Testing ............................................ 63
ix
BAB 5 PENUTUP ................................................................................................ 87
5.1. Kesimpulan ................................................................................................ 87
5.2. Saran .......................................................................................................... 87
DAFTAR PUSTAKA .......................................................................................... 88
LAMPIRAN ......................................................................................................... 90
BIODATA PENELITI ...................................................................................... 103
x
DAFTAR TABEL
Tabel 2. 1 Flow Direction Symbols ....................................................................... 10
Tabel 2. 2 Processing Symbol .............................................................................. 11
Tabel 2. 3 Input/Output Symbols ........................................................................... 12
Tabel 2. 4 Simbol DFD ......................................................................................... 14
Tabel 3. 1 Struktur Basis Data .............................................................................. 32
Tabel 3. 2 Tabel Buat _Surat................................................................................. 33
Tabel 3. 3 Tabel Laporan ...................................................................................... 33
Tabel 3. 4 Tabel Perangkat.................................................................................... 34
Tabel 3. 5 Tabel RTRW ........................................................................................ 34
Tabel 3. 6 Tabel User ............................................................................................ 34
Tabel 3. 7 Tabel user_web .................................................................................... 35
Tabel 4. 1 Test Risk/Isuue ..................................................................................... 64
Tabel 4. 2 Item yang Akan Diuji dan Tidak Akan Diuji ....................................... 65
Tabel 4. 3 Kriteria Lolos Pengujian ...................................................................... 66
Tabel 4. 4 Test Pass/Fail Criteria ......................................................................... 67
Tabel 4. 5 Test Entry/Exit Criteria ........................................................................ 67
Tabel 4. 6 Intergration Testing ............................................................................. 68
Tabel 4. 7 User Aceptance Testing ....................................................................... 69
Tabel 4. 8 UAT mengajukan surat pengantar SKCK ............................................ 70
Tabel 4. 9 UAT mengajukan surat keterangan...................................................... 70
Tabel 4. 10 UAT mengajukan laporan kesalahan profil ....................................... 72
Tabel 4. 11 Production Verification Testing ......................................................... 72
Tabel 4. 12 Teskt Risk/Issues ................................................................................ 73
Tabel 4. 13 Item yang Akan Diuji dan Tidak Akan Diuji ..................................... 74
Tabel 4. 14 Kriteria Lolos Pengujian .................................................................... 75
Tabel 4. 15 Test Pass/Fail Criteria ....................................................................... 76
Tabel 4. 16 Test Entry/Exit Criteria ...................................................................... 78
Tabel 4. 17 Intergration Testing ........................................................................... 78
Tabel 4. 18 UAT login .......................................................................................... 79
Tabel 4. 19 UAT tambah admin ............................................................................ 80
Tabel 4. 20 UAT tambah perangkat ...................................................................... 81
xi
Tabel 4. 21 UAT tambah warga ............................................................................ 82
Tabel 4. 22 UAT tambah surat .............................................................................. 84
Tabel 4. 23 UAT kelola laporan ............................................................................ 85
Tabel 4. 24 Production Verification Testing ......................................................... 86
xii
DAFTAR GAMBAR
Gambar 2. 1 Prinsip Kerja PHP .............................................................................. 8
Gambar 2. 2 Simbol entitas (entity) ...................................................................... 13
Gambar 2. 3 Simbol atribut ................................................................................... 13
Gambar 2. 4 Simbol hubungan (relationship)....................................................... 13
Gambar 2. 5 Metode Waterfall (Sommerville, 2011) ........................................... 15
Gambar 2. 6 The-V Model Of Testing (Bentley, Dkk., 2005) ............................... 17
Gambar 2. 7 Kerangka Pikir.................................................................................. 19
Gambar 3. 1 Flowchart login user ........................................................................ 25
Gambar 3. 2 Flowchart diagram menu ................................................................. 26
Gambar 3. 3 Flowchat proses lapor user .............................................................. 27
Gambar 3. 4 ERD (Entity Relationship Diagram) ................................................ 28
Gambar 3. 5 DFD level 0 ...................................................................................... 29
Gambar 3. 6 DFD level 1 ...................................................................................... 30
Gambar 3. 7 DFD level 2 proses 10.1 proses data surat ....................................... 31
Gambar 3. 8 Relasi Tabel ...................................................................................... 32
Gambar 3. 9 Desain Halaman Utama Sebelum Login .......................................... 36
Gambar 3. 10 Desain Halaman Login ................................................................... 36
Gambar 3. 11 Desain Halaman Utama .................................................................. 37
Gambar 3. 12 Desain Halaman Kelola User ......................................................... 37
Gambar 3. 12 Desain Halaman Tambah User ...................................................... 37
Gambar 3. 13 Desain Halaman Kelola Surat ........................................................ 38
Gambar 3. 14 Desain Tampilan tambahan Data Surat .......................................... 39
Gambar 3. 15 Desain halaman login ..................................................................... 39
Gambar 3. 16 Desain halaman utama ................................................................... 40
Gambar 3. 17 Desain halaman surat pengantar SKCK ......................................... 40
Gambar 3. 18 Desain halaman surat keterangan ................................................... 41
Gambar 3. 19 Desain halaman menu history ........................................................ 41
Gambar 3. 20 Desain halaman menu profil .......................................................... 42
Gambar 3. 21 Desain halaman login ..................................................................... 42
Gambar 3. 22 Desain halaman utama ................................................................... 43
xiii
Gambar 3. 23 Desain halaman kelola admin ........................................................ 43
Gambar 3. 24 Desain halaman kelola aparatur desa ............................................. 44
Gambar 4. 1 Halaman Login Android User .......................................................... 45
Gambar 4. 2 Source code login ............................................................................. 46
Gambar 4. 3 Halaman Utama Android User ......................................................... 46
Gambar 4. 4 Source code halaman utama ............................................................. 47
Gambar 4. 5 Halaman Profil User Android .......................................................... 48
Gambar 4. 6 Source code halaman profil .............................................................. 48
Gambar 4. 7 Halaman History User Android........................................................ 49
Gambar 4. 8 Implementasi source code halaman history surat ............................ 49
Gambar 4. 9 Halaman form pengajuan surat pengantar SKCK ............................ 50
Gambar 4. 10 Source code form pengajuan surat pengantar SKCK ..................... 50
Gambar 4. 11 Halaman surat keterangan desa ...................................................... 51
Gambar 4. 12 Implementasi source code form surat keterangan .......................... 52
Gambar 4. 13 Halaman lapor kesalahan profil...................................................... 52
Gambar 4. 14 Source code laporan kesalahan profil............................................. 53
Gambar 4. 15 Tampilan halaman login admin ...................................................... 53
Gambar 4. 16 Source code login ........................................................................... 54
Gambar 4. 17 Halaman data admin ....................................................................... 54
Gambar 4. 18 Source code tampil data admin ...................................................... 55
Gambar 4. 19 Tampilan halaman data perangkat.................................................. 55
Gambar 4. 20 Source code tampil data perangkat................................................. 55
Gambar 4. 21 Tambah data admin ........................................................................ 56
Gambar 4. 22 Source code tambah data admin ..................................................... 56
Gambar 4. 23 Halaman tambah data perangkat .................................................... 57
Gambar 4. 24 Source code tambah data perangkat ............................................... 57
Gambar 4. 25 Data warga...................................................................................... 58
Gambar 4. 26 Source code tampil data warga....................................................... 58
Gambar 4. 27 Tambah data warga ........................................................................ 59
Gambar 4. 28 Source code tambah data warga ..................................................... 60
Gambar 4. 29 Tampil data surat ............................................................................ 61
Gambar 4. 30 Source code tampil data surat......................................................... 61
xiv
Gambar 4. 31 Tambah data surat .......................................................................... 62
Gambar 4. 32 Source code tambah data surat ....................................................... 62
Gambar 4. 33 Output surat pengantar skck ........................................................... 63
xv
DAFTAR LAMPIRAN
Lampiran 1 Buku Konsultasi ................................................................................ 90
Lampiran 2 Buku Konsultasi Dosen Utama.......................................................... 91
Lampiran 3 Buku Konsultasi Dosen Utama.......................................................... 92
Lampiran 4 Buku Konsultasi Dosen Pendamping ................................................ 93
Lampiran 5 Buku Konsultasi Dosen Pendamping ................................................ 94
Lampiran 6 Surat pengantar SKCK ...................................................................... 95
Lampiran 7 Contoh Surat SKCK .......................................................................... 96
Lampiran 8 Surat Balasan Penelitian .................................................................... 97
Lampiran 9 Kuesioner ........................................................................................... 98
Lampiran 10 Kuesioner ......................................................................................... 99
Lampiran 11 Kuesioner ....................................................................................... 100
Lampiran 12 Kuesioner ....................................................................................... 101
Lampiran 13 Kuesioner ....................................................................................... 102