Author: UmiFajarwati
Company: TreeO@Production

DAFTAR ISI

	Halaman
HALAMAN JUDUL   ................................................................................................	i
HALAMAN PERSETUJUAN  ..................................................................................	ii
HALAMAN PENGESAHAN .....................................................................................	iii
HALAMAN PERSEMBAHAN ..................................................................................	iv
HALAMAN MOTTO .................................................................................................	vi
KATA PENGANTAR................................................................................................	vii
INTISARI  ................................................................................................................	ix
DAFTAR ISI  ...........................................................................................................	x
DAFTAR TABEL  ....................................................................................................	xvi
DAFTAR GAMBAR  ................................................................................................	xvii

BAB I PENDAHULUAN  ..........................................................................................	1
	1.1. Latar Belakang Masalah  ......................................................................1
	1.2. Maksud..................................................................................................	2
	1.3. Tujuan  .................................................................................................	2
	1.4. Pokok Masalah..................... ............................................................... 3
	1.5. Batasan Masalah...................................................................................3
	1.6. Sistematika Penulisan  ........................................................................ 3

BAB II LANDASAN TEORI  ....................................................................................	5
		2.1. Tinjauan umum tentang Toko K-FE Swalayan Yogyakarta .................	5
2.2. Sistematika Pengolahan Data Di Toko K-FE Swalayan Yogyakarta ...	5
2.2.1. Pengolahan Data Jenis Barang ................................................. 6
2.2.2. Pengolahan Data Barang .......................................................... 6
2.2.3. Pengolahan Data Supplier......................................................... 6
2.2.4. Pengolahan Data Transaksi Pembelian .................................... 7
2.2.5. Pengolahan Data Transaksi Penjualan ..................................... 7
2.3. Basis Data ........................................................................................... 7
2.4. Model Data .......................................................................................... 8
2.5. Visual Basic  ....................................................................................... 10
2.5.1  Sekilas Tentang Visual Basic 6.0 ............................................. 10
2.5.2. Fasilitas-fasilitas Visual Basic yang Digunakan 
dalam  Aplikasi ......................................................................... 10
            2.6. Sekilas Tentang MySQL ..................................................................... 15
            2.7. Definisi Sistem  ................................................................................... 20
            2.8. Definisi Sistem  Informasi ................................................................... 20
            2.9. Multiuser ............................................................................................. 20

