ANALISIS DAN PERANCANGAN SISTEM BASIS DATA PENGENDALIAN ANGGARAN PADA PT. NAKAMI KINEMA CEMERLANG
SKRIPSI
Oleh
Welly
0900822306
David Chandra
0900822312
Hainiek Jeksen Saputra
0900822760
Kelas / Kelompok : 07 PLT / 004
Universitas Bina Nusantara Jakarta 2009
ANALISIS DAN PERANCANGAN SISTEM BASIS DATA PENGENDALIAN ANGGARAN PADA PT. NAKAMI KINEMA CEMERLANG
SKRIPSI diajukan sebagai satu syarat untuk gelar kesarjanaan pada jurusan Teknik Informatika jenjang pendidikan Strata – 1 Oleh Welly
0900822306
David Chandra
0900822312
Hainiek Jeksen Saputra
0900822760
Kelas / Kelompok : 07 PLT / 004
Universitas Bina Nusantara Jakarta 2009
KATA PENGANTAR
Dengan segenap kerendahan hati, kami haturkan puji dan syukur kepada Tuhan Yang Maha Esa karena tanpa rahmat dan karunia-Nya, kami tidak mungkin dapat menyelesaikan skripsi yang berjudul “Analisis Dan Perancangan Sistem Basis Data Pengendalian Anggaran Pada PT. Nakami Kinema Cemerlang ” ini dengan baik dan tepat waktu. Penulisan skripsi ini merupakan salah satu syarat untuk mendapatkan gelar Sarjana Komputer pada Fakultas Ilmu Komputer, Jurusan Teknik Informatika, Universitas Bina Nusantara. Dengan melakukan skripsi ini, kami dapat mengimplementasikan banyak teori yang kami dapatkan selama kuliah. Disamping itu, kami juga mendapatkan pengalaman bagaimana cara berinteraksi dengan rekan kerja di dalam lapangan pekerjaan sehingga di saat kami memasuki dunia kerja nantinya akan mampu memberikan yang terbaik bagi kinerja perusahaan. Penulis menyadari sepenuhnya bahwa isi dari skripsi ini masih banyak kekurangan serta kelemahan baik dari segi teknik penyusunan maupun pembahasan materi, dengan kata lain jauh dari sempurna. Oleh karena itu penulis sangat mengharapkan kritik dan saran yang membangun demi perbaikan dan penyempurnaan skripsi ini. Dalam menyusun skripsi ini, kami banyak mendapat bantuan dari berbagai pihak. Oleh karena itu, dalam kesempatan ini, kami ingin mengucapkan banyak terima kasih kepada :
ii
1. Bapak Prof. Dr. Gerardus Polla, M.App.Sc,. selaku Rektor Universitas Bina Nusantara. 2. Bapak Freddy Purnomo, S.Kom, M.Com selaku Ketua Jurusan Teknik Informatika 3. Bapak Djauharry Noor, Ir, M.Sc, selaku dosen pembimbing, atas bimbingan yang telah diberikan sehingga penulis dapat menyelesaikan laporan penelitian ini. 4. Seluruh dosen Universitas Bina Nusantara yang telah telah banayk memberikan masukan dan saran–saran yang sangat bermanfaat kepada kami sehingga penulis skripsi ini dapat selesai dengan baik dan tepat waktu. 5. Bapak Dr. Ir. Agus Mulyanto, M. Sc selaku Founder and Group President dari PT. Nakami Kinema Cemerlang telah mengijinkan penulis melakukan proses skripsi. 6. Michael Mulyanto, MBA selaku Vice President and Managing Director dari PT. Nakami Kinema Cemerlang yang banyak membantu penulis dalam proses penulisan skripsi. 7. Bapak Henry Afani ,SE selaku Assistant Project Manager dari PT. Nakami Kinema Cemerlang yang telah banyak membantu dalam proses pembuatan skripsi 8. Bapak Sabilal Rasyid, SE selaku HR and GA Manager dari PT. Nakami Kinema Cemerlang yang telah banyak membantu dalam proses pembuatan skripsi. 9. Seluruh staf PT. Nakami Kinema Cemerlang yang bersedia memberikan data maupun informasi kepada penulis.
iii
10. Orang tua tercinta yang selama ini telah banyak memberikan dukungan, bantuan, dan doa. 11. Teman – teman yang telah banyak membantu penulis. 12. Serta semua pihak yang telah membantu penulis untuk menyelesaikan Skripsi ini. Akhir kata, kami ingin mengucapkan terima kasih dan mohon maaf kepada pembaca akan adanya kesalahan – kesalahan yang terdapat dalam penulisan laporan skripsi ini, semoga laporan skripsi ini dapat memberikan manfaat bagi para pembca.
Jakarta, 14 januari 2009
Penulis
iv
DAFTAR ISI Halaman Judul Luar Halaman Judul Dalam Halaman Persetujuan Hard Cover Halaman Pernyataan Dewan Penguji Anstrak .......................................................................................................................... i Kata Pengantar ..............................................................................................................ii Daftar isi ........................................................................................................................v Daftar Tabel ..................................................................................................... .............xii Daftar Gambar ....................................................................................... ..................... .. xv BAB 1 : Pendahuluan 1.1
Latar Belakang .................................................................................... . 1
1.2
Ruang Lingkup ................................................................................... . 2
1.3
Tujuan dan Manfaat ............................................................................ . 3
1.4
Metodologi Penelitian ........................................................................ . 4
1.5
1.4.1
Metode Penemuan Fakta ........................................................ . 4
1.4.2
Metode Perancangan .............................................................. . 5
Sistematika Penulisan ......................................................................... . 6
BAB 2 : Landasan Teori 2.1
Teori-Teori dasar / umum ...................................................................... 8 2.1.1
Pengertian Data ......................................................................... 8
2.1.2
Pengertian Basis Data ................................................................ 8
2.1.3
Sistem Basis Data ...................................................................... 9
v
2.1.4
Database Management system (DBMS) ................................... 10
2.1.5
Database Application Lifecycle(DBLC) ................................... 17
2.1.6
Teori Metodologi Perancangan Basis Data ............................... 23 2.1.6.1 Perancangan Basis data konseptual ............................... 23 2.1.6.2 Perancangan Basis Data Logikal ................................... 27 2.1.6.3 Perancangan Basis Data Fisik ....................................... 33
2.1.7
Entity Relationship Modelling ………………………………. 39 2.1.7.1 Entity type .................................................................. 39 2.1.7.2 Relationship type ........................................................ 40
2.1.8
2.1.7.2.1
Derajat tipe relasi ...................................... 40
2.1.7.2.2
Relasi rekursif ........................................... 40
Atribut ..................................................................................... 40 2.1.8.1 Atribut Sederhana dan Komposit ............................... 40 2.1.8.2 Atribut Single - Valued dan Multi – Valued ............. 41 2.1.8.3 Atribut Turunan .......................................................... 41
2.1.9
Keys ........................................................................................ 41 2.1.9.1 Simple Key ................................................................. 41 2.1.9.2 Compisie Key ............................................................. 41 2.1.9.3 Candidate Key ............................................................ 41 2.1.9.4 Primary Key ................................................................ 42 2.1.9.5 Altenate Key ............................................................... 42 2.1.9.6 Foreign Key ................................................................ 42
2.1.10 Normalisasi ............................................................................. 42
vi
2.1.10.1 Proses Normalisasi ................................................... 42 2.1.10.1.1 Bentuk Normal Kesatu (1NF) .................. 43 2.1.10.1.2 Bentuk Normal Kedua (2NF) ................... 43 2.1.10.1.3 Bentuk Normal Ketiga (3NF) ................... 43 2.1.10.1.4 Bentuk Normal Boyce-Cold (BCNF) ....... 44 2.1.10.1.5 Bentuk Normal Keempat (4NF) ............... 44 2.1.10.1.6 Bentuk Normal Kelima (5NF) .................. 44 2.1.11 Teori – teori lain ..................................................................... 44 2.1.11.1 Entity Relationship Diagram (ERD) ........................ 44 2.1.11.2 SQL (Structure Query Language) ............................ 45 2.1.11.3 Data Manipulation .................................................... 46 2.1.11.1.1 Simple Query ............................................ 46 2.1.11.1.2 Aggregate Functions ................................. 46 2.2
Teori – teori pendukung ..................................................................... 47 2.2.1
Anggaran ................................................................................ 47
2.2.2
OOP ........................................................................................ 50
2.2.3
PHP ......................................................................................... 53
2.2.4
Javascript ................................................................................ 54
2.2.5
MySql ..................................................................................... 55
2.2.6
Ajax ......................................................................................... 55
BAB 3 : PERANCANGAN DAN IMPLEMENTASI 3.1
Analisis ............................................................................................... 57 3.1.1
Sejarah Organisasi .................................................................. 57
vii
3.1.1.1 Latar Belakang ........................................................... 57 3.1.1.2 Kesahan Hukum ......................................................... 59 3.1.1.3 Struktur Organisasi ..................................................... 59 3.1.1.4 Struktur Organisasi Proyek ......................................... 62 3.1.2 Visi dan Misi Perusahaan ....................................................... 62 3.1.2.1 Visi .............................................................................. 62 3.1.2.2 Misi .............................................................................. 62 3.1.3
Client PT. Nakami Kinema Cemerlang .................................. 63
3.1.4
Sistem Yang Sedang Berjalan ................................................ 64 3.1.4.1 Diagram Aliran Data .................................................. 66 3.1.4.1.1 Diagram Konteks ...................................... 66 3.1.4.1.2
Diagram Nol ............................................. 67
3.1.4.2 Batasan Sistem ............................................................ 68 3.1.5
Analisis Kebutuhan Sistem ..................................................... 68 3.1.5.1 Data Requirement ....................................................... 68 3.1.5.2 Transaction Requirement ............................................ 70
3.2
3.1.6
Permasalahan Yang Dihadapi ................................................. 71
3.1.7
Alternatif Pemecahan Masalah ............................................... 72
Perancangan Database ........................................................................ 73 3.2.1
Rancangan Konseptual .......................................................... 73 3.2.1.1 Mengidentifikasikan Tipe Entitas ............................... 74 3.2.1.2 Mengidentifikasikan Tipe-Tipe Relasi ....................... 76
viii
3.2.1.3 Mengidentifikasi dan Menghubungkan Atribut dengan Entitas atau Relasi ..................................................... 78 3.2.1.4 Menentukan Atribut Domain ...................................... 88 3.2.1.5 Menentukan Candidate dan Primary Key ................... 98 3.2.1.6 Mempertimbangkan model Enhanced Entity Relationship Diagram .................................................................................. 99 3.2.1.7 Mengecek Redundansi pada Model ............................ 99 3.2.1.8 Memvalidasi Model Konseptual Lokal dengan Transaksi Pengguna .................................................................... 100 3.2.2
Perancangan Basis Data Logikal ............................................ 103 3.2.2.1 Menghilangkan fitur yang tidak compatibel dengan model relational ..................................................................... 103 3.2.2.1.1 Menghilangkan many-to-many (*:*) binary relationship ............................................... 103 3.2.2.1.2
Menghilangkan tipe hubungan rekursif manyto-many ..................................................... 108
3.2.2.1.3
Menghilangkan tipe hubungan kompleks . 108
3.2.2.1.4
Menghilangkan multi – valued attribute .. 108
3.2.2.2 Membuat relasi untuk model data logikal .................. 109 3.2.2.3 Mengidentifikasi tipe relasi one-to-many (1:*) binary ..................................................................................... 112 3.2.2.4 Mengidentifikasi tipe relasi ono-to-one (1:1) binary .. 115
ix
3.2.2.5 Mengidentifikasikan tipe relasi many-to-many (*:*) binary ........................................................................... 116 3.2.2.6 Mengidentifikasikan tipe relasi atrubut multi-valued . 120 3.2.2.7 Validasi relasi dengan normalisasi ............................. 125 3.2.2.8 Validasi relasi terhadap transaksi pengguna ............... 143 3.2.2.9 Menentukan batasan integritas ................................... 146 3.2.3
Perancangan Basis Data Fisikal .............................................. 151 3.2.3.1 Merancang Relational Basis Data .............................. 151 3.2.3.2 Merancang Representasi Data Turunan ...................... 176 3.2.3.3 Merancang Batasan Perusahaan ................................. 176 3.2.3.4 Analisis Transaksi ...................................................... 177 3.2.3.5 Memilih Organisasi File ............................................. 183 3.2.3.6 Pembuatan Indeks Setiap Entitas ................................ 184 3.2.3.7 Mengestimasi Kapasitas Penyimpanan Yang Diperlukan ..................................................................................... 184 3.2.3.8 Merancang Tampilan User View ................................ 200 3.2.3.9 Merancang Mekanisme Keamanan ............................ 200
3.3
Perancangan Aplikasi .......................................................................... 202 3.3.1
Struktur Menu ......................................................................... 203
3.3.2
Rancangan State Transition Diagram (STD) .......................... 204
3.3.3
Spesifikasi Proses ................................................................... 219
3.3.4
Rancangan Layar .................................................................... 239
x
BAB 4 : IMPLEMENTASI 4.1
Spesifikasi Perangkat Keras ............................................................... 267
4.2
Spesifikasi Perangkat Lunak .............................................................. 268
4.3
Jadwal Implementasi .......................................................................... 268
4.4
Kebutuhan Sumber Daya Manusia ..................................................... 269
4.5
Petunjuk Pengoperasian Aplikasi ....................................................... 270
4.6
Evaluasi .............................................................................................. 314
BAB 5 : KESIMPULAN DAN SARAN 5.1
Kesimpulan ......................................................................................... 316
5.2
Saran ................................................................................................... 317
DAFTAR PUSTAKA RIWAYAT HIDUP FOTOCOPY SURAT SURVEY
xi
DAFTAR TABEL Tabel 3.1
Dokumentasi Tipe Entitas .................................................................. 74
Tabel 3.2
Dokumentasi Tipe Hubungan Entitas ................................................ 77
Tabel 3.3
Entitas Perancangan .......................................................................... 78
Tabel 3.4
Entitas Karyawan .............................................................................. 79
Tabel 3.5
Entitas User ....................................................................................... 79
Tabel 3.6
Entitas Supplier ................................................................................. 80
Tabel 3.7
Entitas Barang ................................................................................... 81
Tabel 3.8
Entitas TglMasuk .............................................................................. 81
Tabel 3.9
Entitas TglKeluar .............................................................................. 81
Tabel 3.10
Entitas PR .......................................................................................... 82
Tabel 3.11
Entitas PO .......................................................................................... 83
Tabel 3.12
EntitasVoucher .................................................................................. 85
Tabel 3.13
Entitas BTB ....................................................................................... 86
Tabel 3.14
Entitas Tagihan .................................................................................. 87
Tabel 3.15
Entitas RFP ........................................................................................ 87
Tabel 3.16
Identifikasi Atribut Domain Entitas Perancangan ............................. 88
Tabel 3.17
Identifikasi Atribut Domain Entitas Karyawan ................................. 89
Tabel 3.18
Identifikasi Atribut Domain Entitas User .......................................... 89
Tabel 3.19
Identifikasi Atribut Domain Entitas Supplier .................................... 90
Tabel 3.20
Identifikasi Atribut Domain Entitas Barang ...................................... 91
Tabel 3.21
Identifikasi Atribut Domain Entitas TglMasuk ................................. 91
xii
Tabel 3.22
Identifikasi Atribut Domain Entitas TglKeluar ................................. 91
Tabel 3.23
Identifikasi Atribut Domain Entitas PR ............................................ 92
Tabel 3.24
Identifikasi Atribut Domain Entitas PO ............................................ 93
Tabel 3.25
Identifikasi Atribut Domain Entitas Voucher ................................... 95
Tabel 3.26
Identifikasi Atribut Domain Entitas BTB ......................................... 96
Tabel 3.27
Identifikasi Atribut Domain Entitas Tagihan .................................... 96
Tabel 3.28
Identifikasi Atribut Domain Entitas RFP .......................................... 97
Tabel 3.29
Dokumentasi Candidate Key dan Primary Key ................................ 98
Tabel 3.30
Tabel Relasi ....................................................................................... 121
Tabel 3.31
Tabel Integritas Referensial ............................................................... 146
Tabel 3.32
Tabel Analisis 1 ................................................................................. 179
Tabel 3.33
Tabel Analisis 2 ................................................................................. 179
Tabel 3.34
Tabel Analisis 3 ................................................................................. 180
Tabel 3.35
Tabel Analisis 4 ................................................................................. 181
Tabel 3.36
Tabel Analisis 5 ................................................................................. 181
Tabel 3.37
Tabel Analisis 6 ................................................................................. 182
Tabel 3.38
Tabel Perkiraan Kapasitas Karyawan ................................................ 184
Tabel 3.39
Tabel Perkiraan Kapasitas Telp_Karyawan ...................................... 184
Tabel 3.40
Tabel Perkiraan Kapasitas User ........................................................ 185
Tabel 3.41
Tabel Perkiraan Kapasitas PR ........................................................... 185
Tabel 3.42
Tabel Perkiraan Kapasitas DetailPR ................................................. 187
Tabel 3.43
Tabel Perkiraan Kapasitas PO ........................................................... 188
Tabel 3.44
Tabel Perkiraan Kapasitas DetailPO ................................................. 189
xiii
Tabel 3.45
Tabel Perkiraan Kapasitas Barang .................................................... 189
Tabel 3.46
Tabel Perkiraan Kapasitas TglMasuk ................................................ 190
Tabel 3.47
Tabel Perkiraan Kapasitas Detail_TglMasuk ..................................... 190
Tabel 3.48
Tabel Perkiraan Kapasitas TglKeluar ................................................ 191
Tabel 3.49
Tabel Perkiraan Kapasitas Detail_TglKeluar ..................................... 191
Tabel 3.50
Tabel Perkiraan Kapasitas Perancangan ............................................ 192
Tabel 3.51
Tabel Perkiraan Kapasitas DetailPerancangan .................................. 192
Tabel 3.52
Tabel Perkiraan Kapasitas Supplier .................................................. 193
Tabel 3.53
Tabel Perkiraan Kapasitas DetailSupplier ......................................... 193
Tabel 3.54
Tabel Perkiraan Kapasitas FaxSupplier ............................................ 194
Tabel 3.55
Tabel Perkiraan Kapasitas TelpSupplier ........................................... 194
Tabel 3.56
Tabel Perkiraan Kapasitas BTB ........................................................ 194
Tabel 3.57
Tabel Perkiraan Kapasitas DetailBTB .............................................. 195
Tabel 3.58
Tabel Perkiraan Kapasitas Tagihan ................................................... 195
Tabel 3.59
Tabel Perkiraan Kapasitas DetailTagihan ......................................... 196
Tabel 3.60
Tabel Perkiraan Kapasitas Voucher .................................................. 196
Tabel 3.61
Tabel Perkiraan Kapasitas RFP ......................................................... 198
Tabel 3.62
Tabel Perkiraan Kapasitas DetailRFP ............................................... 199
Tabel 3.63
Tabel Perancangan Mekanisme Keamanan 1 .................................... 200
Tabel 3.64
Tabel Perancangan Mekanisme Keamanan 2 ..................................... 201
Tabel 4.1
Tabel Jadawl Implementasi ............................................................... 269
xiv
DAFTAR GAMBAR Gambar 2.1
Gambar Database Application Lifecycle ........................................ 18
Gambar 3.1
Gambar Struktur Organisasi ............................................................ 59
Gambar 3.2
Gambar Struktur Organisasi Proyek ................................................ 62
Gambar 3.3
Gambar Client PT. Nakami Kinema Cemerlang ............................. 63
Gambar 3.4
Gambar Proses Bisnis Secara Functional ....................................... 64
Gambar 3.5
Gambar Diagram Konteks ............................................................... 66
Gambar 3.6
Gambar Diagram Nol ..................................................................... 67
Gambar 3.7
Gambar ERD Konseptual Awal ...................................................... 78
Gambar 3.8
Gambar ERD Konseptual Dengan Primary Key ............................ 99
Gambar 3.9
Gambar ERD Konseptual Dengan Jalur-Jalur Transaksi ............... 101
Gambar 3.10
Gambar Hubungan PR dengan Barang ............................................ 103
Gambar 3.11
Gambar Hubungan PO dengan Barang ........................................... 104
Gambar 3.12
Gambar Hubungan Supplier dengan Barang ................................... 104
Gambar 3.13
Gambar Hubungan BTB dengan Barang ......................................... 104
Gambar 3.14
Gambar Hubungan Tagihan dengan Barang ................................... 105
Gambar 3.15
Gambar Hubungan RFP dengan Barang .......................................... 105
Gambar 3.16
Gambar Hubungan Perancangan dengan Barang ............................ 106
Gambar 3.17
Gambar Hubungan TglMasuk dengan Barang ................................ 107
Gambar 3.18
Gambar Hubungan TglKeluar dengan Barang ................................ 107
Gambar 3.19
Gambar Entitas Karyawan ................................................................ 108
Gambar 3.20
Gambar Entitas Supplier .................................................................. 109
xv
Gambar 3.21
Gambar Hubungan PR dengan Perancangan ................................... 113
Gambar 3.22
Gambar Hubungan Karyawan dengan Perancangan ....................... 113
Gambar 3.23
Gambar Hubungan PO dengan Supplier ......................................... 113
Gambar 3.24
Gambar Hubungan BTB dengan Supplier ....................................... 113
Gambar 3.25
Gambar Hubungan Tagihan dengan BTB ....................................... 114
Gambar 3.26
Gambar Hubungan Tagihan dengan Supplier .................................. 114
Gambar 3.27
Gambar Hubungan RFP dengan Tagihan ........................................ 114
Gambar 3.28
Gambar Hubungan RFP dengan Voucher ........................................ 114
Gambar 3.29
Gambar Hubungan BTB dengan PO ................................................ 116
Gambar 3.30
Gambar Hubungan PO dengan PR ................................................... 116
Gambar 3.31
Gambar Hubungan User dengan Karyawan ..................................... 116
Gambar 3.32
Gambar Hubungan PR dengan Barang ............................................. 117
Gambar 3.33
Gambar Hubungan PO dengan Barang ............................................ 117
Gambar 3.34
Gambar Hubungan Supplier dengan Barang .................................... 118
Gambar 3.35
Gambar Hubungan BTB dengan Barang .......................................... 118
Gambar 3.36
Gambar Hubungan Tagihan dengan Barang .................................... 118
Gambar 3.37
Gambar Hubungan RFP dengan Barang .......................................... 119
Gambar 3.38
Gambar Hubungan Perancangan dengan Barang ............................. 119
Gambar 3.39
Gambar Hubungan TglMasuk dengan Barang ................................. 120
Gambar 3.40
Gambar Hubungan TglKeluar dengan Barang ................................. 120
Gambar 3.41
Gambar Hubungan Karyawan dengan Telp ..................................... 121
Gambar 3.42
Gambar Hubungan Supplier dengan Telp ........................................ 121
Gambar 3.43
Gambar Hubungan Supplier dengan Fax.......................................... 121
xvi
Gambar 3.44
Gambar Validasi Entitas User ......................................................... 126
Gambar 3.45
Gambar Validasi Entitas Karyawan ................................................ 126
Gambar 3.46
Gambar Validasi Entitas Telp_Karyawan ....................................... 127
Gambar 3.47
Gambar Validasi Entitas Perancangan ............................................ 128
Gambar 3.48
Gambar Validasi Entitas DetailPerancangan ................................... 128
Gambar 3.49
Gambar Validasi Entitas Supplier .................................................... 129
Gambar 3.50
Gambar Validasi Entitas DetailSupplier........................................... 129
Gambar 3.51
Gambar Validasi Entitas Telp_supplier ............................................ 130
Gambar 3.52
Gambar Validasi Entitas Fax_supplier ............................................. 131
Gambar 3.53
Gambar Validasi Entitas PR ............................................................ 131
Gambar 3.54
Gambar Validasi Entitas Detail_PR ................................................ 132
Gambar 3.55
Gambar Validasi Entitas PO ............................................................ 133
Gambar 3.56
Gambar Validasi Entitas Detail_PO ................................................ 133
Gambar 3.57
Gambar Validasi Entitas Barang ..................................................... 134
Gambar 3.58
Gambar Validasi Entitas TglMasuk ................................................ 134
Gambar 3.59
Gambar Validasi Entitas Detail_TglMasuk ..................................... 135
Gambar 3.60
Gambar Validasi Entitas TglKeluar ................................................ 136
Gambar 3.61
Gambar Validasi Entitas Detail_TglKeluar ..................................... 136
Gambar 3.62
Gambar Validasi Entitas BTB ......................................................... 137
Gambar 3.63
Gambar Validasi Entitas Detail_BTB ............................................. 137
Gambar 3.64
Gambar Validasi Entitas Tagihan .................................................... 138
Gambar 3.65
Gambar Validasi Entitas Detail_tagihan ......................................... 138
Gambar 3.66
Gambar Validasi Entitas RFP .......................................................... 139
xvii
Gambar 3.67
Gambar Validasi Entitas Detail_RFP ............................................... 140
Gambar 3.68
Gambar Validasi Entitas Voucher ................................................... 140
Gambar 3.69
ERD Logikal Dengan Primary Key Dan Attribut ........................... 142
Gambar 3.70
Validasi Relasi Logikal Lokal Melalui Transaksi Pengguna .......... 145
Gambar 3.71
Sturktur Menu .................................................................................. 203
Gambar 3.72
STD Login ........................................................................................ 204
Gambar 3.73
STD Halaman Utama......................................................................... 204
Gambar 3.74
STD User .......................................................................................... 205
Gambar 3.75
STD New User .................................................................................. 205
Gambar 3.76
STD Update User............................................................................... 205
Gambar 3.77
STD View User ................................................................................ 206
Gambar 3.78
STD Karyawan ................................................................................. 206
Gambar 3.79
STD New Karyawan ......................................................................... 206
Gambar 3.80
STD Update karyawan ...................................................................... 207
Gambar 3.81
STD View Karyawan......................................................................... 207
Gambar 3.82
STD Perancangan ............................................................................. 207
Gambar 3.83
STD View Perancangan .................................................................... 208
Gambar 3.84
STD New Perancangan ..................................................................... 208
Gambar 3.85
STD Update Perancangan ................................................................. 208
Gambar 3.86 STD Supplier ..................................................................................... 209 Gambar 3.87 STD New Supplier.............................................................................. 209 Gambar 3.88
STD Update Supplier......................................................................... 209
Gambar 3.89
STD View Supplier .......................................................................... 210
xviii
Gambar 3.90
STD Barang ....................................................................................... 210
Gambar 3.91
STD View Barang ............................................................................ 210
Gambar 3.92
STD New Barang............................................................................... 211
Gambar 3.93
STD Update Barang .......................................................................... 211
Gambar 3.94
STD PR .............................................................................................. 211
Gambar 3.95
STD New PR .................................................................................... 212
Gambar 3.96
STD View PR ................................................................................... 212
Gambar 3.97
STD Update PR ................................................................................ 212
Gambar 3.98
STD PO ............................................................................................. 213
Gambar 3.99
STD New PO .................................................................................... 213
Gambar 3.100 STD View PO ................................................................................... 213 Gambar 3.101 STD Update PO ................................................................................ 214 Gambar 3.102 STD BTB .......................................................................................... 214 Gambar 3.103 STD View BTB ................................................................................ 214 Gambar 3.104 STD New BTB ................................................................................. 215 Gambar 3.105 STD Update BTB .............................................................................. 215 Gambar 3.106 STD Tagihan ..................................................................................... 215 Gambar 3.107 STD New Tagihan ............................................................................. 216 Gambar 3.108 STD Update Tagihan ......................................................................... 216 Gambar 3.109 STD View Tagihan ........................................................................... 216 Gambar 3.110 STD RFP ........................................................................................... 217 Gambar 3.111 STD View RFP ................................................................................. 217 Gambar 3.112 STD New RFP .................................................................................. 217
xix
Gambar 3.113 STD Update RFP .............................................................................. 218 Gambar 3.114 STD Voucher .................................................................................... 218 Gambar 3.115 STD View Voucher .......................................................................... 218 Gambar 3.116 STD New Voucher ........................................................................... 219 Gambar 3.117 STD Update Voucher ...................................................................... 219 Gambar 3.118 Perancangan Halaman Login ............................................................ 240 Gambar 3.119 Perancangan Halaman Utaman ......................................................... 240 Gambar 3.120 Perancangan Halaman User .............................................................. 241 Gambar 3.121 Perancangan Halaman New User ..................................................... 241 Gambar 3.122 Perancangan Halaman Update User ................................................. 242 Gambar 3.123 Perancangan Halaman Delete User .................................................. 242 Gambar 3.124 Perancangan Halaman View User .................................................... 243 Gambar 3.125 Perancangan Halaman Karyawan ..................................................... 243 Gambar 3.126 Perancangan Halaman New Karyawan ............................................ 243 Gambar 3.127 Perancangan Halaman Update Karyawan ........................................ 244 Gambar 3.128 Perancangan Halaman Delete Karyawan ......................................... 244 Gambar 3.129 Perancangan Halaman Perancangan .................................................. 245 Gambar 3.130 Perancangan Halaman View Perancangan ....................................... 245 Gambar 3.131 Perancangan Halaman New Perancangan ........................................ 245 Gambar 3.132 Perancangan Halaman Update Perancangan .................................... 246 Gambar 3.133 Perancangan Halaman Delete Perancangan ..................................... 246 Gambar 3.134 Perancangan Halaman Supplier ........................................................ 247 Gambar 3.135 Perancangan Halaman New Supplier ............................................... 247
xx
Gambar 3.136 Perancangan Halaman Update Supplier ........................................... 248 Gambar 3.137 Perancangan Halaman Delete Supplier ............................................ 248 Gambar 3.138 Perancangan Halaman View Supplier .............................................. 249 Gambar 3.139
Perancangan Halaman Barang ......................................................... 249
Gambar 3.140 Perancangan Halaman View Barang ................................................ 249 Gambar 3.141 Perancangan Halaman New Barang ................................................. 250 Gambar 3.142 Perancangan Halaman Delete Barang .............................................. 250 Gambar 3.143 Perancangan Halaman Update Barang ............................................. 251 Gambar 3.144 Perancangan Halaman PR ................................................................ 251 Gambar 3.145 Perancangan Halaman PO ................................................................ 252 Gambar 3.146 Perancangan Halaman New PR ........................................................ 252 Gambar 3.147 Perancangan Halaman New PO ........................................................ 253 Gambar 3.148 Perancangan Halaman View PR ....................................................... 253 Gambar 3.149 Perancangan Halaman View PO ....................................................... 254 Gambar 3.150 Perancangan Halaman Update PR .................................................... 254 Gambar 3.151 Perancangan Halaman Update PO .................................................... 255 Gambar 3.152 Perancangan Halaman Delete PR ...................................................... 255 Gambar 3.153 Perancangan Halaman Delete PO ...................................................... 256 Gambar 3.154 Perancangan Halaman BTB ............................................................... 256 Gambar 3.155 Perancangan Halaman New BTB ...................................................... 257 Gambar 3.156 Perancangan Halaman View BTB ..................................................... 257 Gambar 3.157 Perancangan Halaman Update BTB .................................................. 258 Gambar 3.158 Perancangan Halaman Delete BTB ................................................... 258
xxi
Gambar 3.159 Perancangan Halaman Tagihan ......................................................... 259 Gambar 3.160 Perancangan Halaman New Tagihan ................................................. 259 Gambar 3.161 Perancangan Halaman View Tagihan ................................................ 260 Gambar 3.162 Perancangan Halaman Update Tagihan ............................................. 260 Gambar 3.163 Perancangan Halaman Delete Tagihan .............................................. 261 Gambar 3.164 Perancangan Halaman RFP ............................................................... 261 Gambar 3.165 Perancangan Halaman New RFP ....................................................... 262 Gambar 3.166 Perancangan Halaman View RFP ...................................................... 262 Gambar 3.167 Perancangan Halaman Update RFP .................................................... 263 Gambar 3.168 Perancangan Halaman Delete RFP .................................................... 263 Gambar 3.169 Perancangan Halaman Voucher ......................................................... 264 Gambar 3.170 Perancangan Halaman Delete Voucher ............................................. 264 Gambar 3.171 Perancangan Halaman New Voucher ................................................ 265 Gambar 3.172 Perancangan Halaman Update Voucher ............................................ 265 Gambar 3.173 Perancangan Halaman View Voucher ............................................... 266 Gambar 4.1
Halaman Login .................................................................................. 270
Gambar 4.2
Halaman Utaman ............................................................................... 271
Gambar 4.3
Halaman User .................................................................................... 271
Gambar 4.4
Halaman New User ............................................................................ 272
Gambar 4.5
Halaman Update User ........................................................................ 273
Gambar 4.6
Halaman View User ........................................................................... 274
Gambar 4.7
Halaman Delete User ......................................................................... 274
Gambar 4.8
Halaman Karyawan ........................................................................... 275
xxii
Gambar 4.9
Halaman New Karyawan ................................................................... 276
Gambar 4.10
Halaman Update Karyawan ............................................................... 277
Gambar 4.11
Halaman Delete Karyawan ................................................................ 278
Gambar 4.12
Halaman Perancangan ....................................................................... 278
Gambar 4.13
Halaman New Perancangan ............................................................... 279
Gambar 4.14 Halaman View Perancangan .............................................................. 280 Gambar 4.15 Halaman Update Perancangan ........................................................... 281 Gambar 4.16 Halaman Delete Perancangan ............................................................ 282 Gambar 4.17 Halaman Supplier .............................................................................. 283 Gambar 4.18 Halaman New Supplier ...................................................................... 284 Gambar 4.19 Halaman View Supplier ..................................................................... 284 Gambar 4.20 Halaman Update Supplier .................................................................. 285 Gambar 4.21 Halaman Delete Supplier ................................................................... 286 Gambar 4.22
Halaman Barang ................................................................................ 286
Gambar 4.23
Halaman New Barang ........................................................................ 287
Gambar 4.24
Halaman View Barang ....................................................................... 288
Gambar 4.25
Halaman Update Barang .................................................................... 288
Gambar 4.26
Halaman Delete Barang ..................................................................... 289
Gambar 4.27
Halaman PR ....................................................................................... 290
Gambar 4.28
Halaman New PR .............................................................................. 291
Gambar 4.29
Halaman View PR ............................................................................. 292
Gambar 4.30
Halaman Update PR .......................................................................... 293
Gambar 4.31 Halaman Delete PR ........................................................................... 294
xxiii
Gambar 4.32
Halaman PO ....................................................................................... 294
Gambar 4.33
Halaman New PO .............................................................................. 295
Gambar 4.34
Halaman View PO ............................................................................. 296
Gambar 4.35
Halaman Update PO .......................................................................... 297
Gambar 4.36
Halaman Delete PO ........................................................................... 297
Gambar 4.37
Halaman BTB .................................................................................... 298
Gambar 4.38
Halaman New BTB ........................................................................... 299
Gambar 4.39
Halaman View BTB .......................................................................... 300
Gambar 4.40
Halaman Update BTB ....................................................................... 300
Gambar 4.41
Halaman Delete BTB ......................................................................... 301
Gambar 4.42 Halaman Tagihan ............................................................................... 302 Gambar 4.43
Halaman New Tagihan ...................................................................... 303
Gambar 4.44
Halaman View Tagihan ..................................................................... 303
Gambar 4.45 Halaman Update Tagihan .................................................................. 304 Gambar 4.46
Halaman Delete Tagihan ................................................................... 305
Gambar 4.47
Halaman RFP ..................................................................................... 305
Gambar 4.48
Halaman New RFP ............................................................................ 306
Gambar 4.49
Halaman View RFP ........................................................................... 307
Gambar 4.50
Halaman Update RFP ......................................................................... 308
Gambar 4.51
Halaman Delete RFP ......................................................................... 308
Gambar 4.52
Halaman Voucher .............................................................................. 309
Gambar 4.53 Halaman New Voucher ..................................................................... 310 Gambar 4.54 Halaman View Voucher .................................................................... 311
xxiv
Gambar 4.55 Halaman Update Voucher ................................................................. 312 Gambar 4.56 Halaman Delete Voucher ................................................................... 313
xxv