Abstraksi - Repository Maranatha

vi
Abstraksi
This Top Sales, Contribution, and Productivity Searching Application has
been made for Toserba X management system in order to increase the accuration of
any decisions in selling and buying every product. All of the function in this application
have one general purpose is to provide an accurate data for Toserba X Management
Division about their product or division who provide the highest benefit contribution for
their company, so Toserba X Management division can take a right decision, which
one of their product or division that must have any decreament or increament in buying
and selling. Top Sales Function will provide an information of any product which has
the highest benefit in Toserba X. Contribution Function will give an information of
percentage selling values of every productin Toserba X. Productivity will provide an
information of any division that has the highest selling contribution for Toserba X
Incomes. Every Function purposed to reduce a mistaken in taking any decisions can
be reduce into the lowest level. Be expected this application can be running as that
purposed, and helping every of transaction activity at Toserba X.
Universitas Kristen Maranatha
vii
Daftar Isi
Kata Pengantar.................................... ................................................................................... i
Lembar Pengesahan.................................... ..........................................................................ii
Pernyataan Publikasi Laporan Penelitian.................................... ........................................... iii
Lembar Pernyataan Orisinalitas Karya...................................................................................iv
Abstraksi.................................... ............................................................................................ v
Daftar Isi .............. .................................................................................................................vi
Daftar Tabel ........................................................................................................................ viii
Daftar Gambar ...................................................................................................................... x
BAB I. Pendahuluan .............................................................................................................. 1
1.1. Latar Belakang ........................................................................................................... 1
1.2. Rumusan Masalah ...................................................................................................... 2
1.3. Tujuan ........................................................................................................................ 2
1.4. Batasan masalah ........................................................................................................ 3
1.5. Sistematika Penulisan ................................................................................................ 4
BAB II. Landasan Teori ......................................................................................................... 6
2.1. Bahasa Pemrograman C# .......................................................................................... 6
2.1.1. Latar Belakang C# ............................................................................................... 6
2.1.2. Fungsionalitas Bahasa Pemrograman C# ............................................................ 8
2.1.3. Alasan Penggunaan Bahasa Pemrograman C# ................................................... 9
2.2. Structure Query language (SQL) ................................................................................ 9
2.2.1. Latar Belakang SQL ............................................................................................. 9
2.2.2. Fungsi SQL ........................................................................................................ 10
2.3. Entity Relationship Diagram (ERD) ........................................................................... 12
2.3.1. Latar Belakang ERD .......................................................................................... 12
2.3.2. Fungsionalitas ERD ........................................................................................... 13
2.4. Data Flow Diagram (DFD) ........................................................................................ 18
2.4.1. Latar Belakang DFD ........................................................................................... 18
2.4.2. Fungsionalitas DFD............................................................................................ 19
2.5. Kamus Data.............................................................................................................. 20
2.6. PSPEC ..................................................................................................................... 21
2.7. FIFO ......................................................................................................................... 21
BAB III. ANALISIS DAN PERANCANGAN SISTEM ............................................................ 23
3.1. Proses Bisnis ............................................................................................................ 23
3.1.1. Analisa Aplikasi .................................................................................................. 24
3.1.2. Proses Perhitungan ............................................................................................ 24
3.1.3. Kriteria Pencarian............................................................................................... 25
Universitas Kristen Maranatha
viii
3.2. Entity Relationship Diagram...................................................................................... 26
3.3. Data Flow Diagram ................................................................................................... 28
3.3.1. Data Flow Diagram (DFD) Level 0...................................................................... 28
3.3.2. Data Flow Diagram Turunan .............................................................................. 30
3.3.2.1. Data Flow Diagram Level 1.......................................................................... 30
3.3.2.2. Data Flow Diagram (DFD) Level 2 ............................................................... 31
3.3.2.3. Data Flow Diagram Level 2 dari Proses 4 .................................................... 33
3.3.2.4. Data Flow Diagram Level 2 dari Proses 5 .................................................... 34
3.3.2.5. Data Flow Diagram Level 3 dari Proses 2.1 ................................................. 35
3.3.2.6. Data Flow Diagram Level 3 dari Proses 2.2 ................................................. 36
3.3.2.7. Data Flow Diagram Level 3 dari Proses 2.3 ................................................. 38
3.4. Kamus Data.............................................................................................................. 39
3.5. Spesifikasi Proses .................................................................................................... 41
3.6. User Interface Design ............................................................................................... 49
BAB IV. Hasil Tercapai.................................... .................................................................... 59
BAB V. Evaluasi.................................... .............................................................................. 82
5.1. Test Case ................................................................................................................. 82
5.2. Error handling ......................................................................................................... 110
BAB VI. Penutup.................................... ............................................................................ 118
6.1. Kesimpulan............................................................................................................. 118
6.2. Saran...................................................................................................................... 118
Daftar Pustaka .................................................................................................................... xiii
Daftar Riwayat Hidup .......................................................................................................... xiv
Universitas Kristen Maranatha
ix
Daftar Tabel
Tabel 2.1. Tabel Notasi Entity relationship Diagram ........................................................... 18
Tabel 2.2. Tabel Notasi Data flow Diagram ......................................................................... 20
Tabel 3.1. Tabel Kamus Data TB_Kelompok ...................................................................... 39
Tabel 3.2. Tabel Kamus Data TB_Kategori.......................................................................... 39
Tabel 3.3. Tabel Kamus Data TB_Produk............................................................................ 39
Tabel 3.4. Tabel Kamus Data TB_Penjualan....................................................................... 39
Tabel 3.5. Tabel Kamus Data TB_PenjualanProduk............................................................ 40
Tabel 3.6. Tabel Kamus Data TB_Login.............................................................................. 40
Tabel 3.7. Tabel Kamus Data TB_Pembelian...................................................................... 40
Tabel 3.8. Tabel Kamus Data TB_PembelianProduk........................................................... 41
Tabel 3.9. Tabel Spesifikasi Proses 1.................................................................................. 41
Tabel 3.10. Tabel Spesifikasi Proses 3................................................................................ 42
Tabel 3.11. Tabel Spesifikasi Proses 2.1.1.......................................................................... 42
Tabel 3.12. Tabel Spesifikasi Proses 2.1.2.......................................................................... 43
Tabel 3.13. Tabel Spesifikasi Proses 2.2.1.......................................................................... 44
Tabel 3.14. Tabel Spesifikasi Proses 2.2.2 ......................................................................... 44
Tabel 3.15. Tabel Spesifikasi Proses 2.3.1.......................................................................... 45
Tabel 3.16. Tabel Spesifikasi Proses 2.3.2 ......................................................................... 46
Tabel 3.17. Tabel Spesifikasi Proses 4.1… .........................................................................46
Tabel 3.18. Tabel Spesifikasi Proses 4.2… .........................................................................47
Tabel 3.19. Tabel Spesifikasi Proses 5.1… .........................................................................47
Tabel 3.20. Tabel Spesifikasi Proses 5.2… .........................................................................47
Tabel 5.1. Test Case Form Login ………………………………………………………………. 81
Tabel 5.2. Test Case Form Kelompok ………………………………………………………….82
Tabel 5.3. Test Case Form Kategori …………………………………………………………… 83
Tabel 5.4. Test Case Form Produk …………………………………………………………….. 85
Tabel 5.5. Test Case Form Penjualan Produk ………………………………………………... 91
Tabel 5.6. Test Case Form Pembelian Produk ………………………………………………... 94
Tabel 5.7. Test Case Form Top Sales……….. ………………………………………………... 96
Universitas Kristen Maranatha
x
Tabel 5.8. Test Case Form Kontribusi……….. ………………………………………………... 99
Tabel 5.9. Test Case Form Produktifitas…….. ……………………………………………….102
Universitas Kristen Maranatha
xi
Daftar Gambar
Gambar 3.2. Entity Relationship Diagram ........................................................................... 27
Gambar 3.3. Data Flow Diagram Level 0 ..............................................................................28
Gambar 3.4. Data Flow Diagram Level 1 ............................................................................ 30
Gambar 3.5. Data Flow Diagram Level 2 proses 2 ............................................................. 31
Gambar 3.6. DFD LEVEL 2 proses 4 .................................................................................. 33
Gambar 3.7. DFD LEVEL 2 proses 5 .................................................................................. 34
Gambar 3.8. DFD LEVEL 3 proses 2.1 ............................................................................... 35
Gambar 3.9. DFD LEVEL 3 proses 2.2 ............................................................................... 37
Gambar 3.10. DFD LEVEL 3 proses 2.3 ............................................................................. 38
Gambar 3.11. Main Form ......................................................................................................49
Gambar 3.12. Main Form File ..............................................................................................50
Gambar 3.13. Main Form Menu .......................................................................................... 50
Gambar 3.14. Main Form Edit ............................................................................................. 51
Gambar 3.15. Top Sales Form ............................................................................................ 52
Gambar 3.16. Kontribusi Form ............................................................................................ 53
Gambar 3.17. Produktifitas Form ........................................................................................ 54
Gambar 3.18. Form Edit Kelompok .................................................................................... 55
Gambar 3.19. Form Edit Produk ......................................................................................... 56
Gambar 3.20. Form Edit Kategori ....................................................................................... 57
Gambar 3.21. Form Login ................................................................................................... 58
Gambar 4.1. Tampilan MainForm………………………………………………………………. 59
Gambar 4.2. Tampilan Menu File………………………………………………………………. 60
Gambar 4.3. Tampilan Form Login……………………………………………………………… 60
Gambar 4.4. Tampilan Menu Edit………………………………………………………………. 61
Gambar 4.5. Tampilan Form Kelompok ……………………………………………………… 61
Gambar 4.6. Tampilan Form kategori …………………………………………………………. 62
Gambar 4.7. Tampilan Form Produk …………………………………………………………… 62
Gambar 4.8. Tampilan Form Login…………………………………………………………….. 63
Gambar 4.9. Tampilan Form PenjualanProduk ………………………………………………. 63
Universitas Kristen Maranatha
xii
Gambar 4.10. Tampilan Form Penjualan ……………………………………………………… 64
Gambar 4.11. Tampilan MainForm “menu” ……………………………………………………. 65
Gambar 4.12. Tampilan Form Top Sales ………………………………………………………65
Gambar 4.13. Tampilan Hasil Pencarian Top Sales ..………………………………………… 66
Gambar 4.14. Tampilan Hasil Report Top Sales………………………………………………. 67
Gambar 4.15. Tampilan Form Kontribusi ……………………………………………………… 68
Gambar 4.16. Tampilan Hasil Pencarian Kontribusi .……………………………………….. 69
Gambar 4.17. Tampilan Report Kontribusi …..………………………………………………… 70
Gambar 4.18. Tampilan Form Produktifitas .……………………………………………………70
Gambar 4.19. Tampilan Hasil Pencarian Produktifitas ..……………………………………… 71
Gambar 4.20. Tampilan Cetak Report Dan Grafik .…………………………………………… 72
Gambar 4.21. Tampilan Main Form Menu Penjualan………………………………………… 73
Gambar 4.22. Tampilan Form Penjualan Produk .…………………………………………… 73
Gambar 4.23. Tampilan Form penjualan .…………………………………………………….. 74
Gambar 4.24. Tampilan Form Log Penjualan .……………………………………………….. 75
Gambar 4.25. Tampilan Main Form Inventory….. .…………………………………………… 76
Gambar 4.26. Tampilan Form Produk…………… .…………………………………………… 76
Gambar 4.27. Tampilan Form Log Inventory……. .…………………………………………… 77
Gambar 4.28. Tampilan Form Harga beli Stok….. .…………………………………………… 78
Gambar 4.29. Tampilan main Form menu Pembelian………………………………………… 79
Gambar 4.30. Tampilan Form Pembelian Produk .…………………………………………… 79
Gambar 4.31. Tampilan Form Histori pembelian.. .…………………………………………… 80
Gambar 5.1. Error handling dan ID password harus diisi …………………………………... 105
Gambar 5.2. Error handling ID harus diisi .....…………………………………………………105
Gambar 5.3. Error Pasword harus diisi…………… ..…………………………………………105
Gambar 5.4. Error Handling ID atau password salah ………………………………………..106
Gambar 5.5. Error Handling nama kelompok harus diisi …………………………………… 106
Gambar 5.6. Error Handling nama kategiori harus diisi …………………………………….. 106
Gambar 5.7. Error Handling Id kelompok tidak terdaftar …………………………………….107
Gambar 5.8. Error Handling Nama Kategori Telah terdaftar ……………………………….. 107
Gambar 5.9. Error Handling Semua field Harus diisi ………………………………………...107
Universitas Kristen Maranatha
xiii
Gambar 5.10. Error Handling Id kategori Tidak terdaftar …………………………………….107
Gambar 5.11. Error Handling isi data penjualan ……………………………………………..108
Gambar 5.12. Error Handling id produk salah ………………………………………………...108
Gambar 5.13. Error Handling data tidak dapat ditambahkan……………………………….. 108
Gambar 5.14. Error Handling kesalahan data ………………………………………………...109
Gambar 5.15. Error Handling kode salah…… ………………………………………………...109
Gambar 5.16. Error Handling pilih data penjualan…………………………………………... 109
Gambar 5.17. Error Handling isi data pembelian……………………………………………...110
Gambar 5.18. Error Handling belum ada transaksi………………………………………….. 110
Gambar 5.19. Error Handling isi id produk….. ………………………………………………...110
Gambar 5.20. Error Handling isi jumlah unit... ………………………………………………...110
Gambar 5.21. Error Handling data tidak dapat ditambahkan………………………………...111
Gambar 5.22. Error Handling belum ada transaksi …………………………………………..111
Universitas Kristen Maranatha