ANALISIS DAN PERANCANGAN SISTEM BASIS DATA …thesis.binus.ac.id/Doc/Cover/2009-1-00124-IF cover.pdf · v DAFTAR ISI Halaman Judul Luar Halaman Judul Dalam Halaman Persetujuan Hard

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

ii

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 :

iii

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.

iv

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

v

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.4.1 Metode Penemuan Fakta ........................................................ . 4

1.4.2 Metode Perancangan .............................................................. . 5

1.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

vi

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.7.2.1 Derajat tipe relasi ...................................... 40

2.1.7.2.2 Relasi rekursif ........................................... 40

2.1.8 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

vii

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

viii

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.1.6 Permasalahan Yang Dihadapi ................................................. 71

3.1.7 Alternatif Pemecahan Masalah ............................................... 72

3.2 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

ix

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 many-

to-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

x

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

xi

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

xii

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

xiii

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

xiv

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

xv

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

xvi

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

xvii

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

xviii

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

xix

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

xx

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

xxi

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

xxii

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

xxiii

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

xxiv

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

xxv

Gambar 4.55 Halaman Update Voucher ................................................................. 312

Gambar 4.56 Halaman Delete Voucher ................................................................... 313