ABSTRAK Pembangunan Kompleks Bumi Mekar Sari adalah proyek pembangunan yang membutuhkan sistem informasi yang baik agar proses operasional pembangunan perumahan dapat berjalan sesuai harapan. Sistem informasi perencanaan dan pengawasan sangat dibutuhkan untuk membantu unit-unit pembangunan yang membutuhkan data informasi tentang hal-hal yang dibutuhkan unit tersebut. Sistem informasi ini dirancang untuk bisa memenuhi kebutuhan proyek pembangunan dari segi pengadaan barang hingga sumber daya manusia. Notifikasi progress pembangunan perumahan yang diberikan kepada pemilik rumah pun ada di dalamnya untuk menunjang komunikasi antara pihak pengembang dan konsumen. Di dalam sistem informasi ini, diharapkan pengguna mampu mengolah semua pembukuan operasional dilapakan. Sistem informasi ini mengelola pendataan alat berat, pendataan buruh, pendataan material, serta detil dari suatu bangunan. Sistem informasi ini mencatat setiap keuangan operasionalnya dalam kegiatan operasional. Kata Kunci:Sistem Informasi, Pembangunan Perumahan, Pengadaan, Pengawasan Proyek
vi
ABSTRACT Kompleks Bumi Mekar is a development project that requires good information systems that residential development of operational processes to run as expected. Information systems planning and monitoring are needed to assist the development of units of information that need data about things that it takes the unit. This information system is designed to meet the needs of development projects in terms of procurement to human resources. Housing construction progress notification is given to the owner of the house was nothing in it to support communication between the developers and consumers. In the information system, the users are expected to be able to process all operational accounting dilapakan. The information system manages data collection heavy equipment, labor data collection, data collection materials, as well as details of a building. This information system is operational in a record every financial operations. Keywords: Information System, House Development,Procurement,Project Monitoring.
vii
DAFTAR ISI PERNYATAAN ORISINALITAS LAPORAN PENELITIAN .............................. ii PERNYATAAN PUBLIKASI LAPORAN PENELITIAN .................................. iii PRAKATA ...................................................................................................... iv ABSTRAK ...................................................................................................... vi ABSTRACT ................................................................................................... vii DAFTAR ISI ................................................................................................. viii DAFTAR GAMBAR ....................................................................................... xii DAFTAR TABEL .......................................................................................... xiv DAFTAR NOTASI/ LAMBANG .................................................................... xvii BAB 1.
PENDAHULUAN ............................................................................1
1.1
Latar Belakang Masalah .................................................................. 1
1.2
Rumusan Masalah ........................................................................... 2
1.3
Tujuan Pembahasan........................................................................ 2
1.4
Ruang Lingkup Kajian...................................................................... 3
1.4.1
Aplikasi ....................................................................................... 3
1.4.2
Software ..................................................................................... 4
1.4.3
Hardware.................................................................................... 5
1.5
Sumber Data ................................................................................... 5
1.5.1
Primer......................................................................................... 5
1.5.1 Sekunder ....................................................................................... 5 1.6 BAB 2. 2.1
Sistematika Penyajian ..................................................................... 5 KAJIAN TEORI ...............................................................................8 Fungsi Manajemen .......................................................................... 8
2.2.1 Planning/Perencanaan................................................................... 8 2.2.2 Pengorganisasian/Organizing ........................................................ 9 2.2.3 Actuating/ Pelaksanaan ................................................................. 9 2.2.3 Controling/ Pengendalian............................................................... 9 2.2
Harga Bahan/Biaya Material ............................................................ 9
2.3
Flowchart ....................................................................................... 10
2.11.1 2.4
Pengertian/Definisi Flowchart ............................................... 10
ERD (Entity Reltionship Diagram) ................................................. 11 viii
2.4.1
Entitas (Tipe Entity) .................................................................. 11
2.4.2
Atribut ....................................................................................... 11
2.4.3
Relasi ....................................................................................... 12
2.4.4
Keys ......................................................................................... 13
2.4.5
Stuctural Contraints .................................................................. 13
2.4.6
Kardinalitas Relasi.................................................................... 14
2.4.7
Normalisasi .............................................................................. 15
2.4.8
First Normal Form (1NF) .......................................................... 15
2.6.12
Second Normal Form (2NF) .................................................. 16
2.6.13
ThirdNormal Form (3NF) ....................................................... 17
2.5
DFD (Data Flow Diagram) ............................................................. 17
2.5.1 Definisi Data Flow Diagram ........................................................ 17 2.5.2 Komponen Data Flow Diagram .................................................. 17 2.6
PHP ............................................................................................... 18
2.7
MySQL........................................................................................... 20
2.5.1 Data Definition Language (DDL) .................................................. 21 2.5.2 Data Manipulation Language (DML) ............................................ 21 2.8 HTML .............................................................................................. 22 2.7.1
Kelebihan HTML....................................................................... 22
2.7.2
Tag-tag Dasar HTML................................................................ 23
2.8
CSS (Cascading Style Sheets) ...................................................... 24
2.9.1 2.9
Penulisan Syntax CSS ............................................................. 24
JavaScript ...................................................................................... 25
2.10.1 Dasar Syntax JavaScript............................................................ 26 BAB 3. 3.1
ANALISIS DAN RANCANGAN SISTEM ....................................... 29 Proses Bisnis ................................................................................. 29
3.1.1
Proses Bisnis Pengadaan Material........................................... 29
3.1.2
Proses Pendataan Alat Berat ................................................... 31
3.1.3
Proses Pendataan Pekerja Bangunan ..................................... 32
3.1.4
Proses Bisinis Kalkulasi Keuangan Operasional ...................... 33
3.1.5
Proses Perhitungan Sisa Material di Gudang ........................... 34
3.1.6
Perhitungan Waktu Efektif Pembangunan ................................ 35 ix
3.1.7 3.2
Entity Relationship Diagram .......................................................... 36
3.2.1 3.3
Pendataan Progress Pembangunan ........................................ 35
Transformasi Diagram ER ........................................................ 37
Data Flow Diagram ........................................................................ 42
3.3.1
DFD Level 0 ............................................................................. 42
3.3.2
DFD Level 1 ............................................................................. 43
3.3.3
DFD Level 2 ............................................................................. 46
3.3.4
DFD Level 3 ............................................................................. 51
3.4
Kamus Data ................................................................................... 61
3.5
PSPEC .......................................................................................... 68
3.6
Perancangan Sketsa User Interface ............................................ 103
BAB 4.
BAB IV HASIL PENELITIAN ....................................................... 107
4.1
Halaman Login Sistem................................................................. 107
4.2
Halaman Dashboard Utama ........................................................ 108
4.3
Halaman Simulasi Bangunan ...................................................... 108
4.4
Halaman Informasi Kekurangan Material..................................... 109
4.5
Halaman Input & Update Data Bangunan.................................... 110
4.6
Halaman Input & Update Data Material ....................................... 111
4.7
Halaman Pengadaan Material ..................................................... 112
4.8
Halaman Pengadaan Buruh Bangunan & Alat Berat ................... 113
4.9
Halaman Laporan Operasional Harian ........................................ 114
4.10
Halaman Kirim Pemberitahuan Pemilik Bangunan ...................... 116
4.11
Halaman Isi Task Pembangunan ................................................. 116
BAB 5.
BAB V PEMBAHASAN DAN UJI COBA HASILPENELITIAN ..... 118
5.1
Login Sistem ................................................................................ 118
5.2
Dashboard Utama ....................................................................... 119
5.3
Simulasi Bangunan ...................................................................... 120
5.4
Informasi Kekurangan Material .................................................... 121
5.5
Input & Update Data Bangunan ................................................... 121
5.6
Input & Update Data Material ...................................................... 122
5.7
Pengadaan Material..................................................................... 123
5.8
Pengadaan Buruh Bangunan & Alat Berat .................................. 124 x
5.9
Laporan Operasional Harian ........................................................ 125
5.10
Isi Task Pembangunan ................................................................ 125
BAB 6.
SIMPULAN DAN SARAN ........................................................... 127
6.1
Simpulan...................................................................................... 127
6.2
Saran ........................................................................................... 128
DAFTAR PUSTAKA .................................................................................... 129 RIWAYAT HIDUP ................................................................................... 130
xi
DAFTAR GAMBAR Gambar 2.1 Contoh ERD Sederhana ........................................................... 14 Gambar 3.1 Proses Bisnis Pengadaan Material ........................................... 30 Gambar 3.2 Proses Pendataan Alat Berat .................................................... 31 Gambar 3.3 Proses Pendataan Pekerja Bangunan ...................................... 32 Gambar 3.4 Proses Bisnis Kalkulasi Keuangan Operasional ....................... 33 Gambar 3.5 Proses Bisnis Perhitungan Sisa Material di Gudang ................. 34 Gambar 3.6 Proses Bisnis Waktu Efektif Pembangunan .............................. 35 Gambar 3.7 Proses Bisnis Pendataan Progress Pembangunan................... 36 Gambar 3.8 Gambar ERD ............................................................................ 37 Gambar 3.9 DFD Level 0 Keseluruhan Sistem ............................................. 43 Gambar 3.10 DFD Level 1 Break Down Proses............................................ 45 Gambar 3.11 DFD Level 2 Olah Data Pegawai ............................................ 47 Gambar 3.12 DFD Level 2 Olah Data Material ............................................. 48 Gambar 3.13 DFD Level 2 Olah Data Vendor .............................................. 49 Gambar 3.14 DFD Level 2 Olah Alat Berat ................................................... 49 Gambar 3.15 DFD Level 2 Olah Data Pegawai ............................................ 50 Gambar 3.16 DFD Level 2 Olah Data Operasional Material ......................... 51 Gambar 3.17 DFD Level 2 Olah Data Keuangan .......................................... 51 Gambar 3.18 DFD Level 3 Olah Data Master Buruh..................................... 52 Gambar 3.19 DFD Level 3 Operasional Buruh ............................................. 53 Gambar 3.20 DFD Level 3 Olah Master Data Bangunan .............................. 54 Gambar 3.21 Olah Data Master Pemilik ....................................................... 55 Gambar 3.22 DFD Level 3 Olah Progress Bangunan ................................... 55 Gambar 3.23 DFD Level 3 Olah Data Master Alat Berat .............................. 56 Gambar 3.24 DFD Level 3 Olah Operasional Alat Berat............................... 57 Gambar 3.25 Olah Data Master Material ...................................................... 57 Gambar 3.26 Olah Data Pengadaan Material ............................................... 58 Gambar 3.27 DFD Level 3 Olah Data Master Pegawai ................................ 59 Gambar 3.28 DFD Level 3 Olah Data Master PIC ........................................ 60 Gambar 3.29 DFD Level 3 Olah Absen Pegawai .......................................... 61 Gambar 3.30 Gambar Perancangan Halaman Login .................................. 103 xii
Gambar 3.31 Gambar Perancangan Dashboard Utama ............................. 104 Gambar 3.32 Gambar Perancangan Tampilan Data dan Olah Data........... 105 Gambar 3.33 Gambar Perancangan Halaman Isian ................................... 105 Gambar 3.34 Gambar Perancangan Halaman Simulasi ............................. 106 Gambar 4.1 Gambar Hasil Penelitian LOGIN ............................................. 107 Gambar 4.2 Gambar Hasil Penelitian Dashboard Utama ........................... 108 Gambar 4.3 Gambar Hasil Penelitian Halaman Simulasi Bangunan .......... 109 Gambar 4.4 Gambar Hasil Penelitian Halaman Data Kekurangan Material 109 Gambar 4.5 Gambar Hasil Penelitian Tampilan Halaman Input / Update Bangunan ............................................................................................ 110 Gambar 4.6 Gambar Hasil Penelitian Tampilan Halaman Data bangunan . 111 Gambar 4.7 Gambar Hasil Penelitian Tampilan Data Material ................... 112 Gambar 4.8 gambar Hasil Penelitian Tampilan Input/Update Material ....... 112 Gambar 4.9 Gambar Hasil Penelitian Tampilan Halaman Pengadaan Material ................................................................................................ 113 Gambar 4.10 Gambar Hasil Penelitian Tampilan Halaman Input Buruh Kosong 114 Gambar 4.11 Gambar Hasil Penelitian Tampilan Halaman Input Buruh Kosong 114 Gambar
4.12
Gambar
Hasil
Penelitian
Halaman
Pilih
Tanggal
Operasional ......................................................................................... 115 Gambar 4.13 Gambar Hasil Penelitian Tampilan Halaman Data Keuangan Operasional ......................................................................................... 115 Gambar 4.14 Gambar Hasil Penelitian Tampilan Data Pemilik Bangunan . 116 Gambar 4.15 Gambar Hasil Penelitian Tampilan Data Task Bangunan ..... 117
xiii
DAFTAR TABEL Tabel 3.1 Transformasi ER tbbangunan ....................................................... 37 Tabel 3.2 Transformasi ER tbmaterial .......................................................... 38 Tabel 3.3 Transformasi ER tbburuh .............................................................. 38 Tabel 3.4 Transformasi ER tbalatberat ......................................................... 39 Tabel 3.5 Transformasi ER tbpemilikbangunan ............................................ 39 Tabel 3.6 Transformasi ER tbvendor ............................................................ 39 Tabel 3.7 Transformasi ER tbvendor ............................................................ 40 Tabel 3.8 Transformasi ER tbtask................................................................. 40 Tabel 3.9 Transformasi ER tbtaskbangunan ................................................. 40 Tabel 3.10 Transformasi ER tbpegawai ........................................................ 41 Tabel 3.11 Transformasi ER tbkomposisi ..................................................... 41 Tabel 3.12 Transformasi ER tbabasenpegawai ............................................ 41 Tabel 3.13 Kamus Data Storage tbbangunan ............................................... 62 Tabel 3.14 Kamus Data Storage tbpegawai ................................................. 62 Tabel 3.15 Kamus Data Storage tbalatberat ................................................. 63 Tabel 3.16 Kamus Data Storage tbburuh ...................................................... 64 Tabel 3.17 Kamus Data Storage tbmaterial .................................................. 64 Tabel 3.18 Kamus Data Storage tbpemilik .................................................... 65 Tabel 3.19 Kamus Data Storage tbpic .......................................................... 66 Tabel 3.20 Kamus Data Storage tbvendor .................................................... 66 Tabel 3.21 Kamus Data Storage tbbiayaoperasional .................................... 67 Tabel 3.22 PSPEC 1.1.1 Tambah Pegawai .................................................. 68 Tabel 3.23 PSPEC 1.1.2 Hapus Data Pegawai ............................................ 69 Tabel 3.24 PSPEC 1.1.3 Ubah Data Pegawai .............................................. 69 Tabel 3.25 PSPEC 1.1.4 Lihat Data Pegawai ............................................... 70 Tabel 3.26 PSPEC 1.2.1 Tambah Data PIC ................................................. 71 Tabel 3.27 PSPEC 1.2.2 Hapus Data PIC .................................................... 71 Tabel 3.28 PSPEC 1.2.3 Ubah Data PIC ...................................................... 72 Tabel 3.29 PSPEC 1.2.4 Lihat Data PIC ....................................................... 73 xiv
Tabel 3.30 PSPEC 1.3.1 Pengecekan Absen ............................................... 74 Tabel 3.31 PSPEC 1.3.2 Perhitungan Biaya PerJam ................................... 74 Tabel 3.32 PSPEC 1.3.3 Lihat Operasional Pegawai ................................... 75 Tabel 3.33 PSPEC 2.1.1 Tambah Data Material........................................... 75 Tabel 3.34 PSPEC 2.1.2 Hapus Data Material ............................................. 76 Tabel 3.35 PSPEC 2.1.3 Ubah Data Material ............................................... 77 Tabel 3.36 PSPEC 2.1.4 Lihat Data Material ................................................ 77 Tabel 3.37 PSPEC 2.2 Lihat Data Kekurangan Material ............................... 78 Tabel 3.38 PSPEC 2.3.1 Cek Kekurangan Material...................................... 79 Tabel 3.39 PSPEC 2.3.2 Ajukan Pengadaan ................................................ 79 Tabel 3.40 PSPEC 2.3.4 Konfirmasi Kedatangan Material ........................... 80 Tabel 3.41 PSPEC 2.3.4 Konfirmasi Pengadaan Material ............................ 80 Tabel 3.42 PSPEC 3.1.1 Tambah Data Vendor ............................................ 81 Tabel 3.43 PSPEC 3.1.2 Hapus Data Vendor .............................................. 82 Tabel 3.44 PSPEC 3.1.3 Ubah Data Vendor ................................................ 82 Tabel 3.45 PSPEC 3.1.4 Lihat Data Vendor ................................................. 83 Tabel 3.46 PSPEC 3.2 Olah Data Kontrak Vendor ....................................... 84 Tabel 3.47 PSPEC 4.1.1 Tambah Data Alat Berat........................................ 84 Tabel 3.48 PSPEC 4.1.2 Hapus Data Alat Berat .......................................... 85 Tabel 3.49 PSPEC 4.1.3 Ubah Data alat Berat............................................. 85 Tabel 3.50 PSPEC 4.1.4 Lihat Data Alat Berat ............................................. 86 Tabel 3.51 PSPEC 4.2.1 Aktifkan Alat Berat ................................................ 87 Tabel 3.52 PSPEC 4.2.2 NonAktifkan Alat Berat .......................................... 87 Tabel 3.53 PSPEC 4.2.3 Lihat Status Alat Berat .......................................... 88 Tabel 3.54 PSPEC 5.1.1 Tambah Data Bangunan ....................................... 88 Tabel 3.55 PSPEC 5.1.2 Hapus Data Bangunan .......................................... 89 Tabel 3.56 PSPEC 5.1.3 Ubah Data Bangunan ........................................... 89 Tabel 3.57 PSPEC 5.1.4 Lihat Data Bangunan ............................................ 90 Tabel 3.58 PSPEC 5.1.5 Pengecekan Material ............................................ 91 Tabel 3.59 PSPEC 5.2 Lihat Data Progress Bangunan ................................ 91 Tabel 3.60 PSPEC 5.3.1 Tambah Data Pemilik ............................................ 92 Tabel 3.61 PSPEC 5.3.2 Hapus Data Pemilik............................................... 92 xv
Tabel 3.62 PSPEC 5.3.3 Ubah Data Pemilik ................................................ 93 Tabel 3.63 PSPEC 5.3.4 Lihat Data Pemilik ................................................. 94 Tabel 3.64 PSPEC 5.4.1 Ubah Status Progress ........................................... 94 Tabel 3.65 PSPEC 5.4.2 Perhitungan Persentase Progress Bangunan ....... 95 Tabel 3.66 PSPEC 5.4.3 Memuat Progress Bangunan ................................ 95 Tabel 3.67 PSPEC 6.1.1 Tambah Data Buruh .............................................. 96 Tabel 3.68 PSPEC 6.1.2 Hapus Data Buruh ................................................ 96 Tabel 3.69 PSPEC 6.1.3 Ubah Data Buruh .................................................. 97 Tabel 3.70 PSPEC 6.1.4 Lihat Data Buruh ................................................... 98 Tabel 3.71 PSPEC 6.2.1 Aktifkan Buruh ....................................................... 98 Tabel 3.72 PSPEC 6.2.2 Non Aktifkan Buruh ............................................... 99 Tabel 3.73 PSPEC 6.2.3 Lihat Status Buruh ................................................ 99 Tabel 3.74 PSPEC 7.1 Olah Data Material Keluar ...................................... 100 Tabel 3.75 PSPEC 7.2 Olah Data Operasional Material ............................. 100 Tabel 3.76 PSPEC 8.1 Olah Data Keuangan Operasional Harian .............. 101 Tabel 3.77 PSPEC 8.2 Cash Flow Operasional Harian .............................. 102 Tabel 5.1 Tabel Black Box Testing Login .................................................... 118 Tabel 5.2 Tabel Black Box Testing Dahboard Utama ................................. 119 Tabel 5.3 Tabel Black Box Testing Simulasi Bangunan .............................. 120 Tabel 5.4 Tabel Black Box Testing Informasi Kekurangan Material ............ 121 Tabel 5.5 Tabel Black Box Testing Input & Update Data Bangunan ........... 121 Tabel 5.6 Tabel Black Box Testing Input & Update Data Material .............. 122 Tabel 5.7 Tabel Black Box Testing Pengadaan Material ............................ 123 Tabel 5.8 Tabel Black Box Testing Pengadaan Buruh Bangunan & Alat Berat 124 Tabel 5.9 Tabel Black Box Testing Laporan Operasional Harian ............... 125 Tabel 5.10 Tabel Black Box Testing Isi Task Bangunan ............................. 125
xvi
DAFTAR NOTASI/ LAMBANG
Jenis Flowchart
Notasi/Lambang
Nama Simbol
Keterangan/ Arti
Document / Processing Flow
Simbol untuk menunjukan arah aliran dokumen atau process
Flowchart
Connector
Simbol untuk keluar atau masuk prosedur atau proses pada halaman yang sama
Flowchart
Process
Simbol yang menunjukkan pengolahan yang dilakukan dengan computer
Flowchart
Manual Operation
Simbol yang menunjukan pengolahan yang tidak dilakukan oleh computer
xvii
Decision
Flowchart
Simbol untuk kondisi yang akan menghasilkan beberapa kemungkinan jawaban
Document
Flowchart
Simbol yang menyatakan input berasal dari dokumen dalam bentuk kertas atau output dicetak ke kertas
Jenis
Notasi/Lambang
Nama Simbol
Keterangan/ Arti
Multiple Document
Flowchart
Simbol yang menyatakan dokumen yang sama dicetak beberapa kali untuk kepentingan peralatannya
Magnetic Disk
Flowchart
Simbol yang menyatakan data yang disimpan pada magnetic disk
Jenis ERD
Simbol
Nama Simbol
Keterangan
Entitas/Entity
Sekumpulan dengan
property
sama
objek yang
yangmana
diidentifikasikan oleh suatu organisasi / perusahaan yang keberadaannyabersifat independen. xviii
ERD
Relasi
Simbol
untuk
sejumlah hubungan antara satu atau banyak tipe entity yang terlibat
Jenis
Simbol
Nama Simbol
Keterangan
Terminator
DFD
Simbol entitas
sistem
untuk yang
berhubungan langsung dengan sistem DFD
Komponen Proses
Simbol
untuk
menggambarkan transformasi
input
menjadi outpu Komponen Data
DFD Store
Simbol membuat
untuk model
sekumpulan paket data dan dengan
diberi kata
bersifat jamak
xix
nama benda
DFD
Komponen Alur Data
Simbol
yang
menunjukkan
dan
menerangkan perpindahan dari satu bagian lainnya. berupa
ke
bagian
Alur kata,
data pesan,
formulir/informasi
xx