BAB III ANALISIS DAN PERANCANGAN SISTEM  ............................................. 	22
3.1.	Analisis Sistem .................................................................................. 22
3.2.	Perancangan Sistem ......................................................................... 22
3.3.	Sistem Perangkat Keras (Hardware)  ............................................... 22
3.4.	Sistem Perangkat Lunak (Software) .................................................. 	23
3.5.	Diagram Alir Data ...........................  .................................................. 23
3.5.1. Diagram Context ............. ........................................................ 24
3.5.2. Diagram Alir Data Level 0 ........................................................ 24
3.5.3.  Diagram Alir Data Level 1 Proses 1......................................... 27
3.5.4.  Diagram Alir Data Level 1 Proses 2 ........................................ 27
3.5.5.  Diagram Alir Data Level 1 Proses 3 ........................................ 28
3.5.6.  Diagram Alir Data Level 1 Proses 4......................................... 29
3.5.7.  Diagram Alir Data Level 1 Proses 5......................................... 29
3.5.8.  Diagram Alir Data Level 1 Proses 6......................................... 30
3.5.9.  Diagram Alir Data Level 1 Proses 7......................................... 30
3.6.	Rancangan Basis Data ...................................................................... 31
3.6.1.  Tabel Supplier ......................................................................... 31
3.6.2.  Tabel Transbeli ....................................................................... 31
3.6.3.  Tabel Det_Transbeli ................................................................ 32
3.6.4.  Tabel Jenis Barang .................................................................. 33
3.6.5.  Tabel Barang ........................................................................... 33
3.6.6.  Tabel Transjual ........................................................................ 34
3.6.7.  Tabel Det_Transjual................................................................. 34
3.6.8.  Tabel Pegawai  ....................................................................... 35
3.7.	Relasi Tabel  ......................................................................................	36
3.8.	Diagram Alir Sistem ............................................................................ 38
3.9.	Perancangan Form Masukan (input) .................................................. 40
3.9.1.  Rancangan Form Setting Koneksi Database .......................... 40
3.9.2.  Rancangan Form Login ...................... .................................... 40
3.9.3.  Rancangan Form Data Supplier .............................................. 41
3.9.4.  Rancangan Form Data Jenis Barang ...................................... 42
3.9.5.  Rancangan Form Data Barang ...............................................	42
3.9.6.  Rancangan Form Data Pegawai ............................................. 43
3.9.7.  Rancangan Form Data Transaksi Pembelian ......................... 44
3.9.8.  Rancangan Form Pemilihan Barang Beli ................................ 44
3.9.9.  Rancangan Form Data Transaksi Penjualan........................... 45
3.9.10. Rancangan Form Pemilihan Barang Jual .............................. 46
3.9.11. Rancangan Form Pencarian Data Barang.............................. 47
3.9.12. Rancangan Form Laporan Pembelian Per Transaksi ............ 48
3.9.13. Rancangan Form Laporan Pembelian Per Periode ............... 48
3.9.14. Rancangan Form Laporan Barang Per Jenis ......................... 49
3.9.15. Rancangan Form Laporan Penjualan  Per Transaksi .............49
3.9.16. Rancangan Form Laporan Penjualan Per Periode ................ 50
3.10.	Perancangan Keluaran (Output) ........................................................ 50
3.10.1. Rancangan Laporan Data Supplier......................................... 50
3.10.2. Rancangan Laporan Pembelian Per Transaksi ...................... 51
3.10.3. Rancangan Laporan Pembelian  Per Periode ........................ 51
3.10.4. Rancangan Laporan Data Jenis Barang .................................52
3.10.5.Rancangan Laporan Data Barang Per Jenis dan Stok Barang.52
3.10.6. Rancangan Laporan Data Stok Barang Minimal .....................53
3.10.7. Rancangan Laporan Data Barang Terlaris ............................ 53
3.10.8. Rancangan Laporan Penjualan  Per Transaksi ..................... 54
3.10.9. Rancangan Laporan Penjualan  Per Periode ......................... 55
3.10.10. Rancangan Laporan Data Pegawai ..................................... 55

BAB IV PEMBAHASAN  .........................................................................................	56
4.1.	Spesifikasi Program ........................................................................... 56
4.2.	Form Setting Koneksi Database Server ............................................. 60
4.3.	Menu Utama  ...................................................................................... 62
4.4.	Menu Login  ........................................................................................	64
4.5.	Sub Menu Data Supplier ....................................................................	67
4.6.	Sub Menu Data Jenis Barang ............................................................	70
4.7.	Sub Menu Data Barang .......................................................................71
4.8.	Sub Menu Data Pegawai ...................................................................	71
4.9.	Sub Menu Transaksi Pembelian .......................................................	72
4.10.	Sub Menu Transaksi Penjualan  .......................................................	76
4.11.	Sub Menu Pencarian  Data Barang ................................................... 77
4.12.	Sub Menu Tentang K-fe Swalayan .................................................... 80
4.13.	Sub Menu Tentang Programer .......................................................... 80
4.14.	Sub Menu Transaksi Pembelian Per Nota ......................................... 81
4.15.	Sub Menu Transaksi Pembelian Per Periode .................................... 82
4.16.	Sub Menu Data Barang Per Jenis ..................................................... 83
4.17.	Sub Menu Transaksi Penjualan Per Nota .......................................... 83
4.18.	Sub Menu Transaksi Penjualan Per Periode ..................................... 84
4.19.	Sub Menu Laporan Seluruh Data Supplier ........................................	85
4.20.	Sub Menu Laporan Pembelian Per No Transaksi .............................. 85
4.21.	Sub Menu Laporan Pembelian Per Periode ....................................... 86
4.22.	Sub Menu Laporan Seluruh Data Jenis Barang ................................. 87
4.23.	Sub Menu Laporan Data Barang Per Jenis .......................................	88
4.24.	Sub Menu Laporan Stok  Barang Minimal  .......................................	88
4.25.	Sub Menu Laporan Barang Terlaris ...................................................	89
4.26.	Sub Menu Laporan Penjualan  Per No Transaksi .............................. 90
4.27.	Sub Menu Laporan Penjualan Per Periode ........................................ 91
4.28.	Sub Menu Laporan Seluruh Data Pegawai ...... ................................. 92

