ANALIS IS DAN PERANCANGAN S IS TEM BAS IS DATA PMO TIMES HEET DAN PMO LIBRARY PADA PT PLN (Persero)
S KRIPS I
Oleh
Raninta Mahardi
1000841691
Fahmi Adriansyah
1000857903
Astried Nirmala Safitri
1000885011
Kelas / Kelompok : 07PFT / 01
BINUS UNIVERS ITY Jakarta 2010
ANALIS IS DAN PERANCANGAN S IS TEM BAS IS DATA PMO TIMES HEET DAN PMO LIBRARY PADA PT PLN (Persero)
S KRIPS I
diajukan sebagai salah satu syarat untuk gelar kesarjanaan pada Jurusan Teknik Informatika Jenjang Pendidikan Strata-1
Oleh Raninta Mahardi
1000841691
Fahmi Adriansyah
1000857903
Astried Nirmala Safitri
1000885011
Kelas / Kelompok : 07PFT / 01
BINUS UNIVERS ITY Jakarta 2010 ii
PRAKATA Puji syukur kami panjatkan ke hadirat Allah SWT karena dengan rahmat, hidayah dan karunia-Nya yang diberikan kepada kami selama penulisan skripsi ini sehingga kami mampu menyelesaikan skripsi yang berjudul “Analisis dan Perancangan Sistem Basis Data PM O Timesheet dan PM O Library pada PT PLN (Persero)”. Skripsi ini disusun untuk memenuhi salah satu syarat dalam menyelesaikan program Strata-1 (S1) jurusan Teknik Informatika di Binus University, Jakarta. Kami menyadari bahwa tersusunnya skripsi ini tidak terlepas dari dukungan, bantuan, dan saran dari berbagai pihak. M aka dari itu, pada kesempatan ini kami ingin menyampaikan terima kasih yang sebesar–besarnya kepada : 1.
Bapak Prof. Dr. Ir. Harjanto Prabowo, MM, selaku Rektor Binus University.
2.
Bapak Sablin Yusuf, Ir., M .Sc., M .Comp.Sc., selaku Dekan Fakultas Ilmu Komputer.
3.
Bapak Freddy Purnomo, S.Kom., M .Kom., selaku Ketua Jurusan Teknik Informatika.
4.
Bapak Abdul Aziz, Ir., M .Sc., Dr., selaku dosen pembimbing yang telah memberikan pengarahan dan bimbingan dalam menyusun skripsi ini.
5.
Bapak Fajar M asya, Ir., MM SI, selaku dosen analisa perancangan dan sistem yang telah memberikan pengarahan dalam merancang basis data.
6.
Seluruh dosen di Binus University yang telah mengajar dan mendidik kami sehingga dapat mencapai garis studi dari program pendidikan Strata-1 di Binus University. viii
7.
Bapak Pandu Angklasito, selaku Deputi Direktur Proses Bisnis dan Sistem Informasi PT PLN (Persero) atas kesempatan yang telah diberikan kepada kami untuk menjadikan PT PLN (Persero) sebagai objek penelitian.
8.
Bapak Endang Sugiarto, selaku Asisten Deputi Direktur Sistem Informasi Program M anagement Office PT PLN (Persero) yang telah membantu kami dalam melakukan penelitian untuk penulisan skripsi ini.
9.
Seluruh staf PT PLN (Persero) yang telah membantu dan memberikan informas i yang berhubungan dengan penulisan skripsi ini.
10. Orang tua dan keluarga yang selama ini telah memberikan dukungan dalam doa, perhatian, semangat dan bantuan baik secara moril maupun materil. 11. Teman–Teman yang telah memberikan bantuan, dukungan, dan masukan yang bermanfaat bagi kami dalam penulisan skripsi ini. 12. Pihak–pihak yang tidak dapat disebutkan satu persatu yang secara langsung maupun tidak langsung telah memberikan bantuan dan dukungan kepada kami. Kami menyadari bahwa skripsi yang kami buat masih memiliki kekurangan maka dari itu kami berharap mendapatkan saran dan kritik untuk pengembangan skripsi ini selanjutnya. Akhir kata, penulis berharap semoga skripsi ini dapat bermanfaat bagi PT PLN (Persero) dan juga kepada pihak–pihak lain yang berkepentingan. Jakarta, Januari 2010
Penulis
ix
DAFTAR IS I
Halaman Judul Luar..............................................................................................................i Halaman Judul Dalam......................................................................................................... ii Halaman Persetujuan Hard Cover ..................................................................................... iii Halaman Penyataan Dewan Penguji ...................................................................................iv Abstrak.............................................................................................................................. vii Prakata ............................................................................................................................. viii Daftar Isi ..............................................................................................................................x Daftar Tabel .................................................................................................................... xvii Daftar Gambar ..................................................................................................................xxi BAB 1 PENDAHULUAN...................................................................................................1 1.1 Latar Belakang.....................................................................................................1 1.2 Ruang Lingkup ....................................................................................................2 1.3 Tujuan dan M anfaat .............................................................................................2 1.4 M etodologi Penelitian..........................................................................................3 1.5 Sistematika Penulisan ..........................................................................................5 BAB 2 LANDASAN TEORI ..............................................................................................7 2.1 Teori Umum.........................................................................................................7 2.1.1 Pendekatan File – Based ................................................................................7 2.1.2 Pendekatan Basis data....................................................................................7 2.1.2.a Data ..........................................................................................................7 2.1.2.b Basis Data ................................................................................................7 2.1.2.c Database M anagement System (DBM S) .................................................8 a. Pengertian DBM S.........................................................................................8 b. Keuntungan DBM S ......................................................................................9 c. Kerugian DBM S .........................................................................................12 d. Fungsi-Fungsi DBM S.................................................................................14 e. Komponen DBM S ......................................................................................16 2.1.2.d Database Environment ...........................................................................17 x
a. Database Language .....................................................................................17 1). Data Definition Language (DDL) ..........................................................17 2). Data M anipulation Language (DM L).....................................................18 b. Data M odel .................................................................................................18 c. Aturan dalam Lingkungan Database ..........................................................18 1). Data dan Database Administration.........................................................18 2). Pendesain Database ................................................................................19 3). Pengembang Aplikasi.............................................................................19 4). Pengguna Akhir ......................................................................................20 2.1.2.e Database Application LifeCycle ............................................................21 a. Siklus Hidup Sistem Informasi ...................................................................21 b. Siklus Hidup Aplikasi Database .................................................................22 1). Perencanaan Basis Data..........................................................................22 2). Definisi Sistem .......................................................................................22 3). Pengumpulan dan Analisis Kebutuhan...................................................22 4). Desain Basis Data...................................................................................22 5). Pemilihan DBM S ...................................................................................22 6). Desain Aplikasi ......................................................................................23 7). Prototyping .............................................................................................23 8). Implementasi ..........................................................................................23 9). Data Konversi dan Loading....................................................................23 10). Uji coba ................................................................................................23 11). Pemeliharaan Operasional ....................................................................23 2.1.2.f Relational Database M anagement System (RDBM S)............................23 a. Struktur Data Relational .............................................................................24 1). Relasional ...............................................................................................24 2). Attribut ...................................................................................................24 3). Domain ...................................................................................................24 4). Tuple.......................................................................................................24 5). Degree ....................................................................................................24 6). Cardinality ..............................................................................................24 xi
7). Relasional Database ...............................................................................24 b. Terminologi Alternatif................................................................................25 c. Relational Keys...........................................................................................25 1). Super Key ...............................................................................................25 2). Candidate Key ........................................................................................25 3). Primary Key ...........................................................................................26 4). Foreign Key ............................................................................................26 5). Composite Key .......................................................................................26 d. Relational Integrity .....................................................................................26 1). NULL .....................................................................................................26 2). Integritas Entity ......................................................................................26 3). Referensi Integritas.................................................................................27 4). Constraint Perusahaan ............................................................................27 5). Relasi Dasar............................................................................................27 a). Views ...................................................................................................27 (1). Keuntungan-Keuntungan dari Views ..............................................27 (a). Independent Data..........................................................................27 (b). Currency.......................................................................................28 (c). M engembangkan Keamanan ........................................................28 (d). M engurangi Kompleksitas ...........................................................28 (e). Kenyamanan.................................................................................28 (f). Customization ...............................................................................29 (g). Integritas Data ...............................................................................29 (2). Kerugian-Kerugian dari Views .......................................................29 (a). Pembatasan Pembaharuan ............................................................29 (b). Pembatasan Struktur ....................................................................29 (c). Pekerjaan ......................................................................................29 2.1.2.g Entity - Relationship M odeling (ER Models) ........................................30 a. Tipe Entity ...............................................................................................30 1). Tipe Entity Kuat ..................................................................................30 2). Tipe Entity Lemah...............................................................................30 xii
b. Tipe Relationship.....................................................................................30 c. Structure Constraints................................................................................31 2.1.2.h Normalisasi ............................................................................................31 a. Pengertian Normalisasi ...............................................................................31 b. Ketergantungan Fungsional ........................................................................32 c. Proses Normalisasi......................................................................................32 1). First Normal Form (1NF) ...................................................................32 2). Second Normal Form (2NF)................................................................32 3). Third Normal Form (3NF) ..................................................................33 2.1.3 Perancangan Basis Data (Phase of Database design) .................................33 2.1.3.a Perancangan Desain Basis Data Konseptual..........................................33 2.1.3.b Perancangan Desain Basis Data Logikal ...............................................35 2.1.3.c Perancangan Desain Basis Data Fisikal .................................................37 2.1.4 M icrosoft SQL Server 2000.........................................................................40 2.1.4.a Sejarah SQL ...........................................................................................40 2.1.4.b M anipulasi data......................................................................................41 2.1.4.c Queries ...................................................................................................41 2.1.4.d SQL Aggregate Functions .....................................................................42 2.2 Teori Khusus......................................................................................................42 2.2.1 PHP..............................................................................................................42 2.2.2 Adobe Dreamweaver CS3 ...........................................................................43 2.2.3 Internet .........................................................................................................43 2.2.4 Web..............................................................................................................44 2.2.5 Protokol........................................................................................................44 2.2.5.a TCP/IP....................................................................................................44 2.2.5.b HTTP .....................................................................................................45 2.2.6 Enhanced ER Models ...................................................................................45 2.2.6.a State Transition Diagram (STD) .......................................................45 2.2.6.b Entity Relationship Diagram (ERD) ..................................................45 2.2.6.c Data Flow Diagram (DFD) ................................................................46 2.2.6.d Flowchart ............................................................................................46 xiii
2.2.7 Teori Sistem.................................................................................................46 2.2.8 Standard Operation Procedure (SOP) ..........................................................46 2.2.9 Project M anagement M ethodology (PMM).................................................47 2.2.10 Teori PM O.................................................................................................47 2.2.10.a Teori PMO Timesheet ..........................................................................47 2.2.10.b Teori PMO Library..............................................................................47 BAB 3 ANALISA SISTEM YANG BERJALAN ............................................................49 3.1 Sejarah Perusahaan ............................................................................................49 3.2 Visi, M isi, dan M otto Perusahaan......................................................................50 3.3 Struktur Organisasi ............................................................................................51 3.4 Tugas dan Wewenang........................................................................................51 3.5 Sistem Yang Sedang Berjalan ...........................................................................54 3.5.1 Diagram Konteks ......................................................................................54 3.5.2 DFD level 0...............................................................................................55 3.5.3 DFD level 1...............................................................................................56 3.6 Standard Operation Procedure (SOP) ................................................................56 3.7 Project Management Methodology (PMM ).......................................................57 3.8 Sistem PM O.......................................................................................................59 3.8.1 PM O Timesheet ........................................................................................59 3.8.2 PM O Library.............................................................................................64 3.9 Permasalahan Yang Dihadapi............................................................................64 3.10 Usulan Pemecahan M asalah ............................................................................65 BAB 4 PERANCANGAN DAN IM PLEM ENTASI ........................................................66 4.1 Usulan Prosedur Baru ........................................................................................66 4.1.1 DFD ..........................................................................................................67 4.1.1.a Diagram Konteks ................................................................................67 4.1.1.b DFD level 0.........................................................................................68 4.1.1.c DFD level 1.........................................................................................69 4.2 Perancangan Database .......................................................................................70 4.2.1 Konseptual Database Desain ....................................................................70 4.2.1.a Identifikasi Tipe Entitas......................................................................70 xiv
4.2.1.b Identifikasi Tipe Relasi Antar Entitas.................................................73 4.2.1.c Identifikasi dan Asosiasi Attribute Suatu Entity.................................76 4.2.1.d Identifikasi Attribute Domain Entitas Perancangan ...........................89 4.2.1.e Identifikasi Attribute Candidate dan Primary Key .............................99 4.2.1.f Penggunaan Enhanced M odelling Concept.......................................103 4.2.1.g M engecek Redundancy pada M odel.................................................103 a. M emeriksa hubungan one-to-one (1:1)..................................................103 b. M enghapus relasi yang menimbulkan redundan ...................................103 4.2.1.h Validasi M odel Konseptual Lokal Terhadap Transaksi Pengguna...104 4.2.2 Logikal Database Desain ........................................................................106 4.2.2.a M enghilangkan Fitur–Fitur yang Tidak Kompatibel ........................106 a. M enghilangkan M any-to-many (*:*) Tipe Relasi Biner .......................107 b. M enghilangkan tipe hubungan rekursif M any-to-many .......................108 c. M enghilangkan tipe hubungan kompleks ..............................................108 d. M enghilangkan multi-value attribute.....................................................108 4.2.2.b M embuat Relasi Untuk M odel Data Logikal....................................109 4.2.2.c M engidentifikasi tipe relasi one-to-many (1:*) binary .....................112 4.2.2.d M engidentifikasi tipe relasi one-to-one (1:1) binary ........................134 4.2.2.e Validasi Relasi M enggunakan Normalisasi ......................................136 4.2.2.f Validasi Relasi Terhadap Transaksi Pengguna .................................144 4.2.2.g M enentukan batasan integritas .........................................................146 4.2.2.h M enggabungkan model logikal data lokal ke dalam model global ..154 4.2.3 Fisikal Database Desain..........................................................................163 4.2.3.a M erancang Relasional Basis Data ....................................................163 4.2.3.b Query Relasional Basis Data ............................................................189 4.2.3.c Analisis Transaksi .............................................................................205 4.2.3.d Pemilihan Indeks ..............................................................................223 4.2.3.e Estimasi Ukuran M edia Penyimpanan..............................................227 4.3 Perancangan Aplikasi ......................................................................................245 4.3.1 Perancangan Struktur M enu (Structure Chart) .......................................245 4.3.1.a Perancangan Struktur M enu PMO Timesheet ..................................247 xv
4.3.1.b Perancangan Struktur M enu PM O Library.......................................253 4.3.2 State Transition Diagram (STD).............................................................254 4.3.2.a STD PM O TimeSheet .......................................................................255 4.3.2.b STD PM O Library ............................................................................271 4.3.3 Perancangan Layar..................................................................................272 4.3.3.a Perancangan Layar Input ..................................................................273 4.3.3.b Perancangan Layar Output ...............................................................290 4.4 Implementasi....................................................................................................306 4.4.1 Spesifikasi Perangkat Keras ...................................................................306 4.4.2 Spesifikasi Perangkat Lunak...................................................................307 4.4.3 Jadwal Implementasi ..............................................................................307 4.4.4 Kebutuhan Sumber Daya ........................................................................308 4.4.5 Tampilan Layar.......................................................................................309 4.4.5.a Tampilan Layar Input .......................................................................309 4.4.5.b Tampilan Layar Output.....................................................................343 4.5 Evaluasi Aplikasi .............................................................................................370 BAB 5 SIM PULAN DAN SARAN ................................................................................372 5.1 Simpulan ..........................................................................................................372 5.2 Saran ................................................................................................................373 DAFTAR PUSTAKA......................................................................................................374 RIWAYAT HIDUP .........................................................................................................376 LAMPIRAN ..................................................................................................................... L1 SURAT SUVEY
xvi
DAFTAR TABEL
Tabel 2.1 Relasional M odel ............................................................................................ 25 Tabel 4.1 Identifikasi Tipe Entitas.................................................................................. 70 Tabel 4.2 Identifikasi Tipe Relasi ................................................................................... 73 Tabel 4.3 Identifikasi Attribute Tabel ProjectInit ........................................................... 76 Tabel 4.4 Identifikasi Attribute Tabel ProjectProposed.................................................. 78 Tabel 4.5 Identifikasi Attribute Tabel M sPrjM ehodStage.............................................. 80 Tabel 4.6 Identifikasi Attribute Tabel M sPrjActGroup .................................................. 81 Tabel 4.7 Identifikasi Attribute Tabel M sProjectCat...................................................... 81 Tabel 4.8 Identifikasi Attribute Tabel M sBranch ........................................................... 82 Tabel 4.9 Identifikasi Attribute Tabel M sPrjTeamPos ................................................... 82 Tabel 4.10 Identifikasi Attribute Tabel M sUser ............................................................... 83 Tabel 4.11 Identifikasi Attribute Tabel M sDomicile........................................................ 83 Tabel 4.12 Identifikasi Attribute Tabel M sEmployee ...................................................... 84 Tabel 4.13 Identifikasi Attribute Tabel M sStatus............................................................. 86 Tabel 4.14 Identifikasi Attribute Tabel M sGender........................................................... 86 Tabel 4.15 Identifikasi Attribute Tabel M sReligion ......................................................... 86 Tabel 4.16 Identifikasi Attribute Tabel M sTrainingCourseCat ........................................ 87 Tabel 4.17 Identifikasi Attribute Tabel M sRiskM gmtComponent ................................... 87 Tabel 4.18 Identifikasi Attribute Tabel M sEvalIndicator ................................................. 88 Tabel 4.19 Identifikasi Attribute Domain Tabel ProjectInit ............................................. 89 Tabel 4.20 Identifikasi Attribute Domain Tabel ProjectProposed.................................... 90 Tabel 4.21 Identifikasi Attribute Domain Tabel M sPrjM ehodStage ................................ 92 Tabel 4.22 Identifikasi Attribute Domain Tabel M sPrjActGroup .................................... 93 Tabel 4.23 Identifikasi Attribute Domain Tabel M sProjectCat ........................................ 93 Tabel 4.24 Identifikasi Attribute Domain Tabel M sBranch ............................................. 93 Tabel 4.25 Identifikasi Attribute Domain Tabel M sPrjTeamPos ..................................... 94 Tabel 4.26 Identifikasi Attribute Domain Tabel M sUser ................................................. 94 Tabel 4.27 Identifikasi Attribute Domain Tabel M sDomicile .......................................... 95 xvii
Tabel 4.28 Identifikasi Attribute Domain Tabel M sEmployee......................................... 95 Tabel 4.29 Identifikasi Attribute Domain Tabel M sStatus............................................... 97 Tabel 4.30 Identifikasi Attribute Domain Tabel M sGender ............................................. 97 Tabel 4.31 Identifikasi Attribute Domain Tabel M sReligion ........................................... 97 Tabel 4.32 Identifikasi Attribute Domain Tabel M sTrainingCourseCat .......................... 97 Tabel 4.33 Identifikasi Attribute Domain Tabel M sRiskM gmtComponent ..................... 98 Tabel 4.34 Identifikasi Attribute Domain Tabel M sEvalIndicator ................................... 99 Tabel 4.35 Identifikasi Attribute Candidate dan Primary Key ......................................... 99 Tabel 4.36 Identifikasi Tipe Relasi 1:* ProjectInitID ke MsPrjTeamPos ...................... 112 Tabel 4.37 Identifikasi Tipe Relasi 1:* EvalIndicatorID ke ProjectInit ......................... 113 Tabel 4.38 Identifikasi Tipe Relasi 1:* RiskM gmtComponentID ke ProjectInit ........... 115 Tabel 4.39 Identifikasi Tipe Relasi 1:* PrjActGroupID ke ProjectProposed................. 116 Tabel 4.40 Identifikasi Tipe Relasi 1:* ProjectCatID ke ProjectProposed..................... 117 Tabel 4.41 Identifikasi Tipe Relasi 1:* BranchID ke ProjectProposed .......................... 119 Tabel 4.42 Identifikasi Tipe Relasi 1:* UserID ke M sEmployee ................................... 121 Tabel 4.43 Identifikasi Tipe Relasi 1:* DomicileID ke M sEmployee............................ 122 Tabel 4.44 Identifikasi Tipe Relasi 1:* FM aritalStatus ke MsEmployee ....................... 124 Tabel 4.45 Identifikasi Tipe Relasi 1:* BranchID ke M sEmployee ............................... 126 Tabel 4.46 Identifikasi Tipe Relasi 1:* FGender ke M sEmployee................................. 127 Tabel 4.47 Identifikasi Tipe Relasi 1:* FReligion ke M sEmployee............................... 129 Tabel 4.48 Identifikasi Tipe Relasi 1:* TrainingCourseCatID ke M sEmployee............ 131 Tabel 4.49 Identifikasi Tipe Relasi 1:* PrjM ethodStageID ke M sEmployee................. 132 Tabel 4.50 Identifikasi Tipe Relasi 1:1 ProjectInitID ke ProjectProposed..................... 134 Tabel 4.51 Tabel Batasan Integritas................................................................................ 147 Tabel 4.52 Tabel M odel Data Logikal Global ................................................................ 155 Tabel 4.53 Tabel Analisis Transaksi 1............................................................................ 206 Tabel 4.54 Tabel Analisis Transaksi 2............................................................................ 209 Tabel 4.55 Tabel Analisis Transaksi 3............................................................................ 211 Tabel 4.56 Tabel Analisis Transaksi 4............................................................................ 213 Tabel 4.57 Tabel Analisis Transaksi 5............................................................................ 216 xviii
Tabel 4.58 Tabel Analisis Transaksi 6............................................................................ 218 Tabel 4.59 Tabel Analisis Transaksi 7............................................................................ 221 Tabel 4.60 Tabel Pemilihan Indeks................................................................................. 223 Tabel 4.61 Tabel Estimasi Disk Space M sEvalIndicator ................................................ 227 Tabel 4.62 Tabel Estimasi Disk Space M sEvalIndicatorGroup...................................... 228 Tabel 4.63 Tabel Estimasi Disk Space TrProjectEval .................................................... 228 Tabel 4.64 Tabel Estimasi Disk Space M sRiskM gmtComponent .................................. 229 Tabel 4.65 Tabel Estimasi Disk Space TrPrjRiskM gmtInit............................................ 229 Tabel 4.66 Tabel Estimasi Disk Space M sRiskM gmtCat ............................................... 230 Tabel 4.67 Tabel Estimasi Disk Space ProjectProposed................................................. 230 Tabel 4.68 Tabel Estimasi Disk Space TrProjectProposedDoc ...................................... 232 Tabel 4.69 Tabel Estimasi Disk Space M sPrjActGroup ................................................. 232 Tabel 4.70 Tabel Estimasi Disk Space M sProjectCat..................................................... 233 Tabel 4.71 Tabel Estimasi Disk Space M sTrainingCourseCat ....................................... 233 Tabel 4.72 Tabel Estimasi Disk Space TrEmpTrainingCourse ...................................... 233 Tabel 4.73 Tabel Estimasi Disk Space TrEmpTrainingCourseDtl ................................. 234 Tabel 4.74 Tabel Estimasi Disk Space M sDomicile....................................................... 234 Tabel 4.75 Tabel Estimasi Disk Space M sRegion .......................................................... 235 Tabel 4.76 Tabel Estimasi Disk Space M sPrjTeamPos .................................................. 235 Tabel 4.77 Tabel Estimasi Disk Space M sPrjTeamPosCriteria ...................................... 236 Tabel 4.78 Tabel Estimasi Disk Space TrPrjTeamPosInit .............................................. 236 Tabel 4.79 Tabel Estimasi Disk Space TrPrjTeamPosCriteriaInit.................................. 236 Tabel 4.80 Tabel Estimasi Disk Space ProjectInit .......................................................... 237 Tabel 4.81 Tabel Estimasi Disk Space TrProjectInitDoc ............................................... 238 Tabel 4.82 Tabel Estimasi Disk Space TrPrjWorkPercentage........................................ 239 Tabel 4.83 Tabel Estimasi Disk Space TrPrjTaskActivityInput ..................................... 239 Tabel 4.84 Tabel Estimasi Disk Space M sPrjM ethodStage............................................ 240 Tabel 4.85 Tabel Estimasi Disk Space M sM ethodCat.................................................... 240 Tabel 4.86 Tabel Estimasi Disk Space M sBranch .......................................................... 241 Tabel 4.87 Tabel Estimasi Disk Space M sUnit............................................................... 241 xix
Tabel 4.88 Tabel Estimasi Disk Space M sEmployee ..................................................... 241 Tabel 4.89 Tabel Estimasi Disk Space M sGender.......................................................... 243 Tabel 4.90 Tabel Estimasi Disk Space M sStatus............................................................ 243 Tabel 4.91 Tabel Estimasi Disk Space M sReligion ........................................................ 244 Tabel 4.92 Tabel Estimasi Disk Space M sUser .............................................................. 244 Tabel 4.93 Tabel Estimasi Disk Space TrM entoring ...................................................... 244 Tabel 4.94 Tabel Estimasi Disk Space TrPrjTeamPosCandidate ................................... 245 Tabel 4.95 Tabel Jadwal Implementasi........................................................................... 307
xx
DAFTAR GAMBAR
Gambar 2.1
The Database Application Lifecycle...........................................................21
Gambar 3.1
Struktur Organisasi .....................................................................................51
Gambar 3.2
Diagram Konteks Sistem Yang Sedang Berjalan .......................................54
Gambar 3.3
DFD level 0 Sistem Yang Sedang Berjalan................................................55
Gambar 3.4
DFD level 1 Sistem Yang Sedang Berjalan................................................56
Gambar 3.5
Flowchart PMM..........................................................................................57
Gambar 3.6
Flowchart PMO Timesheet .........................................................................60
Gambar 4.1
Diagram Konteks Sistem PMO...................................................................67
Gambar 4.2
DFD level 0 Sistem PM O...........................................................................68
Gambar 4.3
DFD level 1 Sistem PM O...........................................................................75
Gambar 4.4
Entity Relationship Diagram (ERD) Konseptual Awal..............................74
Gambar 4.5
Entity Relationship Diagram (ERD) dengan Primary Key.......................102
Gambar 4.6
ERD Konseptual dengan Jalur-Jalur Transaksi ........................................105
Gambar 4.7 Relasi M any-to-many (*:*) ProjectInit dengan M sEmployee...................107 Gambar 4.8 Relasi M any-to-many (*:*) MsEmployee dengan M sPrjTeamPos ...........108 Gambar 4.9 ERD Logikal dengan Jalur-Jalur Transaksi ...............................................144 Gambar 4.10 M odel Data Logikal Global .......................................................................162 Gambar 4.11 Struktur M enu Login .................................................................................246 Gambar 4.12 Struktur M enu Utama PM O Timesheet .....................................................247 Gambar 4.13 Struktur M enu Progress .............................................................................248 Gambar 4.14 Struktur Sub M enu M etodologi M onitoring & Reporting.........................248 Gambar 4.15 Struktur Sub M enu Team Assignment M onitoring & Reporting ..............249 Gambar 4.16 Struktur Sub M enu Risk M anagement M onitoring & Reporting .............249 Gambar 4.17 Struktur Sub M enu Project Work Percentage M onitoring & Reporting ...250 Gambar 4.18 Struktur Sub M enu Pos Project M onitoring & Reporting .........................250 Gambar 4.19 Struktur Sub M enu M etodologi Review ....................................................251 Gambar 4.20 Struktur Sub M enu Risk M anagement Review .........................................251 Gambar 4.21 Struktur Sub M enu Project Work Percentage Review...............................252 xxi
Gambar 4.22 Struktur M enu Utama PM O Library..........................................................253 Gambar 4.23 Struktur M enu PMO Library .....................................................................254 Gambar 4.24 STD Login .................................................................................................254 Gambar 4.25 STD PMO Timesheet.................................................................................255 Gambar 4.26 STD M enu Utama PMO Timesheet...........................................................256 Gambar 4.27 STD M enu Selection & Priorization..........................................................257 Gambar 4.28 STD M enu Registration .............................................................................257 Gambar 4.29 STD M enu Team Assignment ...................................................................258 Gambar 4.30 STD M enu M onitoring & Reporting .........................................................258 Gambar 4.31 STD Sub M enu M etodologi M onitoring & Reporting ..............................259 Gambar 4.32 STD Sub M enu View M etodologi M onitoring & Reporting.....................260 Gambar 4.33 STD Sub M enu Team Activity Monitoring & Reporting..........................261 Gambar 4.34 STD Sub M enu Risk M anagement M onitoring & Reporting....................262 Gambar 4.35 STD Sub M enu Risk M anagement Categori M onitoring & Reporting .....263 Gambar 4.36 STD Sub M enu Input Risk M anagement Categori ...................................264 Gambar 4.37 STD M enu Review ....................................................................................265 Gambar 4.38 STD Sub M enu M etodologi Review .........................................................265 Gambar 4.39 STD Sub M enu View M etodologi Review ................................................266 Gambar 4.40 STD Sub M enu Input Risk M anagementReview ......................................267 Gambar 4.41 STD Sub M enu View Risk M anagement Review .....................................268 Gambar 4.42 STD Sub M enu Project Work Percentage Review ....................................269 Gambar 4.43 STD M enu Post Project Review ................................................................269 Gambar 4.44 STD M enu Archieve ..................................................................................270 Gambar 4.45 STD M enu Training dan Development .....................................................270 Gambar 4.46 STD M enu M entoring................................................................................270 Gambar 4.47 STD PMO Library .....................................................................................271 Gambar 4.48 STD M enu Utama PMO Library ...............................................................271 Gambar 4.49 STD M enu Template PM O Library...........................................................272 Gambar 4.50 STD M enu Search PM O Library ...............................................................272 Gambar 4.51 Perancangan halaman Login ......................................................................273 xxii
Gambar 4.52 Perancangan halaman ganti password .......................................................273 Gambar 4.53 Perancangan halaman menu Selection & Priorization...............................274 Gambar 4.54 Perancangan halaman selection approved .................................................275 Gambar 4.55 Perancangan halaman registration .............................................................276 Gambar 4.56 Perancangan halaman update form ............................................................277 Gambar 4.57 Perancangan halaman menu Registration ..................................................278 Gambar 4.58 Perancangan halaman assignment view .....................................................278 Gambar 4.59 Perancangan halaman assignment employee .............................................279 Gambar 4.60 Perancangan halaman add position............................................................279 Gambar 4.61 Perancangan halaman resiko analisa menu M onitoring ............................280 Gambar 4.62 Perancangan halaman metodologi insert ...................................................280 Gambar 4.63 Perancangan halaman activity insert..........................................................281 Gambar 4.64 Perancangan halaman project work percentage edit ..................................281 Gambar 4.65 Perancangan halaman konfirmasi edit .......................................................282 Gambar 4.66 Perancangan halaman close project ...........................................................282 Gambar 4.67 Perancangan halaman konfirmasi close project .........................................283 Gambar 4.68 Perancangan halaman metodologi edit ......................................................283 Gambar 4.69 Perancangan halaman konfirmasi metodologi edit ....................................284 Gambar 4.70 Perancangan halaman resiko analisa menu Review ..................................284 Gambar 4.71 Perancangan halaman review percentage ..................................................285 Gambar 4.72 Perancangan halaman percen edit ..............................................................285 Gambar 4.73 Perancangan halaman project post review.................................................286 Gambar 4.74 Perancangan halaman project post review detail .......................................286 Gambar 4.75 Perancangan halaman post review edit ......................................................287 Gambar 4.76 Perancangan halaman konfirmasi post review edit....................................287 Gambar 4.77 Perancangan halaman training add ............................................................288 Gambar 4.78 Perancangan halaman konfirmasi training add ..........................................288 Gambar 4.79 Perancangan halaman menu Template ......................................................289 Gambar 4.80 Perancangan halaman template edit...........................................................289 Gambar 4.81 Perancangan halaman konfirmasi template edit ........................................290 xxiii
Gambar 4.82 Perancangan halaman menu Timesheet .....................................................290 Gambar 4.83 Perancangan halaman project detail ..........................................................291 Gambar 4.84 Perancangan halaman selection detail .......................................................291 Gambar 4.85 Perancangan halaman menu Team Assignment .......................................292 Gambar 4.86 Perancangan halaman assignment employee search..................................292 Gambar 4.87 Perancangan halaman menu M onitoring ...................................................293 Gambar 4.88 Perancangan halaman monitoring view .....................................................293 Gambar 4.89 Perancangan halaman resiko analisa view .................................................294 Gambar 4.90 Perancangan halaman metodologi .............................................................294 Gambar 4.91 Perancangan halaman team activity...........................................................295 Gambar 4.92 Perancangan halaman project work percentage.........................................295 Gambar 4.93 Perancangan halaman menu Review .........................................................296 Gambar 4.94 Perancangan halaman review metodologi .................................................296 Gambar 4.95 Perancangan halaman konfirmasi review metodologi ...............................297 Gambar 4.96 Perancangan halaman review risk management ........................................298 Gambar 4.97 Perancangan halaman resiko analisa view .................................................298 Gambar 4.98 Perancangan halaman konfirmasi resiko analisa view ..............................299 Gambar 4.99 Perancangan halaman menu Post Review .................................................299 Gambar 4.100 Perancangan halaman manu Archieve .....................................................300 Gambar 4.101 Perancangan halaman archieve view .......................................................300 Gambar 4.102 Perancangan halaman menu Training......................................................301 Gambar 4.103 Perancangan halaman training view ........................................................301 Gambar 4.104 Perancangan halaman training view name...............................................302 Gambar 4.105 Perancangan halaman menu M entoring...................................................302 Gambar 4.106 Perancangan halaman mentoring view ....................................................303 Gambar 4.107 Perancangan halaman konfirmasi mentoring view ..................................303 Gambar 4.108 Perancangan halaman mentoring add ......................................................304 Gambar 4.109 Perancangan halaman menu Library........................................................304 Gambar 4.110 Perancangan halaman library view ..........................................................305 Gambar 4.111 Perancangan halaman menu Search.........................................................305 xxiv
Gambar 4.112 Tampilan layar Login...............................................................................309 Gambar 4.113 Tampilan layar ganti password................................................................310 Gambar 4.114 Tampilan layar menu Selection & Priorization .......................................311 Gambar 4.115 Tampilan layar selection approved..........................................................312 Gambar 4.116 Tampilan layar registration ......................................................................314 Gambar 4.117 Tampilan layar update form.....................................................................316 Gambar 4.118 Tampilan layar menu Registration...........................................................318 Gambar 4.119 Tampilan layar assignment view .............................................................319 Gambar 4.120 Tampilan layar assignment employee......................................................321 Gambar 4.121 Tampilan layar add position ....................................................................323 Gambar 4.122 Tampilan layar resiko analisa menu M onitoring .....................................324 Gambar 4.123 Tampilan layar metodologi insert ............................................................325 Gambar 4.124 Tampilan layar activity insert ..................................................................326 Gambar 4.125 Tampilan layar project work percentage edit ..........................................327 Gambar 4.126 Tampilan layar konfirmasi edit ................................................................328 Gambar 4.127 Tampilan layar close project ....................................................................328 Gambar 4.128 Tampilan layar konfirmasi close project .................................................329 Gambar 4.129 Tampilan layar metodologi edit ...............................................................330 Gambar 4.130 Tampilan layar konfirmasi metodologi edit.............................................331 Gambar 4.131 Tampilan layar resiko analisa menu Review ...........................................332 Gambar 4.132 Tampilan layar review percentage ...........................................................333 Gambar 4.133 Tampilan layar percen edit ......................................................................334 Gambar 4.134 Tampilan layar project post review .........................................................335 Gambar 4.135 Tampilan layar project post review detail................................................336 Gambar 4.136 Tampilan layar post review edit...............................................................337 Gambar 4.137 Tampilan layar konfirmasi post review edit ............................................338 Gambar 4.138 Tampilan layar training add .....................................................................339 Gambar 4.139 Tampilan layar konfirmasi training add...................................................340 Gambar 4.140 Tampilan layar menu Template ...............................................................341 Gambar 4.141 Tampilan layar template edit ...................................................................342 xxv
Gambar 4.142 Tampilan layar konfirmasi template edit .................................................343 Gambar 4.143 Tampilan layar menu Timesheet..............................................................343 Gambar 4.144 Tampilan layar project detail ...................................................................344 Gambar 4.145 Tampilan layar selection detail ................................................................345 Gambar 4.146 Tampilan layar menu Team Assignment ................................................346 Gambar 4.147 Tampilan layar assignment employee search ..........................................347 Gambar 4.148 Tampilan layar menu M onitoring ............................................................348 Gambar 4.149 Tampilan layar monitoring view..............................................................349 Gambar 4.150 Tampilan layar resiko analisa view .........................................................350 Gambar 4.151 Tampilan layar metodologi ......................................................................351 Gambar 4.152 Tampilan layar team activity ...................................................................352 Gambar 4.153 Tampilan layar project work percentage .................................................353 Gambar 4.154 Tampilan layar menu Review ..................................................................354 Gambar 4.155 Tampilan layar review metodologi ..........................................................355 Gambar 4.156 Tampilan layar konfirmasi review metodologi........................................356 Gambar 4.157 Tampilan layar review risk management .................................................357 Gambar 4.158 Tampilan layar resiko analisa view .........................................................358 Gambar 4.159 Tampilan layar konfirmasi resiko analisa view .......................................358 Gambar 4.160 Tampilan layar menu Post Review ..........................................................359 Gambar 4.161 Tampilan layar manu Archieve................................................................360 Gambar 4.162 Tampilan layar archieve view ..................................................................361 Gambar 4.163 Tampilan layar menu Training ................................................................362 Gambar 4.164 Tampilan layar training view ...................................................................362 Gambar 4.165 Tampilan layar training view name .........................................................363 Gambar 4.166 Tampilan layar menu M entoring .............................................................364 Gambar 4.167 Tampilan layar mentoring view ...............................................................365 Gambar 4.168 Tampilan layar konfirmasi mentoring view.............................................366 Gambar 4.169 Tampilan layar mentoring add .................................................................367 Gambar 4.170 Tampilan layar menu Library ..................................................................368 Gambar 4.171 Tampilan layar library view.....................................................................369 xxvi
Gambar 4.172 Tampilan layar menu Search ...................................................................370
xxvii