DAFTAR ISI
HALAMAN JUDUL .................................................................................... i LEMBAR PENGESAHAN PEMBIMBING ............................................ ii LEMBAR PENGESAHAN PENGUJI ...................................................... iii LEMBAR PERNYATAAN KEASLIAN .................................................. iv HALAMAN PERSEMBAHAN .................................................................. v MOTTO ........................................................................................................ vi KATA PENGANTAR .................................................................................. vii ABSTRAK .................................................................................................... ix TAKARIR ..................................................................................................... x DAFTAR ISI ................................................................................................ xii DAFTAR TABEL ....................................................................................... xvii DAFTAR GAMBAR ................................................................................... xviii BAB I PENDAHULUAN 1.1
Latar Belakang ....................................................................... 1
1.2
Rumusan Masalah ................................................................. 2
1.3
Batasan Masalah .................................................................... 2
1.4
Tujuan Penelitian .................................................................... 2
1.5
Manfaat Penelitian ................................................................. 3
1.6
Metodologi Penelitian ........................................................... 3
1.7
Sistematika Penelitian ........................................................... 4
BAB II LANDASAN TEORI 2.1
Konsep Dasar Sistem Informasi.............................................. 5 2.1.1. Definisi Sistem ............................................................. 5 2.1.2. Definisi Informasi ........................................................ 6 2.1.3. Definisi Sistem Informasi ............................................. 6 2.1.4. Definisi Akuntansi ........................................................ 7 2.1.4.1 Siklus Akuntansi .................................................... 8 2.1.4.2 Pengertian Akun/ Rekening ................................... 12 2.1.4.3 Daftar Akun/ Rekening .......................................... 13
xii
2.1.5. Definisi Sistem Informasi Akuntansi ............................ 14 2.2
Rekayasa Perangkat Lunak .................................................... 15 2.2.1. Definisi Rekayasa Perangkat Lunak ............................ 15 2.2.2. Software Process Model ............................................... 16 2.2.2.1. The Linear Sequential Model .................................. 16
2.3
Database Development Lifecycle .......................................... 18 2.3.1. Database Planning ........................................................ 19 2.3.2. Database Design ........................................................... 19
2.4
Requirement Collection and Analisys ................................... 20 2.4.1. Wawancara ................................................................... 20 2.4.2. Observasi ...................................................................... 22
2.5
Entity Relationship Modelling .............................................. 22 2.5.1. Entity Type ................................................................... 23 2.5.2. Relationship Type ........................................................ 23 2.5.3. Attributes ...................................................................... 23 2.5.4. Strucural Constraint ..................................................... 24
2.6
UML (Unified Modelling Language) .................................... 25 2.6.1. Diagram UML .............................................................. 26 2.6.1.1. Use Case Diagram .................................................... 26 2.6.1.2. Activity Diagram ...................................................... 26
2.7
MySQL Database .................................................................. 27
2.8
PHP ....................................................................................... 28
2.9
Web Server ............................................................................ 28 2.9.1. XAMPP ........................................................................ 29
2.10 Black Box Testing ................................................................. 29 2.10.1. Equivalence Partitioning ............................................ 30 2.11 CV. Mitra IT Indonesia ......................................................... 30 BAB III METODOLOGI 3.1
Studi Literatur dan Observasi ................................................ 32 3.1.1. Database Life Cycle ................................................... 32 3.1.2. Rencana Proyek .......................................................... 33 3.1.3. Algoritma Proses Bisnis ............................................. 35
xiii
3.1.4. Sistem Warisan .......................................................... 36 3.1.5. Persyaratan Ketrampilan ............................................ 36 3.2
Perencanaan Database ........................................................... 37 3.2.1. Perencanaan Database ................................................ 37 3.2.1.1 . Mission Statement ................................................... 37 3.2.1.2. Mission Objective ................................................... 38 3.2.2. Definisi Sistem ........................................................... 40
3.3
Analisis Kebutuhan Sistem .................................................... 40 3.3.1. Analisis Kebutuhan Sistem ........................................ 40
3.4
Desain Database .................................................................... 43 3.4.1. Conceptual Design ...................................................... 43 3.4.2. Logical Design ........................................................... 46 3.4.3. Normalisasi ................................................................ 51 3.4.3.1. Bentuk Normal Pertama (1NF) ............................... 51 3.4.3.2. Bentuk Normal Kedua (2NF) .................................. 52 3.4.3.3. Bentuk Normal Ketiga (3NF) .................................. 52 3.4.4. Physical Design ......................................................... 53 3.4.4.1. Struktunr Tabel ........................................................ 53 3.4.4.2. SQL Statement ......................................................... 56 3.4.4.3. Relasi Tabel .............................................................. 59 3.4.4.4. Kapasitas Penyimpanan Data .................................. 59
3.5
Desain Aplikasi ..................................................................... 67 3.5.1. Use Case Diagram ..................................................... 67 3.5.2. Activity Diagram ....................................................... 67 3.5.2.1. Activity Diagram Login Sistem .............................. 67 3.5.2.2. Activity Diagram Mengelola Daftar Rekening ....... 67 3.5.2.3. Activity Diagram Mengelola Jurnal Umum ............ 68 3.5.2.4. Activity Diagram Mengelola Jurnal Kas Masuk ...... 68 3.5.2.5. Activity Diagram Mengelola Jurnal Kas Keluar ...... 68 3.5.2.6. Activity Diagram Mengelola Posting ....................... 68 3.5.2.7. Activity Diagram Mengelola & Lihat Buku Besar .. 68 3.5.2.8. Activity Diagram MengelolaLihat Neraca Balance
xiv
68
3.5.2.9. Activity Diagram Mengelola & Lihat Laba-rugi ..... 69 3.5.2.10. Activity Diagram Mengelola & Lihat Modal ........... 69 3.5.2.11. Activity Diagram Mengelola & Lihat Neraca ......... 69 3.6
Desain Antarmuka Sistem ..................................................... 69 3.6.1. Desain Halaman Login .............................................. 69 3.6.2. Desain Antarmuka Manajer ....................................... 70 3.6.2.1. Halaman Utama (Home) .......................................... 70 3.6.2.2. Halaman Daftar Rekening ....................................... 70 3.6.2.3. Halaman Tambah Daftar Rekening .......................... 70 3.6.2.4. Halaman Edit Daftar Rekening ................................ 70 3.6.2.5. Halaman Jurnal Umum ............................................ 70 3.6.2.6. Halaman Jurnal Kas Masuk ..................................... 71 3.6.2.7. Halaman Jurnal Kas Keluar...................................... 71 3.6.2.8. Halaman Posting ..................................................... 71 3.6.2.9. Halaman Buku Besar ............................................... 71 3.6.2.10.Halaman Neraca Balance ........................................ 72 3.6.2.11. Halaman Laba-rugi ................................................. 72 3.6.2.12.Halaman Modal ....................................................... 72 3.6.2.13. Halaman Neraca ..................................................... 72 3.6.3. Desain Antarmuka Direktur ....................................... 73 3.6.3.1. Halaman Utama ....................................................... 73 3.6.3.2. Halaman Buku Besar ............................................... 73 3.6.3.3. Halaman Neraca Balance ........................................ 73 3.6.3.4. Halaman Laba-rugi .................................................. 73 3.6.3.5. Halaman Modal ....................................................... 73 3.6.3.6. Halaman Neraca ...................................................... 74
BAB IV HASIL & PEMBAHASAN 4.1
Gambaran Umum .................................................................. 75
4.2
Pengujian Sistem ................................................................... 75 4.2.1. Pengujian dengan pengguna Manajer .......................... 76 4.2.1.1. Login System ............................................................ 76 4.2.1.2. Mengelola Daftar Rekening ..................................... 77
xv
4.2.1.3. Mengelola Jurnal Umum ........................................... 78 4.2.1.4. Mengelola Jurnal Kas Masuk .................................... 78 4.2.1.5. Mengelola Jurnal Kas Keluar .................................... 79 4.2.1.6. Mengelola Posting .................................................... 79 4.2.1.7. Laporan Buku Besar ................................................. 80 4.2.1.8. Laporan Neraca Balance ........................................... 80 4.2.1.9. Laporan Laba-rugi ..................................................... 81 4.2.1.10. Laporan Modal ........................................................ 81 4.2.1.11. Laporan Neraca ....................................................... 82 4.2.2. Pengujian dengan pengguna Direktur .......................... 82 4.2.2.1. Login Sistem ............................................................. 82 4.2.2.2. Lihat Laporan Buku Besar ........................................ 83 4.2.2.3. Lihat Laporan Neraca Balance .................................. 84 4.2.2.4. Lihat Laporan Laba-rugi............................................ 84 4.2.2.5. Lihat Laporan Modal ................................................. 84 4.2.2.6. Lihat Laporan Neraca ................................................ 85 BAB V KESIMPULAN & SARAN 5.1
Kesimpulan ............................................................................ 86
5.2
Saran ...................................................................................... 86
DAFTAR PUSTAKA .................................................................................. 87 LAMPIRAN ................................................................................................. 88
xvi
DAFTAR TABEL Tabel 3.1 Database Life Cycle ................................................................... 32 Tabel 3.2 Mission Statment ......................................................................... 38 Tabel 3.3 Mission objectives ....................................................................... 38 Tabel 3.4 Tabel Interaksi ............................................................................. 40 Tabel 3.5 Detail Informasi........................................................................... 42 Tabel 3.6 Entitas ......................................................................................... 43 Tabel 3.7 Kardilalitas .................................................................................. 44 Tabel 3.8 Atribut Entitas ............................................................................. 45 Tabel 3.9 Tabel Daftar Rekening ................................................................ 53 Tabel 3.10 Tabel Transaksi ........................................................................... 54 Tabel 3.11 Tabel Jurnal ................................................................................. 55 Tabel 3.12 Tabel Neraca Balance.................................................................. 55 Tabel 3.13 Tabel User ................................................................................... 56 Tabel 3.14 Tabel relasi .................................................................................. 56 Tabel 3.15 Tabel Ukuran Tipe Data .............................................................. 59 Tabel 3.16 Perhitungan Ukuran Tabel Daftar rekening ................................ 61 Tabel 3.17 Perhitungan Ukuran Tabel Transaksi .......................................... 62 Tabel 3.18 Perhitungan Ukuran Tabel Jurnal................................................ 63 Tabel 3.19 Perhitungan Ukuran Tabel Relasi ............................................... 64 Tabel 3.20 Perhitungan Ukuran Tabel Neraca Balance ................................ 64 Tabel 3.21 Perhitungan Ukuran Tabel User .................................................. 66
xvii
DAFTAR GAMBAR
Gambar 2.1
Siklus Akuntamnsi.................................................................. 8
Gambar 2.2
Aturan Pencatatan Akun ......................................................... 13
Gambar 2.3
Daftar Rekening...................................................................... 13
Gambar 2.4
The Linear Sequential Model ................................................. 16
Gambar 2.5
Database Development Lifecycle ........................................... 18
Gambar 2.6
One-to-One Relationship ........................................................ 24
Gambar 2.7
One-to-Many Relationship ..................................................... 25
Gambar 2.8
Many-to-Many Relationship .................................................. 25
Gambar 2.9
Use Case Diagram .................................................................. 26
Gambar 2.10 Activity Diagram .................................................................... 27
xviii