BAB V PENUTUP  .................................................................................................. 94
5.1.	KESIMPULAN  ................................................................................... 94
5.2. 	SARAN  .............................................................................................. 95

DAFTAR PUSTAKA  ............................................................................................... 96

DAFTAR TABEL

Halaman
Tabel 3.6.1. Struktur Tabel supllier  .......................................................................	31
Tabel 3.6.2. Struktur Tabel  transbeli .....................................................................	32
Tabel 3.6.3. Struktur Tabel  det_transbeli .............................................................	32
Tabel 3.6.4. Struktur Tabel jenis_barang  ..............................................................	33
Tabel 3.6.5. Struktur Tabel barang  ........................................................................ 33
Tabel 3.6.6. Struktur Tabel transjual ......................................................................	34
Tabel 3.6.7. Struktur Tabel det_transjual ............................................................... 	35
Tabel 3.6.8. Struktur Tabel pegawai ...................................................................... 	35

DAFTAR GAMBAR

Halaman
Gambar 3.1. Diagram Context ..............................................................................	24
Gambar 3.2. Diagram Alir Data Level 0 ................................................................	25
Gambar 3.3. Diagram Alir Data Level 1 Proses 1 .................................................	27
Gambar 3.4. Diagram Alir Data Level 1 Proses 2 .................................................	27
Gambar 3.5. Diagram Alir Data Level 1 Proses 3 .................................................	28
Gambar 3.6. Diagram Alir Data Level 1 Proses 4 .................................................	29
Gambar 3.7. Diagram Alir Data Level 1 Proses 5 .................................................	29
Gambar 3.8. Diagram Alir Data Level 1 Proses 6 .................................................	30
Gambar 3.9. Diagram Alir Data Level 1 Proses 7 .................................................	30
Gambar 3.10. Relasi Tabel ...................................................................................	36
Gambar 3.11. Diagram Alir Sistem ........................................................................	38
Gambar 3.12. Rancangan Form Setting Koneksi Database .................................	40
Gambar 3.13. Rancanagn Form Login .................................................................	41
Gambar 3.14. Rancangan Form Data Supplier .....................................................	41
Gambar 3.15. Rancangan Form Data Jenis Barang .............................................. 42
Gambar 3.16. Rancangan Form Data Barang ........................................................ 43
Gambar 3.17. Rancangan Form Data Pegawai ..................................................... 43
Gambar 3.18. Rancangan Form Transaksi Pembelian .......................................... 44
Gambar 3.19. Rancangan Form Pemilihan Barang Beli ........................................ 45
Gambar 3.20. Rancangan Form Transaksi Penjualan ........................................... 46
Gambar 3.21. Rancangan Form Pemilihan Barang Jual ........................................ 47
Gambar 3.22. Rancangan Form Pencarian Data Barang ...................................... 47
Gambar 3.23. Rancangan Form Laporan Pembelian Per Transaksi ..................... 48
Gambar 3.24. Rancangan Form Laporan Pembelian Per Periode ........................ 48
Gambar 3.25. Rancangan Form Laporan Barang Per Jenis .................................. 49
Gambar 3.26. Rancangan Form Laporan Penjualan  Per Transaksi ......................49
Gambar 3.27. Rancangan Form Laporan Penjualan Per Periode ......................... 50
Gambar 3.28. Rancangan Laporan  Data Supplier................................................. 50
Gambar 3.29. Rancangan Laporan Pembelian  Per Transaksi .............................. 51
Gambar 3.30. Rancangan Laporan Pembelian  Per Periode ................................. 52
Gambar 3.31. Rancangan Laporan Data Jenis Barang ......................................... 52
Gambar 3.32. Rancangan Laporan Data Barang Per Jenis ................................... 53
Gambar 3.33. Rancangan Laporan Data Stok Barang Minimal ............................. 53
Gambar 3.34. Rancangan Laporan Data Barang Terlaris ...................................... 54
Gambar 3.35. Rancangan Laporan Penjualan  Per Transaksi ............................... 54
Gambar 3.36. Rancangan Laporan Penjualan  Per Periode .................................. 55
Gambar 3.37. Rancangan Laporan Data Pegawai ................................................. 55
Gambar 4.2.1. Form Setting Koneksi Database ..................................................... 61
Gambar 4.2.2. Kotak Pesan pada Form Setting Koneksi Database Server ........... 62
Gambar 4.3.1. Tampilan Menu Utama Program ..................................................... 63	
Gambar 4.4.1. Form Login ...................................................................................... 65	
Gambar 4.4.2. Kotak Pesan Koneksi Login ............................................................ 66	
Gambar 4.4.3. Kotak Pesan Kesalahan Login ....................................................... 66	
Gambar 4.5.1. Form Data Supplier ........................................................................	68
Gambar 4.5.2. Kotak Pesan Kesalahan Penyimpanan ..........................................	69
Gambar 4.5.3. Kotak Pesan Data Tersimpan ........................................................	69
Gambar 4.5.4. Kotak Pesan Update ............. ........................................................	70
Gambar 4.5.5. Kotak Pesan Hapus .............. ........................................................	70
Gambar 4.6.1. Form Data Jenis Barang ................................................................	70
Gambar 4.7.1. Form Data Barang ...........................................................................71
Gambar 4.8.1. Form Data Pegawai ........................................................................	72
Gambar 4.9.1. Form Transaksi Pembelian ............................................................	73
Gambar 4.9.2. Form Pemilihan Barang ..................................................................	74
Gambar 4.9.3. Kotak Pesan Data Sudah Tersimpan .............................................	76
Gambar 4.10.1. Form Transaksi Penjualan  ..........................................................	76
Gambar 4.10.2. Kotak Pesan Kesalahan Menginputkan Kode Barang .................	77
Gambar 4.10.3. Kotak Pesan Kesalahan Menginputkan Jumlah Jual ...................	77
Gambar 4.11.1. Pencarian  Data Barang ............................................................... 79
Gambar 4.11.2. Kotak Pesan Tidak Ada Data Yang Menyerupai .......................... 79
Gambar 4.11.3. Kotak Pesan Data Tabel Barang Kosong ..................................... 79
Gambar 4.12.1. Form Info Tentang K-fe Swalayan ................................................ 80
Gambar 4.13.1. Form Informasi Tentang Programer .............................................. 81
Gambar 4.14.1. Form Transaksi Pembelian Per Nota ............................................ 82
Gambar 4.15.1. FormTransaksi Pembelian Per Periode ........................................ 82
Gambar 4.16.1. Form Laporan Barang Per Jenis ................................................... 83
Gambar 4.17.1. Form Transaksi Penjualan Per Nota ............................................. 84
Gambar 4.18.1. Form Transaksi Penjualan Per Periode ........................................ 84
Gambar 4.19.1. Laporan Seluruh Data Supplier ...................................................	85
Gambar 4.20.1. Laporan Pembelian Per No Transaksi .......................................... 86
Gambar 4.21.1. Laporan Pembelian Per Periode ................................................... 87
Gambar 4.22.1. Laporan Seluruh Data Jenis Barang ............................................. 87
Gambar 4.23.1. Laporan Seluruh Data Barang Per Jenis ......................................	88
Gambar 4.24.1. Laporan Stok  Barang Minimal  ....................................................	89
Gambar 4.25.1. Laporan Barang Terlaris ..............................................................	90
Gambar 4.26.1. Laporan Penjualan  Per No Transaksi .......................................... 91
Gambar 4.27.1. Laporan Penjualan Per Periode .................................................... 92
Gambar 4.28.1. Laporan Seluruh Data Pegawai .................................................... 93