ANALISIS DAN PERANCANGAN SISTEM BASIS DATA PENJUALAN, PEMBELIAN DAN PERSEDIAAN PADA PT. HARRISMA AGUNG JAYA
SKRIPSI
Oleh
HENDY CAHYADI
1000857411
CHANDRA
1000857576
WIDHI SAPTA
1000858351
Kelas/Kelompok
: 08PCT/ 04
Universitas Bina Nusantara Jakarta 2010 i
ANALISIS DAN PERANCANGAN SISTEM BASIS DATA PENJUALAN, PEMBELIAN DAN PERSEDIAAN PADA PT. HARRISMA AGUNG JAYA
SKRIPSI Diajukan sebagai salah satu syarat untuk gelar kesarjanaan pada Jurusan Teknik Informatika Jenjang Pendidikan Strata-1
Oleh
HENDY CAHYADI
1000857411
CHANDRA
1000857576
WIDHI SAPTA
1000858351
Kelas/Kelompok
: 08PCT/ 04
Universitas Bina Nusantara Jakarta 2010 ii
ANALISIS DAN PERANCANGAN SISTEM BASIS DATA PENJUALAN, PEMBELIAN DAN PERSEDIAAN PADA PT. HARRISMA AGUNG JAYA
SKRIPSI
Disusun oleh :
Hendy Cahyadi
Chandra
Widhi Sapta
1000857411
1000857576
1000858351
Disetujui oleh : Pembimbing
Muh. Tassim Billah, Ir., M.Sc. Kddsn : D0503
Universitas Bina Nusantara Jakarta 2009-2010 iii
PERNYATAAN Dengan ini kami, Nama
: Hendy Cahyadi
NIM
: 1000857411
Nama
: Chandra
NIM
: 1000857576
Nama
: Widhi Sapta
NIM
: 1000858351
Judul skripsi : ANALISIS DAN PERANCANGAN SISTEM BASIS DATA PENJUALAN, PEMBELIAN DAN PERSEDIAAN PADA PT HARRISMA AGUNG JAYA
Memberikan kepada Universitas Bina Nusantara hak non-eksklusif untuk menyimpan, memperbanyak, dan menyebarluaskan skripsi karya kami, secara keseluruhan atau hanya sebagian atau hanya ringkasannya saja, dalam bentuk format tercetak dan atau elektronik.
Menyatakan bahwa kami, akan mempertahankan hak exclusive kami, untuk menggunakan seluruh atau sebagian isi skripsi kami, guna pengembangan karya di masa depan, misalnya bentuk artikel, buku, perangkat lunak, ataupun sistem informasi.
Jakarta, 12 Juli 2010
Hendy Cahyadi
Chandra v
Widhi Sapta
PRAKARTA
Segala puji dan syukur kami panjatkan kepada Tuhan Yang Maha Esa atas segala rahmat dan karunia-Nya, sehingga penulis dapat menyelesaikan skripsi yang berjudul “Analisis dan Perancangan Sistem Basis Data Penjualan, Pembelian dan Persediaan pada PT HARRISMA AGUNG JAYA” tepat pada waktunya. Skripsi ini merupakan karya ilmiah yang disusun sebagai salah satu syarat kelulusan dalam jenjang pendidikan S1 (Strata Satu) jurusan Teknik Informatika di Binus University.
Penulis menyadari bahwa tanpa adanya bantuan dan bimbingan dari berbagai pihak, penulisan skripsi ini tidak akan selesai. Untuk itu pada kesempatan ini penulis ingin mengucapkan terima kasih yang sebesa-besarnya kepada :
1. Bapak Prof. Dr. Ir. Harjanto Prabowo, M.M., selaku Rektor Binus University. 2. Bapak Ir. Sablin Yusuf., M.Sc., M.CompSc., selaku Dekan Fakultas Ilmu Komputer Binus University. 3. Bapak Freddy Purnomo, S.Kom., M.Kom., selaku Ketua Jurusan Teknik Informatika Binus University. 4. Bapak Muh. Tassim Billah, Ir., M.Sc., selaku dosen pembimbing yang telah memberikan bimbingan dan pengarahan yang sangat membantu dalam penyusunan skripsi ini. 5. Seluruh dosen dan karyawan Universitas Bina Nusantara yang telah memberikan berbagai bantuan dan bimbingan dari awal kuliah. 6. Ibu Christine, selaku HRD Manager PT. Harrisma Agung Jaya vii
7. Keluarga kami yang telah memberikan dukungan doa, moral serta materi selama penyusunan skripsi ini. 8. Teman-teman, sahabat dan banyak pihak yang tidak dapat disebutkan satu per satu yang telah membantu dan memberikan dukungan moral dan semangat sehingga skripsi ini bisa selesai tepat pada waktunya
Penulis menyadari bahwa dalam penyusunan skripsi ini masih jauh dari kesempurnaan, mengingat keterbatasan kemampuan dan pengetahuan yang dimiliki oleh penulis. Oleh karena itu, penulis sangat mengharapkan kritik dan saran yang membangun dari berbagai pihak.
Akhir kata, penulis ingin mengungkapkan harapannya yang lain, yaitu harapan agar skripsi ini dapat bermanfaat bagi siapa saja yang membutuhkannya.
Jakarta, 12 Juni 2010
Penulis
viii
DAFTAR ISI
Halaman Judul Luar ............................................................................................................. i Halaman Judul Dalam ......................................................................................................... ii Halaman Persetujuan Hardcover........................................................................................ iii Halaman Pernyataan Dewan Penguji ................................................................................. iv Halaman Pemberian Hak Cipta Non Eksklusif .................................................................. v Abstrak ............................................................................................................................... vi Prakata............................................................................................................................... vii Daftar Isi ............................................................................................................................ ix Daftar Tabel .................................................................................................................... xvii Daftar Gambar.................................................................................................................. xix Daftar Lampiran ............................................................................................................. xxiv
BAB 1 PENDAHULUAN ............................................................................................... 1 1.1. Latar Belakang ............................................................................................. 1 1.2. Ruang Lingkup............................................................................................. 2 1.3. Tujuan dan Manfaat ..................................................................................... 3 1.4. Metode Perancangan .................................................................................... 4 1.5. Sistematika Penulisan .................................................................................. 5
ix
BAB 2 LANDASAN TEORI .......................................................................................... 6 2.1. Pendekatan Basisdata ................................................................................... 6 2.1.1. Pengertian Basisdata ........................................................................ 6 2.1.2. Sistem Manajemen Basisdata .......................................................... 6 2.1.2.1. Fasilitas Sistem Basis Data ............................................... 7 2.1.2.2. Fungsi Sistem Basis Data.................................................. 8 2.1.2.3. Komponen-komponen dari Sistem Basis Data .................. 9 2.1.2.4. Karakteristik Sistem Manajemen Basis Data .................. 11 2.1.2.5. Keuntungan Sistem Manajemen Basis Data ................... 12 2.1.2.6. Kerugian Sistem Manajemen Basis Data ........................ 15 2.1.3. Structure Query Language ............................................................. 17 2.1.3.1. Data Definition Language .............................................. 17 2.1.3.2. Data Manipulation Language ......................................... 18 2.1.4. Fourth Generation Language ........................................................ 19 2.1.5. Siklus Hidup Aplikasi Basisdata .................................................... 20 2.1.5.1. Database planning ......................................................... 21 2.1.5.2. System definition ............................................................ 22 2.1.5.3. Requirement collection and analysis ............................. 22 2.1.5.4. Database design ............................................................. 23 2.1.5.5. DBMS Selection............................................................. 24 2.1.5.6. Application Design......................................................... 24
x
2.1.5.7. Prototyping .................................................................... 27 2.1.5.8. Implementation .............................................................. 27 2.1.5.9. Data conversion and loading ......................................... 28 2.1.5.10. Testing ............................................................................ 28 2.1.5.11. Operational Maintenance .............................................. 29 2.1.6. Entity-Relationship Modeling ........................................................ 29 2.1.6.1. Entity types ...................................................................... 30 2.1.6.2. Relationship types ........................................................... 31 2.1.6.3. Attibutes .......................................................................... 33 2.1.6.4. Keys ................................................................................. 34 2.1.6.5. Structural Constraint ...................................................... 36 2.1.7. Metodologi Perancangan Basisdata ............................................... 39 2.1.7.1. Perancangan Konseptual ................................................. 39 2.1.7.2. Perancangan Logikal ....................................................... 42 2.1.7.3. Perancangan Fisikal ........................................................ 47 2.1.8. Normalisasi .................................................................................... 51 2.2. Terminologi dalam Bidang Penjualan, Pembelian, dan Persedian ............ 53 2.2.1. Penjualan ........................................................................................ 53 2.2.1.1. Fungsi yang terkait dalam penjualan .............................. 54 2.2.1.2. Jaringan prosedur yang membentuk sistem penjualan.... 55 2.2.1.3. Dokumen pada sistem penjualan..................................... 56
xi
2.2.2. Pembelian ....................................................................................... 57 2.2.2.1. Fungsi yang terkait dalam pembelian ............................. 57 2.2.2.2. Jaringan prosedur yang membentuk sistem pembelian .. 59 2.2.2.3. Dokumen pada sistem pembelian ................................... 60 2.2.3. Persediaan ...................................................................................... 61 2.2.3.1. Fungsi yang terkait dalam persediaan ............................. 61 2.2.3.2. Jaringan prosedur yang membentuk sistem persediaan .. 62 2.2.3.3. Dokumen pada sistem persediaan ................................... 63
BAB 3 ANALISIS SISTEM YANG SEDANG BERJALAN .................................... 64 3.1. Tentang Perusahaan ................................................................................... 64 3.1.1. Sejarah Perusahaan ........................................................................ 64 3.1.2. Visi dan Misi Perusahaan............................................................... 65 3.1.3. Kegiatan Bisnis Perusahaan ........................................................... 66 3.1.4. Struktur Organisasi ........................................................................ 66 3.1.5. Pembagian Tugas dan Tanggung Jawab ........................................ 67 3.2. Gambaran Sistem ....................................................................................... 70 3.2.1. Data Flow Diagram ....................................................................... 70 3.2.2. Prosedur di Dalam Sistem .............................................................. 72 3.2.2.1. Prosedur Pembelian ........................................................ 72 3.2.2.2. Prosedur Persediaan ........................................................ 74 3.2.2.3. Prosedur Penjualan.......................................................... 76 xii
3.2.2.4. Prosedur Pembuatan Flow Invoice ................................. 78 3.3. Analisis Kebutuhan Informasi ................................................................... 80 3.3.1. Mission Statement .............................................................. 80 3.3.2. Mission Objective............................................................... 80 3.3.3. Analysis User View ............................................................ 82 3.3.4. User Requirement Specification ........................................ 84 3.3.5. Transaction Requirement ................................................... 86 3.4. Permasalahan yang Dihadapi ..................................................................... 88 3.5. Solusi Pemecahan Masalah ........................................................................ 89
BAB 4 PERANCANGAN DAN IMPLEMENTASI.................................................... 90 4.1. Perancangan Basisdata ............................................................................... 90 4.1.1. Perancangan Basisdata Konseptual................................................ 90 4.1.1.1. Identifikasi tipe entitas .................................................... 91 4.1.1.2. Identifikasi tipe relasional ............................................... 93 4.1.1.3. Mengidentifikasi dan menghubungkan atribut dengan tipe entitas atau hubungan tertentu ................................ 96 4.1.1.4. Identifikasi domain atribut ............................................ 102 4.1.1.5. Menidentifikasi candidate, primary, dan alternate keys ............................................................................... 106 4.1.1.6. Mempertimbangkan menggunakan konsep model yang lebih tinggi (Enhanced Modeling Concepts)optional .. 109
xiii
4.1.1.7. Memeriksa redundansi pada model konseptual ............ 109 4.1.1.8.
Melakukan Validasi model data konseptual dengan
transaksi user .............................................................................. 111 4.1.1.9. Melakukan review model data konseptual dengan user 114 4.1.2. Perancangan Basisdata Logikal ................................................... 115 4.1.2.1. Penurunan relasi untuk model data logikal ................... 116 4.1.2.1.1. Strong & Weak entity types ......................... 116 4.1.2.1.2. One-to-many binary relationship types....... 118 4.1.2.1.3. One-to-one binary relationship types ......... 127 4.1.2.1.4. Superclass/ subclass relationship types ...... 127 4.1.2.1.5. Many-to-many binary relationship types .... 128 4.1.2.1.6. Multi-value Attribute ................................... 130 4.1.2.2. Validasi relasi menggunakan normalisasi ..................... 136 4.1.2.3. Validasi relasi terhadap transaksi user .......................... 156 4.1.2.4. Memeriksa integrity constraints ................................... 161 4.1.2.5. Melakukan review model data logikal dengan user ...... 170 4.1.2.6. Mempertimbangkan perkembangan di masa depan ...... 170 4.1.2.7. Pemilihan Database Management System .................... 170 4.1.3. Perancangan Basisdata Fisikal ..................................................... 172 4.1.3.1. Menerjemahkan model data logikal untuk DBMS yang digunakan ..................................................................... 172 4.1.3.1.1. Merancang relasi dasar................................ 172
xiv
4.1.3.1.2. Merancang representasi derived data ......... 194 4.1.3.1.3. Merancang general constraints................... 194 4.1.3.2. Merancang Organisasi File dan Index........................... 201 4.1.3.2.1. Menganalisa transaksi ................................. 201 4.1.3.2.2. Memilih organisasi file ............................... 218 4.1.3.2.3. Memilih index ............................................. 219 4.1.2.3.4. Memperkirakan kebutuhan disk space ........ 222 4.1.3.3. Merancang user views ................................................... 235 4.1.3.4. Merancang mekanisme keamanan ................................ 238 4.2. Perancangan Aplikasi............................................................................... 240 4.2.1. Struktur Menu .............................................................................. 240 4.2.2. Perancangan Input dan Output ..................................................... 241 4.2.2.1. Perancangan input ......................................................... 241 4.2.2.2. Perancangan output ....................................................... 249 4.2.3. State Transition Diagram ............................................................ 252 4.2.4. Spesifikasi Proses/ Modul ............................................................ 265 4.3. Implementasi ............................................................................................ 278 4.3.1. Spesifikasi Perangkat Keras ......................................................... 278 4.3.2. Spesifikasi Perangkat Lunak ........................................................ 279 4.3.3. Jadwal Implementasi .................................................................... 279 4.3.4. Petunjuk Pemakaian Sistem ......................................................... 280
xv
4.3.5. Evaluasi Sistem ............................................................................ 297
BAB 5 SIMPULAN DAN SARAN............................................................................. 299 5.1. Simpulan .................................................................................................. 299 5.2. Saran ........................................................................................................ 300
DAFTAR PUSTAKA .................................................................................................... 301 RIWAYAT HIDUP ....................................................................................................... 302 LAMPIRAN-LAMPIRAN ............................................................................................. L1 SURAT SURVEY
xvi
DAFTAR TABEL
Tabel 3.1
Analysis User View ............................................................................... 82
Tabel 3.2
Tabel Cross Reference dari Analysis User View...................................83
Tabel 4.1
Kamus Data Entity ................................................................................ 91
Tabel 4.2
Menentukan Multiplicity dari Tipe Relasional ...................................... 94
Tabel 4.3
Kamus Data Atribut ............................................................................... 96
Tabel 4.4
Tabel Domain Attribut……………………………………………….102
Tabel 4.5
Mengidentifikasi Candidate Key dan Primary Key............................. 106
Table 4.1.2.1 Tabel dokumentasi relasi dan atribut foreign key pada tahap penurunan relasi model data logika ....................................................................... 134 Tabel 4.1.2.2 Tabel Relasi dengan Referential Integrity........................................... 168 Tabel 4.1.3.1 Tabel Analisis Transaksi ..................................................................... 204 Tabel 4.1.3.2 Tabel Analisis Transaksi (Lanjutan…) ............................................... 206 Tabel 4.1.3.3 Tabel Analisis Transaksi (Lanjutan…) ............................................... 207 Tabel 4.1.3.4 Tabel Analisis Transaksi (Lanjutan…) ............................................... 208 Tabel 4.1.3.5 Tabel Analisis Transaksi (Lanjutan…) ............................................... 209 Tabel 4.1.3.6 Tabel Analisis Transaksi (Lanjutan…) ............................................... 210 Tabel 4.1.3.7 Tabel Analisis Transaksi (Lanjutan…) ............................................... 212 Tabel 4.1.3.8 Tabel Analisis Transaksi (Lanjutan…) ............................................... 213 Tabel 4.1.3.9 Tabel Analisis Transaksi (Lanjutan…) ............................................... 214 Tabel 4.1.3.10 Tabel Analisis Transaksi (Lanjutan…) ............................................... 215 Tabel 4.1.3.11 Tabel Analisis Transaksi (Lanjutan…) ............................................... 217 Tabel 4.1.3.12 Tabel Analisis Transaksi (Lanjutan…) ............................................... 218 Tabel 4.1.3.13 Tabel Index ......................................................................................... 222 Tabel 4.1.3.14 Estimasi Disk staff .............................................................................. 223 Tabel 4.1.3.15 Estimasi Disk customer....................................................................... 223 Tabel 4.1.3.16 Estimasi Disk produk .......................................................................... 223 Tabel 4.1.3.17 Estimasi Disk company....................................................................... 224 Tabel 4.1.3.18 Estimasi Disk jabatan .......................................................................... 224 xvii
Tabel 4.1.3.19 Estimasi Disk jenis_produk ................................................................ 224 Tabel 4.1.3.20 Estimasi Disk jenis_supplier ............................................................... 224 Tabel 4.1.3.21 Estimasi Disk supplier ........................................................................ 225 Tabel 4.1.3.22 Estimasi Disk user............................................................................... 225 Tabel 4.1.3.23 Estimasi Disk Pembelian .................................................................... 225 Tabel 4.1.3.24 Estimasi Disk Pemesanan_customer ................................................... 226 Tabel 4.1.3.25 Estimasi Disk Pemesanan_Supplier .................................................... 226 Tabel 4.1.3.26 Estimasi Disk Telp_company ............................................................. 226 Tabel 4.1.3.27 Estimasi Disk Telp_customer ............................................................. 227 Tabel 4.1.3.28 Estimasi Disk Telp_staff ..................................................................... 227 Tabel 4.1.3.29 Estimasi Disk Telp_supplier ............................................................... 227 Tabel 4.1.3.30 Estimasi Disk deliver .......................................................................... 228 Tabel 4.1.3.31 Estimasi Disk purchase invoice .......................................................... 228 Tabel 4.1.3.32 Estimasi Disk purchase ....................................................................... 229 Tabel 4.1.3.33 Estimasi Disk receive report ............................................................... 229 Tabel 4.1.3.34 Estimasi Disk sales ............................................................................. 229 Tabel 4.1.3.35 Estimasi Disk sales invoice ................................................................. 230 Tabel 4.1.3.36 Estimasi Disk purchase invoice .......................................................... 230 Tabel 4.1.3.37 Estimasi Disk deliver .......................................................................... 230 Tabel 4.1.3.38 Estimasi Disk detail_purchase ............................................................ 231 Tabel 4.1.3.39 Estimasi Disk detail_receive report .................................................... 231 Tabel 4.1.3.40 Estimasi Disk detail_sales................................................................... 231 Tabel 4.1.3.41 Estimasi Disk detail_SI ....................................................................... 232 Tabel 4.1.3.42 Estimasi Disk Sales retur .................................................................... 232 Tabel 4.1.3.43 Estimasi Disk Purchase retur .............................................................. 233 Tabel 4.1.3.44 Estimasi Disk detail_Sr ....................................................................... 233 Tabel 4.1.3.45 Estimasi Disk detail_Pr ....................................................................... 233 Tabel 4.1.3.46 Total Keseluruhan Disk Space ............................................................ 234 Tabel 4.1.3.47 Tabel Analisis Mekanisme Keamanan ................................................ 239 Tabel 4.3.3 Jadwal Implementasi ............................................................................... 279
xviii
DAFTAR GAMBAR
Gambar 2.1
Siklus Aplikasi Basis Data .................................................................... 20
Gambar 2.2
Representasi diagramatik dari tipe entity pegawai dan cabang ............. 30
Gambar 2.3
Representasi diagram tipe entity kuat dan tipe entity lemah ................. 31
Gambar 2.4
Representasi diagramatik dari relationship ........................................... 31
Gambar 2.5
Representasi diagram derajat tiga dari suatu tipe relationship .............. 32
Gambar 2.6
Representasi diagram recursive relationship dan nama peran ............... 33
Gambar 2.7
Representasi diagram entity dengan dua relationship berbeda beserta nama peran............................................................................................. 33
Gambar 2.8
Representasi diagram entity pegawai dan cabang beserta atribut dan primary key-nya..................................................................................... 35
Gambar 2.9
Semantic net menunjukkan dua occurrence dari relationship pegawai mengatur cabang .................................................................................... 36
Gambar 2.10 Multiplicity dari relationship one-to-one (1:1) ...................................... 37 Gambar 2.11 Semantic net menunjukkan tiga occurrence dari relationship Staff Melihat PropertyForRent .................................................................................... 37 Gambar 2.12 Multiplicity dari relationship one-to-many (1:*) ................................... 38 Gambar 2.13 Semantic net menunjukkan empat occurrence dari relationship koran mengiklankan propertyForRent ............................................................. 38 Gambar 2.14 Multiplicity dari relationship many-to-many (*:*)................................ 39 Gambar 3.1
Struktur Organisasi PT. Harrisma Agung Jaya ..................................... 67
Gambar 3.2
Diagram Konteks Sistem Yang Sedang Berjalan .................................. 70
Gambar 3.3
Diagram Nol .......................................................................................... 71
Gambar 3.4
Flow Pembelian ..................................................................................... 73
Gambar 3.5
Flow Persediaan..................................................................................... 75
Gambar 3.6
Flow Penjualan ...................................................................................... 77
Gambar 3.7
Flow Sales Invoice ................................................................................ 79
Gambar 3.8
Overlapping user view ...........................................................................83
Gambar 4.1
Entitas Relationship Diagram (ERD) Konseptual ................................. 95
Gambar 4.2
ERD Konseptual dengan Primary Key ................................................ 108 xix
Gambar 4.3
Hubungan One to One (1..1) antara Trheader_rr dengan Trheader_purchase .............................................................................. 109
Gambar 4.4
Entity Relationship Diagram (ERD) Setelah Pengecekan Redundansi110
Gambar 4.5
Validasi Model Data Konseptual terhadap Transaksi Pengguna. ....... 113
Gambar 4.1.2.1 Relasi Kd_Customer ke Sales ........................................................... 118 Gambar 4.1.2.2 Relasi Kd_Customer ke Deliver ........................................................ 119 Gambar 4.1.2.3 Relasi Kd_Customer ke Sales Invoice .............................................. 119 Gambar 4.1.2.4 Relasi Kd_Custeomer ke Pemesanan_customer ............................... 119 Gambar 4.1.2.5 Relasi Kd_Customer ke Sales retur................................................... 120 Gambar 4.1.2.6 Relasi Username ke deliver ............................................................... 120 Gambar 4.1.2.7 Relasi Username ke Pemesanan_Customer ...................................... 120 Gambar 4.1.2.8 Relasi Username ke Sales retur ......................................................... 121 Gambar 4.1.2.9 Relasi Kd_Jabatan ke Staff ............................................................... 121 Gambar 4.1.2.10 Relasi Username ke Sales Invoice .................................................. 121 Gambar 4.1.2.11 Relasi Username ke Purchase ......................................................... 122 Gambar 4.1.2.12 Relasi Username ke Pemesanan_Supplier ...................................... 122 Gambar 4.1.2.13 Relasi Kd_Staff ke Pembelian......................................................... 122 Gambar 4.1.2.14 Relasi Username ke Purchase Invoice ............................................ 123 Gambar 4.1.2.15 Relasi Username ke Sales ............................................................... 123 Gambar 4.1.2.16 Relasi Kd_ Supplier ke Purchase Invoice ....................................... 123 Gambar 4.1.2.17 Relasi Kd_Supplier ke Purchase ..................................................... 124 Gambar 4.1.2.18 Relasi Kd_Supplier ke Pembelian ................................................... 124 Gambar 4.1.2.19 Relasi Kd_Supplier ke Pemesanan_Supplier .................................. 124 Gambar 4.1.2.20 Relasi Kd_Supplier ke Purchase retur............................................. 125 Gambar 4.1.2.21 Relasi Kd_Supllier ke Purchase Invoice ......................................... 125 Gambar 4.1.2.22 Relasi Kd_Produk ke Pemesanan_Supplier .................................... 125 Gambar 4.1.2.23 Relasi Kd_Produk ke Pemesanan_Customer .................................. 126 Gambar 4.1.2.24 Relasi Kd_Sales ke Deliver ............................................................. 126 Gambar 4.1.2.25 Relasi Kd_company ke purchase .................................................... 126 Gambar 4.1.2. 26 Relasi Kd_Purchase ke Receive report .......................................... 127 Gambar 4.1.2.27 Relasi Username ke staff ................................................................. 127 xx
Gambar 4.1.2.28 Hubungan Ms_Produk dengan sales ............................................... 128 Gambar 4.1.2.29 Hubungan Ms_Produk dengan Receive report................................ 128 Gambar 4.1.2.30 Hubungan Ms_Produk dengan Purchase retur ................................ 129 Gambar 4.1.2.31 Hubungan Ms_Produk dengan Sales retur ...................................... 129 Gambar 4.1.2.32 Multivalued Attribute Telp_Staff .................................................... 130 Gambar 4.1.2.33 Multivalued Attribute Telp_Customer ............................................ 130 Gambar 4.1.2.34 Multivalued Attribute Telp_Supplier .............................................. 130 Gambar 4.1.2.35 Multivalued Attribute Telp_company ............................................. 131 Gambar 4.1.2.36 ERD Logikal ................................................................................... 135 Gambar 4.1.2.37 ERD Logikal Setelah Pengecekkan Normalisasi ............................ 155 Gambar 4.1.2.38 ERD Logical dengan Trasaksi User ................................................ 160 Gambar 4.1.2.39 ERD Logikal Referential Integrity .................................................. 169 Gambar 4.2.1 Struktur Menu...................................................................................... 240 Gambar 4.2.2 Rancangan Layar Login ....................................................................... 241 Gambar 4.2.3 Rancangan Layar Utama ...................................................................... 241 Gambar 4.2.4 Rancangan layar Master Customer ...................................................... 242 Gambar 4.2.5 Rancangan Layar Master Sales Order ................................................. 242 Gambar 4.2.6 Rancangan Layar Master Delivery Order ............................................ 243 Gambar 4.2.7 Rancangan Layar Master Sales Invoice ............................................... 243 Gambar 4.2.8 Rancangan Layar Master Sales Retur .................................................. 244 Gambar 4.2.9 Rancangan Layar Master Supplier Category ....................................... 244 Gambar 4.2.10 Rancangan Layar Master Supplier ..................................................... 245 Gambar 4.2.11 Rancangan Layar Master Company ................................................... 245 Gambar 4.2.12 Rancangan Layar Master Purchase Order ......................................... 246 Gambar 4.2.13 Rancangan Layar Master Receive Item .............................................. 246 Gambar 4.2.14 Rancangan Layar Master Purchase Invoice ....................................... 247 Gambar 4.2.15 Rancangan Layar master Purchase Retur .......................................... 247 Gambar 4.2.16 Rancangan Layar Master Category Item............................................ 248 Gambar 4.2.17 Rancangan Layar Master List Items ................................................... 248 Gambar 4.2.18 Rancangan output sales order ............................................................ 249 Gambar 4.2.19 Rancangan Output Delivery Order .................................................... 249 xxi
Gambar 4.2.20 Rancangan Output Sales Invoice ........................................................ 250 Gambar 4.2.21 Rancangan Output Sales Retur........................................................... 250 Gambar 4.2.22 Rancangan output Purchase Order .................................................... 250 Gambar 4.2.23 Rancangan Output Receive Report ..................................................... 251 Gambar 4.2.24 Rancangan Output Purchase invoice ................................................. 251 Gambar 4.2.25 Rancangan Output purchase retur ..................................................... 251 Gambar 4.2.26 STD layar Login ................................................................................. 252 Gambar 4.2.27 STD Layar Utama .............................................................................. 252 Gambar 4.2.28 STD Menu Sales................................................................................. 253 Gambar 4.2.28 STD Menu Purchase .......................................................................... 253 Gambar 4.2.29 STD Menu Inventory.......................................................................... 254 Gambar 4.2.30 STD Menu Report .............................................................................. 254 Gambar 4.2.31 STD Menu Exit................................................................................... 254 Gambar 4.2.32 STD Layar Customer ......................................................................... 255 Gambar 4.2.33 STD layar Sales Order ....................................................................... 255 Gambar 4.2.34 STD layar Delivery Order .................................................................. 256 Gambar 4.2.35 STD layar Sales Invoice ..................................................................... 256 Gambar 4.2.36 STD layar Sales Retur ........................................................................ 257 Gambar 4.2.37 STD layar Supplier Category ............................................................. 257 Gambar 4.2.38 STD layar Supplier ............................................................................ 258 Gambar 4.2.39 STD layar Company ........................................................................... 258 Gambar 4.2.40 STD layar Puchase Order .................................................................. 259 Gambar 4.2.41 STD layar Receive Item ...................................................................... 259 Gambar 4.2.42 STD Layar Purchase Invoice ............................................................. 260 Gambar 4.2.43 STD Layar Purchase Retur ................................................................ 260 Gambar 4.2.44 STD Layar Category Items ................................................................ 261 Gambar 4.2.45 STD Layar List of Items ..................................................................... 261 Gambar 4.2.46 STD Layar Sales Order Report .......................................................... 262 Gambar 4.2.47 STD Delivery Order Report ............................................................... 262 Gambar 4.2.48 STD Sales Invoice Report .................................................................. 262 Gambar 4.2.49 STD Sales Retur Report ..................................................................... 263 xxii
Gambar 4.2.50 STD Purchase Order Report.............................................................. 263 Gambar 4.2.51 STD Purchase Invoice Report............................................................ 263 Gambar 4.2.52 STD Purchase Retur Report .............................................................. 263 Gambar 4.2.53 STD Receive Item Report ................................................................... 264 Gambar 4.2.54 STD Layar Register............................................................................ 264 Gambar 4.2.55 STD Layar exit ................................................................................... 264 Gambar 4.2.56 Layar Login ........................................................................................ 280 Gambar 4.2.57 Layar Utama ....................................................................................... 280 Gambar 4.2.58 Layar Customer .................................................................................. 281 Gambar 4.2.59 Layar Sales Order .............................................................................. 282 Gambar 4.2.60 Layar Delivery Order ......................................................................... 283 Gambar 4.2.61 Layar Sales Invoice ............................................................................ 284 Gambar 4.2.62 Layar Sales Retur ............................................................................... 285 Gambar 4.2.63 Layar Supplier Category .................................................................... 285 Gambar 4.2.64 Layar Supplier .................................................................................... 286 Gambar 4.2.65 Layar Company .................................................................................. 287 Gambar 4.2.66 Layar Purchase Order........................................................................ 288 Gambar 4.2.67 Layar Receive Item ............................................................................. 289 Gambar 4.2.68 Layar Purchase Invoice ...................................................................... 290 Gambar 4.2.69 layar Purchase Retur .......................................................................... 291 Gambar 4.2.70 Layar Category Items ......................................................................... 291 Gambar 4.2.71 Layar List of Items .............................................................................. 292 Gambar 4.2.72 Layar Sales Order Report .................................................................. 293 Gambar 4.2.73 Layar Delivery Order Report ............................................................. 293 Gambar 4.2.74 Layar Sales Invoice Report ................................................................ 294 Gambar 4.2.75 layar Sales Retur Report..................................................................... 294 Gambar 4.2.76 Layar Purchase Order Report ............................................................ 295 Gambar 4.2.77 Layar Receive Item Report ................................................................. 295 Gambar 4.2.78 Layar Purchase Invoice Report .......................................................... 296 Gambar 4.2.79 layar Purchase Retur Report .............................................................. 296 Gambar 4.2.80 Layar Register .................................................................................... 297 xxiii
DAFTAR LAMPIRAN
Lampiran 1
Pertanyaan yang diajukan dalam wawancara ....................................... L1
xxiv
