ANALISIS DAN PERANCANGAN SISTEM APLIKASI BASIS DATA LAPORAN PERFORMA KAPAL PADA DIVISI PERKAPALAN PT. PERTAMINA
SKRIPSI
Oleh Muhamad Syahril Sahib
0900801011
Deni Mulyana
0900803452
Ari Wibowo
0900804101
Kelas / Kelompok : 08PBT / 10
Universitas Bina Nusantara Jakarta 2009
ANALISIS DAN PERANCANGAN SISTEM APLIKASI BASIS DATA LAPORAN PERFORMA KAPAL PADA DIVISI PERKAPALAN PT. PERTAMINA
SKRIPSI
diajukan sebagai salah satu syarat untuk gelar kesarjanaan pada Jurusan Teknik Informatika Fakultas Ilmu Komputer Jenjang Pendidikan Strata-1
Oleh : Muhamad Syahril Sahib
0900801011
Deni Mulyana
0900803452
Ari Wibowo
0900804101
Kelas / Kelompok : 08PBT / 10
Universitas Bina Nusantara Jakarta 2009
KATA PENGANTAR
Puji dan syukur tim penulis panjatkan kepada Allah SWT atas segala berkat dan rahmatnya, sehingga penulisan skripsi “Analisis dan Perancangan Sistem Aplikasi Basis Data Laporan Performa Kapal Pada Divisi Perkapalan PT. Pertamina ” ini dapat selesai dengan baik dan tepat pada waktunya. Skripsi ini disusun sebagai salah satu syarat untuk menyelesaikan perkuliahan jenjang pendidikan Strata-1, jurusan Ilmu Komputer pada bidang studi Teknik Informatika di Universitas Bina Nusantara, Jakarta. Dalam penulisan skripsi ini, tim penulis banyak mendapatkan bantuan dari berbagai pihak. Oleh karena itu, pada kesempatan ini penulis ingin mengucapkan rasa terima kasih yang sebesar-besarnya atas bantuan, bimbingan serta dorongan baik secara material maupun moral, kepada: 1. Bapak Prof. Dr. Gerardus Polla, M.App. Sc selaku Rektor Universitas Bina Nusantara yang telah memberikan wadah dan kesempatan kepada tim penulis untuk mendapatkan pendidikan yang lebih tinggi dan lebih baik. 2. Bapak Ir. Sablin Yusuf, M.sc., MComSc., selaku Dekan Fakultas Ilmu Komputer Universitas Bina Nusantara. 3. Bapak Fredy Purnomo, S.Kom., M.Kom., selaku Kepala Jurusan Teknik Informatika Universitas Bina Nusantara. 4. Ibu Henny Surya Ningsih, S.Kom., MsoftSysEng, selaku Sekretaris Jurusan Universitas Bina Nusantara. 5. Bapak Yusrizal Oenzil, Drs, M.Sc selaku dosen pembimbing skripsi kelas 08 PBT yang telah banyak meluangkan waktu untuk memberikan bimbingan, vi
dukungan, serta arahan yang berharga selama penyusunan skripsi ini dari awal sampai akhir. 6. Para dosen yang tidak bisa tim penulis sebutkan satu persatu di sini, atas jasajasanya yang telah memberikan ilmu serta bimbingan dan dorongan kepada penulis selama menuntut ilmu di Universitas Bina Nusantara. 7. Pimpinan beserta seluruh staff divisi perkapalan PT. Pertamina yang telah banyak membantu dalam pengumpulan data dan meluangkan waktu untuk berdiskusi dalam perancangan sistem basis data. 8. Kedua orang tua dan seluruh saudara tim penulis yang telah membantu dalam doa serta dukungan secara materiil maupun moral selama masa perkuliahan termasuk proses penyusunan dan penyelesaian skripsi ini. 9. Dan semua teman-teman yang telah memberikan dukungan, bantuan, serta saransaran kepada tim penulis guna menyelesaikan skripsi ini. Tim penulis menyadari akan keterbatasan kemampuan dan pengetahuan yang dimiliki dan mengharapkan kritik dan saran yang membangun demi perbaikan dan penyempurnaan skripsi ini. Akhir kata, tim penulis berharap agar skripsi ini dapat bermanfaat bagi PT. Pertamina khususnya divisi perkapalan, para pembaca, serta semua pihak yang membutuhkan.
Jakarta, 3 Juli 2009
Tim Penulis vii
DAFTAR ISI Halaman Halaman Judul Luar …………………………………………………………………..i Halaman Judul Dalam ………………………………………………………………...ii Halaman Persetujuan Hard Cover ..……………………………..…..……………….iii Halaman Pernyataan Dewan Penguji ………………………………………………...iv Abstrak ………………………………………………………………………………….v Kata Pengantar ………………………………………………………………………...vi Daftar Isi ……………………………………………………………………………...viii Daftar Tabel …………………………………………………………………………..xvi Daftar Gambar………………………………………………………………………..xix Daftar Lampiran ……………………………………………………………………xxvi BAB 1 PENDAHULUAN ……………………………………………….......………….1 1.1 Latar Belakang …………………………………………………………….…………1 1.2 Ruang Lingkup ………………………………………………………...…………….3 1.3 Tujuan Dan Manfaat …………………….……………………………….…………..3 1.3.1 Tujuan Penelitian …………………………………………………………..3 1.3.2
Manfaat Penelitian ………………….………………………………..…..4
1.4 Metodologi Penelitian ..………………………………………….…………………..4 1.5 Sistematika Penulisan ……………………………………………..…………………6 BAB 2 LANDASAN TEORI ………………………………………………...…………8 2.1 Teori – teori dasar / umum …………………………….…….………………………8 2.1.1 Pengertian Sistem Basis Data ……………………..……………………….8 2.1.1.1 Pengertian Basisdata Terdistribusi ……………………………..11 viii
2.1.1.1.1 Definisi Basisdata Terdistribusi ……...………………11 2.1.1.1.2 Prinsip-prinsip dasar …………………...……………..14 2.1.1.1.3 Komponen-komponen dari DBMS ….………………..21 2.1.1.1.4 Alasan penggunaan dari DBMS ………...……………24 2.1.2 Database Application Life Cycle ……………………………………..…..27 2.1.2.1 Database Planning ………………………………………..…….30 2.1.2.2 System Definition ………...…………………………………….32 2.1.2.3 Requirement Collection and Analysis …...……………….…….33 2.1.2.4 Database Design …………………………………………….….37 2.1.2.5 DBMS Selection ( Optional ) …………………..………………40 2.1.2.6 Application Design ……………………………..………………42 2.1.2.7 Prototyping ……………………………………..………………43 2.1.2.8 Implementation ………………………………..……………….44 2.1.2.9 Data Conversion and Loading ………………..…………..…….45 2.1.2.10 Testing ………………………………………………….……..45 2.1.2.11 Operational Maintenance ……………………………….…….46 2.1.3
Entity Relationship Modeling (ER Modeling) …………………………47 2.1.3.1 Entity Type ……………………………………………………..49 2.1.3.2 Relationship type …………………………….………….……..51 2.1.3.3 Atribut ……………………………………………..……………55 2.1.3.4 Batasan Struktural (Structural Constraints) …….……………...57
2.1.4 Normalisasi …………………………………………………………….…63 2.1.4.1 Langkah-langkah normalisasi …………………………………..63 2.1.4.2 Denormalisasi …………………………………………………..65 ix
2.1.5 Metodologi Perancangan Basisdata ………………………………………65 2.1.5.1 Perancangan Basisdata Konseptual …………………………….65 2.1.5.2 Perancangan Basisdata Logikal ………………………………...66 2.1.5.3 Perancangan Basisdata Fisikal ……………………...………….70 2.1.6 State Transtition Diagram ( STD ) ……………………………………….72 2.1.6.1 Pembuatan State Transtition Diagram ( STD ) ……………..…….72 2.1.7 Data Flow Diagram ( DFD ) / Diagram Aliran Data ……….…………….74 2.2 Teori – teori khusus ………………………………………………………………...78 2.2.1 Pengertian PHP …………………………………………..……………….78 2.2.2 Backup and Recovery ………………………………………………….…80 2.2.3
Apache Server …………………………………………………………..80
2.2.4 MySQL …………………………………………………………………..81 BAB 3 ANALISIS DAN PERANCANGAN SISTEM ………………………………84 3.1 Gambaran Umum Perusahaan ………………….…………………………………..84 3.1.1 Riwayat Perusahaan ………………………………………………………84 3.1.2 Visi Dan Misi Perusahaan …………..……………………………………88 3.1.2.1 Visi Perusahaan …………..…………………………………….88 3.1.2.2 Misi Perusahaan ……………...…………………………………88 3.1.3 Bidang Usaha …………………………………..…………………………89 3.1.3.1 Agency …………………………….……………………………89 3.1.3.2 Mooring Master ……………………..………………………….90 3.1.3.3 Ship Repairs ………………………..…………………………...90 3.1.3.4 Pelayanan Pendukung …………………………………………..91 3.1.3.5 Charterring ……..……………………...………………………..92 x
3.1.3.6 Pelayanan Bawah Laut ………………...……………………….92 3.1.3.7 Pelatihan Maritim Dan Pusat Pembelajaran ……..……………..93 3.1.3.8 Operasi Kapal Dan Manejemen ………………………………...93 3.1.3.9 konstruksi kapal ……………………………………...…………94 3.2 Struktur Organisasi …………………………………………………………………95 3.2.1 Pembagian Divisi Tugas dan Tanggung Jawab …………………………..97 3.2.1.1 Tugas / Kegiatan Utama Deputi Direktur Perkapalan ……...…..97 3.2.1.2 Tugas / Kegiatan Utama General Manager Komersial & Charter …………………….……………………..97 3.2.1.3 Tugas / Kegiatan Utama Koordinator Pembangunan Kapal …………………………………………………….……...98 3.2.1.4 Tugas / Kegiatan Utama General Manager Bina Armada Milik ……………………………….………….....99 3.2.1.5 Tugas / Kegiatan Utama Manager K3LL dan SMR ……..……100 3.2.1.6 Tugas / Kegiatan Utama General Manager Operasi Perkapalan …………………………………….……...100 3.3 Prosedur Yang Sedang Berjalan …………………………………………………..101 3.3.1 Pengiriman Data Kegiatan Dari Kapal ………………………………….101 3.3.2 Pengiriman Data Koordinat Kapal Ke Darat ( Base ) …………………..102 3.3.3 Penerimaan Dan Pengolahan Data Kegiatan ………………………........102 3.4 Diagram Aliran Data ( DFD ) …………………………………………………......104 3.4.1 Diagram Contex …………………………………………………………104 3.4.2 Diagram Nol …………………………………………………………….105 3.5 Definisi Sistem ……………………………………………………………………106 xi
3.5.1 Mision Statement ………………………………………………………..106 3.5.2 Mision Objective ……………………………………………………….109 3.5.3 Systems Bounderies ……………………………………………………..111 3.5.4 Analisa User view …………………………………………………….....112 3.6 User Requirement …………………………………………………………………113 3.6.1 Data Requirement ……………………………………………………….113 3.6.2 Transaction Requirement ………………………………………………..118 3.6.3 General System Requirement …………………………………………...121 3.6.3.1 Inisialisi Ukuran Database …………………………………….121 3.6.3.2 Rata – rata Pertumbuhan Database ……………………………121 3.6.3.3 Tipe – tipe dan Jumlah Rata – rata Record yang Dicari ………122 3.6.3.4 Performance ………………………………………………..….122 3.6.3.5 Security ………………………………………………….…….120 3.6.3.6 Backup and Recovery ……………………………………...….123 3.7 Permasalahan Yang Dihadapi ……………………………………………………..123 3.8 Alternatif Pemecahan Masalah ……………………………………………………123 BAB 4 PERANCANGAN DAN IMPLEMENTASI .................................................125 4.1 Perancangan Sistem Basis Data ...............................................................................125 4.1.1 Perancangan Basis Data Konseptual ........................................................125 4.1.1.1 Mengidentifikasi Tipe Entitas ...................................................125 4.1.1.2 Mengidentifikasi Relasi Antar Entity ........................................128 4.1.1.3 Mengidentifikasi dan Mengasosiasikan Atribut Suatu Entitas atau Tipe Relasi ...............................................................131
xii
4.1.1.4 Menentukan Domain Atribut .....................................................138 4.1.1.5 Mengidentifikasi Candidate key dan Primary Key....................146 4.1.1.6 Mempertimbangkan Penggunaan Enhanced Modeling Concepts ...................................................148 4.1.1.7 Memeriksa Redudansi ...............................................................148 4.1.1.8 Validasi Lokal Konseptual Model Terhadap Transaksi User ...........................................................149 4.1.1.9 Meninjau Ulang Model Data Konseptual Lokal Dengan Pemakai ..........................................................................152 4.1.2 Perancangan Basis Data Logikal ..............................................................152 4.1.2.1 Menghilangkan Bagian Yang Tidak Sesuai Dengan Model Relasi .................................................................152 4.1.2.1.1 Menghilangkan binary many-to-many ( * : * ) ...........152 4.1.2.1.2 Menghilangkan tipe relasi rekursif 4.1.2.1.3 many-to-many(* : *) .................................................156 4.1.2.1.4 Menghilangkan tipe relasi kompleks ........................156 4.1.2.1.4 Menghilangkan multi valued atribut ..........................156 4.1.2.2 Menurunkan Relasi Untuk Model Data Logikal Lokal ....................................................................157 4.1.2.2.1 Entitas Kuat ................................................................157 4.1.2.2.2. Tipe relasi one-to-many …………………...………..162 4.1.2.2.3. Tipe Relasi one-to-one …………………….……….164 4.1.2.2.4. Tipe relasi many-to-many ………………...………...165
xiii
4.1.2.2.5 Atribute Multy Value .................................................167 4.1.2.3 Memvalidasi Relasi Dengan Normalisasi .................................171 4.1.2.4 Validasi Relasi Dengan Transaksi Pemakai ..............................199 4.1.2.5 Mendefinisikan Batasan – Batasan Integritas ............................202 4.1.2.6 Pemilihan DBMS ( Database Management System ) ................208 4.1.3 Perancangan Basis Data Fisikal ................................................................210 4.1.3.1 Merancang Relasi Dasar ............................................................210 4.1.3.2 Analisis Transaksi .....................................................................225 4.1.3.3 Memilih Indeks ..........................................................................236 4.1.3.4 Mengestimasi Kapasitas Disk Yang Dibutuhkan ......................237 4.1.3.5 Merancang Mekanisme Keamanan ...........................................262 4.1.3.6 Denormalisasi………………………………………………….265 4.1.3.6.1 Perbandingan Normalisasi dengan Denormalisasi ................................................................268
4.2 Perancangan Aplikasi …………………………………………………………......271 4.2.1 Struktur Menu ………………………………………………….……......271 4.2.2 State Transition Diagram ( STD ) ............................................................272 4.2.3 Perancangan Input dan Output .................................................................278 4.2.3.1 Perancangan Input ………………………………………….....278 4.2.3.2 Perancangan Output ……………………………………….......283 4.2.4 Implementasi …………………………………………………………....284 4.2.4.1 Spesifikasi perangkat Keras ………………………………......284 4.2.4.2 Spesifikasi perangkat Lunak ......................................................285 xiv
4.2.4.3 Jadwal Implementasi ………………………………………….285 4.2.5 Cara Pengoperasian Aplikasi ……………………………………………286 4.2.5.1 Cara Pengoperasian Aplikasi Untuk Admin …………………..286 4.2.5.2 Cara Pengoperasian Aplikasi Untuk Staf ……………………..315 Bab 5 KESIMPULAN DAN SARAN ……………………………………………….317 5.1 Kesimpulan ……..............……………………………..……..……………………317 5.2 Saran ..……………………………………………………...……………………...318 Daftar Pustaka ……………………………………………………………………….319 Daftar Riwayat Hidup ……………………………………………………………….321 Lampiran ……………………………………………………………………………..L 1 Fotocopy Surat Survey
xv
DAFTAR TABEL
HALAMAN
Tabel 2.1 Tahapan DBLC .............................................…….…………..…....................27 Tabel 3.1 Analisa User View ……………………..……………….…………..............112 Tabel 4.1 Tabel Tipe Entity………………………………….………………………...123 Tabel 4.2 Tabel Tipe Relasi ……………………….…………………………………..126 Tabel 4.3 Tipe Atribut dan Domain Atribut ……………………………..……………129 Tabel 4.4 Domain Atribut ……………………..………………………………….…...136 Tabel 4.5 Mengidentifikasi Candidate key dan Primary Key …..……………….……144 Tabel 4.6 Hasil relasi ……………………………………………………………..…...166 Tabel 4.7 Perbandingan antara MySQL dengan Oracle9iDB .......................................208 Tabel 4.8 Tabel Relasi Dasar staf_darat.........................................................................211 Tabel 4.9 Tabel Relasi Dasar Jabatan.............................................................................211 Tabel 4.10 Tabel Relasi Dasar User...............................................................................212 Tabel 4.11 Tabel Relasi Dasar contact………………………………………………...212 Tabel 4.12 Tabel Relasi Dasar Staf_laut…....................................................................213 Tabel 4.13 Tabel Relasi Dasar jabatanlaut………............................…………....….…213 Tabel 4.14 Tabel Relasi Dasar userlaut….................................................................….214 Tabel 4.15 Tabel Relasi Dasar contactlaut……………………….....…....…………...214 Tabel 4.16 Tabel Relasi Dasar kapal..………………………….................…...……....215 Tabel 4.17 Tabel Relasi Dasar pelabuhan.........................................................….…...215 Tabel 4.18 Tabel Relasi Dasar barang_muatan.............................................................216 Tabel 4.19 Tabel Relasi Dasar aktifitas_kapal..............................................................217 xvi
Tabel 4.20 Tabel Relasi Dasar aktifitas_kargo.…..........................................................218 Tabel 4.21 Tabel Relasi Dasar aktifitas_pelayaran…............................................…....219 Tabel 4.22 Tabel Relasi Dasar bunker…….…..........................................................…220 Tabel 4.23 Tabel Relasi Dasar ship_movement………….............................................220 Tabel 4.24 Tabel relasi dasar idle…………......….........................................................222 Tabel 4.25 Tabel relasi dasar maneuvering....................................................................222 Tabel 4.26 Tabel relasi dasar koordinat.........................................................................223 Tabel 4.27 Tabel relasi dasar barang_muatandetail.......................................................223 Tabel 4.28 Tabel relasi dasar staf_daratdetail................................................................224 Tabel 4.29 Tabel relasi dasar pelabuhandetail...............................................................225 Tabel 4.30 Tabel Analisis Transaksi 1...........................................................................228 Tabel 4.31 Tabel Analisis Transaksi 2...........................................................................229 Tabel 4.32 Tabel Analisis Transaksi 3...........................................................................230 Tabel 4.33 Tabel Analisis Transaksi 4...........................................................................231 Tabel 4.34 Tabel Analisis Transaksi 5...........................................................................232 Tabel 4.35 Tabel Analisis Transaksi 6...........................................................................234 Tabel 4.36 Tabel Analisis Transaksi 7...........................................................................235 Tabel 4.37 Tabel pemilihan indeks................................................................................236 Tabel 4.38 Tabel Estimasi staf_darat.............................................................................237 Tabel 4.39 Tabel Estimasi jabatan.................................................................................238 Tabel 4.40 Tabel Estimasi user .....................................................................................239 Tabel 4.41 Tabel Estimasi contact.................................................................................240 Tabel 4.42 Tabel Estimasi Staf_laut..............................................................................242 Tabel 4.43 Tabel Estimasi jabatanLaut………………..…....…..............….....……….243 xvii
Tabel 4.44 Tabel Estimasi userLaut...............................................................................244 Tabel 4.45 Tabel Estimasi contactLaut..........................................................................245 Tabel 4.46 Tabel Estimasi Kapal................................................................................... 246 Tabel 4.47 Tabel Estimasi Pelabuhan............................................................................247 Tabel 4.48 Tabel Estimasi Barang_muatan...................................................................249 Tabel 4.49 Tabel Estimasi Aktifitas_kapal....................................................................250 Tabel 4.50 Tabel Estimasi Aktifitas_kargo....................................................................251 Tabel 4.51 Tabel Estimasi aktifitas_pelayaran...............................................................252 Tabel 4.52 Tabel Estimasi Bunker.................................................................................253 Tabel 4.53 Tabel Estimasi Ship_movement...................................................................255 Tabel 4.54 Tabel Estimasi Idle ......................................................................................256 Tabel 4.55 Tabel Estimasi Maneuvering........................................................................257 Tabel 4.56 Tabel Estimasi Koordinat.............................................................................258 Tabel 4.57 Tabel Estimasi Barang_muatanDetail..........................................................259 Tabel 4.58 Tabel Estimasi Staf_daratDetail………………………….............………..260 Tabel 4.59 Tabel Estimasi pelabuhandetail…………………………...........………….261 Tabel 4.60 Tabel Mekanisme Keamanan………………….……....….............……….263 Tabel 4.61 Jadwal Implementasi....................................................................................285
xviii
DAFTAR GAMBAR HALAMAN Gambar 2.1 Siklus Basis Data…..…................................................................................30 Gambar 2.2 Notasi Entity-Relationship Modelling …………….…..………............…..49 Gambar 2.2 Representasi diagram dari tipe entity material dan gudang …………….…50 Gambar 2.3 Representasi diagram tipe entitas kuat dan tipe entitas lemah ...………….51 Gambar 2.4 Representasi diagram dari tipe relationship ................................................52 Gambar 2.5 Representasi diagram tingkat tiga dari suatu tipe relationship ..........……..53 Gambar 2.6 Representasi diagram recusrsive relationship dan nama peran ..................54 Gambar 2.7 Representasi diagram entity dengan dua relationship yang berbeda berserta nama peran ……...……………………………..…………..…….54 Gambar 2.8 Representasi diagram entitas Pegawai dan Cabang beserta atribut dan primary keynya ............................................................................................57 Gambar 2.9 Relasi one-to-one antara cabang dan staff ...................................................58 Gambar 2.10 Multiplicity dari one-to-one (1:1) relationship ........................................ 58 Gambar 2.11 Relasi one-to-many antara staff dan konsumen .........................................59 Gambar 2.12 Multiplicity dari one-to-many (1:*) relationship …….…………….…….59 Gambar 2.13 Relasi many-to-many antara majalah dan barang ................................…..60 Gambar 2.14 Multiplicity dari many-to-many (*:*) relationship …….......……....….…60 Gambar 2.15 Cardinality dan Participation antara Branch dan Staff ............................ 62 Gambar 2.16 notasi State …………..…………………...............………....……………72 Gambar 2.17 notasi perubahan state ..................……………....................…...…….….73 Gambar 2.18 Contoh State Transtition Diagram ................................................….……74 Gambar 2.19 simbol proses ….........................................................................................75 xix
Gambar 2.20 simbol data flow ........................................................................................75 Gambar 2.21 simbol data store …………………………………..………………..…....76 Gambar 2.22 simbol external entity…………………………………………………….77 Gambar 3.1 Struktur organisasi divisi perkapalan PT. Pertamina …………..………....95 Gambar 3.2 Struktur organisasi shipping support & analysis divisi perkapalan PT. Pertamina…….…............................................................................…96 Gambar 3.3 Diagram contex system pengiriman data di Divisi Perkapalan pada PT. Pertamina …………...........................................................................104 Gambar 3.4 Diagram nol system pengiriman data di Divisi Perkapalan pada PT. Pertamina …………......................................................................….105 Gambar 3.5 sistem boundaries ......................................................................................111 Gambar 4.1 Rancangan Entity Relationship .................................................................130 Gambar 4.2 Rancangan Diagram Entity Relationship Dengan Penambahan Primary Key.........................................................................147 Gambar 4.3 Diagram model konseptual yang mendukung transaksi user dengan menggunakkan pathway ..............................................................149 Gambar 4.4 hubungan antara barang_muatan dengan aktifitas_kargo ........................153 Gambar 4.5 Menghilangkan Hubungan Many-To-Many antara barang_muatan dan aktifitas_kargo Menggunakan Entity barang_muatanDetail…..........153 Gambar 4.6 Hubungan Antara staf_darat Dengan aktifitas_pelayaran..........................154 Gambar 4.7 Menghilangkan Hubungan Many-To-Many antara staf_darat dan aktifitas_pelayaran Menggunakan Entity staf_daratDetail.................154 Gambar 4.8 Hubungan Antara kapal Dengan pelabuhan...............................................155 Gambar 4.9 Menghilangkan Hubungan Many-To-Many antara kapal xx
dan pelabuhan Menggunakan Entity pelabuhandetail...............................155 Gambar 4.10 Menghilangkan multy valued pada staf_darat..........................................156 Gambar 4.11 Menghilangkan multy valued pada staf_laut............................................157 Gambar 4.12 Relasi binary one-to-many dari kapal memiliki staf_laut........................162 Gambar 4.13 Relasi binary one-to-many dari kapal melakukan aktifitas_kapal............................................................................................162 Gambar 4.14 Relasi binary one-to-many dari kapal mempunyai bunker.......................162 Gambar 4.15 Relasi binary one-to-many dari kapal mempunyai barang_muatan..........................................................................................163 Gambar 4.16 Relasi binary one-to-many dari kapal memiliki maneuvering.................163 Gambar 4.17 Relasi binary one-to-many dari kapal memiliki idle................................163 Gambar 4.18 Relasi binary one-to-many dari kapal memberi koordinat..….........…....163 Gambar 4.19 Relasi binary one-to-many dari kapal melakukan ship_movement.........164 Gambar 4.20 Relasi binary one-to-many dari staf_laut melakukan aktifitas_pelayaran....................................................................................164 Gambar 4.21 Relasi many-to-many dari staf_darat memiliki staf_daratdetail.............. 165 Gambar 4.22 Relasi many-to-many dari aktifitas_pelayaran memiliki staf_daratdetail..........................................................................................165 Gambar 4.23 Relasi many-to-many dari barang_muatan memiliki barang_muatandetail…………………………….....................................165 Gambar 4.24 Relasi many-to-many dari aktifitas_kargo mencakup barang_muatandetail………………………….........................................166 Gambar 4.25 Relasi many-to-many dari kapal melakukan pelabuhandetail.........................................................................................166 xxi
Gambar 4.26 Relasi many-to-many dari pelabuhan melakukan pelabuhandetail .........................................................................................166 Gambar 4.27 Relasi multy valued dari staf_darat memiliki contact...............................167 Gambar 4.28 Relasi multy valued dari staf_laut memiliki contactlaut...........................167 Gambar 4.29 Functional dependency table staf_darat...................................................172 Gambar 4.30 Functional dependency table contact.......................................................174 Gambar 4.31 Functional dependency table staf_laut.....................................................175 Gambar 4.32 Functional dependency table contactlaut.................................................177 Gambar 4.33 Functional dependency table kapal…………………………...………...179 Gambar 4.34 Functional dependency table pelabuhan…....……….........................….180 Gambar 4.35 Functional dependency table barang_muatan…….................………….181 Gambar 4.36 Functional dependency table aktifitas_kapal...........................................183 Gambar 4.37 Functional dependency table aktifitas_kargo...........................................184 Gambar 4.38 Functional dependency table aktifitas_pelayaran.....................................185 Gambar 4.39 Functional dependency table bunker ..…….……………...................….187 Gambar 4.40 Functional dependency table ship_movement...……….........………….188 Gambar 4.41 Functional dependency table idle…....……..……….....................……..190 Gambar 4.42 Functional dependency table maneuvering.…………….................……191 Gambar 4.43 Functional dependency table koordinat...……………...................…….192 Gambar 4.44 Functional dependency table staf_daratdetail...………...............………193 Gambar 4.45 Functional dependency table branag_muatandetail...…….........……….195 Gambar 4.46 Functional dependency table pelabuhandetail…....……...............……..196 Gambar 4.47 Model Diagram Relasional Global …....…….............................……….198 Gambar 4.48 Denormalisasi Antara Staf_darat Dengan Jabatan……………………...266 xxii
Gambar 4.49 Denormalisasi Antara Staf_darat Dengan User…………………………266 Gambar 4.50 Denormalisasi Antara Staf_laut Dengan Jabatanlaut…………………...267 Gambar 4.51 Denormalisasi Antara Staf_laut Dengan Userlaut………………………267 Gambar 4.52 Struktur Menu……………………….....................……......….………...271 Gambar 4.53 STD Menu Utama…………………………...............…….....………….272 Gambar 4.54 STD Profile...............................................................................................273 Gambar 4.55 STD Report...............................................................................................274 Gambar 4.56 STD Schedules………………………………………………………….275 Gambar 4.57 STD Tasks................................................................................................276 Gambar 4.58 STD Master……………………………………………………………...277 Gambar 4.59 Rancangan Layar Menu Login………………………………………….278 Gambar 4.60 Rancangan Layar Menu Utama…………………………………………278 Gambar 4.61 Rancangan Layar Menu Profile…………………………………………279 Gambar 4.62 Rancangan Layar Menu Edit Profile……………………………………279 Gambar 4.63 Rancangan Layar Menu Master…………………………………………280 Gambar 4.64 Rancangan Layar Menu Tasks Input SPR………………………………281 Gambar 4.65 Rancangan Layar Menu Schedules……………………………………...281 Gambar 4.66 Rancangan Layar Menu Report…………………………………………282 Gambar 4.67 Rancangan Layar Menu Logout……………………………………...…282 Gambar 4.68 Perancangan Output SPR………………………………………………..283 Gambar 4.69 Layar Login untuk admin……………………………………………….286 Gambar 4.70 Layar Login Sukses……………………………………………………..287 Gambar 4.71 Layar Menu Utama……………………………………………………...288 Gambar 4.72 Layar Profile…………………………………………………………….289 xxiii
Gambar 4.73 Layar Edit Profile……………………………………………………….290 Gambar 4.74 Layar Report…………………………………………………………….290 Gambar 4.75 Layar Data Report ……………………………………………………...291 Gambar 4.76 Layar SPR ………………………………………………………………292 Gambar 4.77 Layar Schedules ………………………………………………………...293 Gambar 4.78 Layar Tasks ……………………………………………………………..294 Gambar 4.79 Layar Input SPR ………………………………………………………..295 Gambar 4.80 Layar Evaluation ………………………………………………………..297 Gambar 4.81 Layar Input Evaluation Kecepatan rata - rata…………………………...298 Gambar 4.82 Layar hasil Evaluation Kecepatan rata - rata …………………………...299 Gambar 4.83 Layar Hasil UKT Kecepatan rata - rata ………………………………...300 Gambar 4.84 Layar Input evaluation Kecepatan rata - rata……………………………301 Gambar 4.85 Layar Hasil Evaluation Bunker Consumption ………………….………302 Gambar 4.86 Layar Hasil UKT Bunker Consumption...........................................……303 Gambar 4.87 Layar Input Evaluation Transport Loss…………………………………303 Gambar 4.88 Layar Hasil Evaluation Transport Loss....................................................304 Gambar 4.89 Layar Hasil UKT Transport Loss……………………………………….305 Gambar 4.90 Layat Input Evaluation Pumping Rate…………………………………..305 Gambar 4.91 Layar Hasil Evaluation Pumping Rate………………………………….306 Gambar 4.92 Layar Hasil UKT Pumping Rate..............................................................307 Gambar 4.93 Layar Input Schedules........ .....................................................................308 Gambar 4.94 Layar Master User....................................................................................309 Gambar 4.95 Layar Master Vessel.................................................................................310 Gambar 4.96 Layar Master Port.....................................................................................311 xxiv
Gambar 4.97 Layar Master Officer................................................................................312 Gambar 4.98 Layar Master Activity...............................................................................313 Gambar 4.99 Layar Proses Logout Berhasil...................................................................315 Gambar 4.100 Layar Login untuk staf............................................................................316 Gambar 4.101 Layar Menu Utama untuk Staff..............................................................316
xxv
DAFTAR PUSTAKA
Atzeni, Paolo. , Ceri, Stefano. , Torlone, Riccardo. (2003). Database system: concepts, languages, and Architectures. McGraw-Hill, New York. Connolly, Thomas, dan Begg, Carolyn. (2002). Databse Systems A Partical Approach Design,
Implementation, and Management. Edisi Ketiga. Addison Wesley,
USA. Casteagnetto,Jean. , Rawat,Harish. , Schumann,Sasha. , Scollo,Chris. , Veliath,Depak. (2000). Proffesional PHP Programming. Wrox Press,United Kingdom Chaudhury, Abhijit and Kuilboer, Jean-Piere. (2002). E-Business and E-Commerce Infrastructure : Technologies Supporting The E-Business Initiative, International Edition. The McGraw-Hill, Amerika. Date.C.J. (2000). An Introduction to Databse System, Seventh Edition. Addison Wesley Longman, Inc, USA. Hoffer, Jeffery A. , Prescott, Mary B. , McFadden, Fred R. (2005). Modern Database Management. 7th edition. Prentice Hall, Amerika Jeffrey,A.Et al. (1996).Modern System analysis and design. The Benjamin/Cummings Company, California. Kadir, Abdul. (2001). Sistem Informasi Manajemen, Jilid 1. Edisi Ketujuh. Alih bahasa:
319
320 Hendra Teguh, SE.AK.PT.Prehallindo,Jakarta. Michael, V. Mannino. (2001). Database Application Development and Design, International Edition. McGraw-Hill Book Co, Singapore. Subekti, M. (1997). System Manajemen BasisData.Universitas Bina Nusantara, Jakarta. Turban, Efraim, R, Kelly Rainer, Jr., Richard E. Potter. (2005). Introduction To Information
Technology, 3th Edition. John Willey & Sins Inc., New Jersey.
Whitten, Jefrey L. And Loonet D. Bentley and Kevin C. Dittman. (2004). Systems Analysis and Design Methods, Sixth Edition. McGraw-Hill, New York.
Daftar Lampiran
Lampiran 1 – Hasil Wawancara uji coba sistem..............................................................L1 Lampiran 2 – MySql Code ………………………………………….…..…...…............L3
xxvi
Lampiran 1 – Hasil Wawancara Uji Coba Sistem Berikut ini adalah hasil dari wawancara yang dilakukan terhadap bapak Hadi Purnomo selaku Asisten Manajer dari divisi support system analysis dari divisi perkapalan PT. Pertamina mengenai sistem yang akan diimplementasikan pada perusahaan.
1. Apakah aplikasi ini dapat membantu pelaporan dari performa kapal PT. Pertamina? Sudah cukup membantu, karena secara garis besar sudah merepresentasikan dari kebutuhan perusahaan.
2. Apakah dengan sistem ini dapat membantu kinerja para karyawan disini dalam melakukan proses pengevaluasian dari laporan performa kapal Perusahaan? Iya, karena dengan aplikasi ini pengevalusian yang biasanya memakan waktu dalam pengerjaannya, dengan adanya sistem ini sangat mengurangi waktu pekerjaan karena semua perhitungannya sudah terkomputerisasi dan dapat terintegrasi dengan internet.
3. Apakah dengan sistem ini khususnya dibagian hak akses memperkuat keamanan sistem anda? Iya, karena disini diberlakukan peng-inputan username dan password untuk login.
4. Bagaimana tampilan dari aplikasi ini? Tampilan sudah bagus, sudah tepat sasaran.
5. Apakah aplikasi ini mudah dipahami atau dipelajari? Iya, karena untuk penginputan laporannya menyamai dengan draft yang kami punya, dan penjelasannya cukup jelas.
6. Apakah perlu diadakan pelatihan untuk mereka yang menjalankan aplikasi ini? Sangat perlu, dikarenakan untuk menghindari kesalahan pengoperasian hanya karena kesalahpahaman dalam menjalankan aplikasi.
7. Perbedaan apa yang didapatkan dengan adanya aplikasi ini? Dengan adanya aplikasi ini sangat membantu pihak manajemen dalam pengambilan keputusan, dan mengurangi adanya human error, karena sudah terkomputerisasi. Dan yang sangat siginifikan adalah keefisiensian dalam pengerjaannya.
Lampiran 2 – MySql Code
-- phpMyAdmin SQL Dump -- version 2.9.2 -- http://www.phpmyadmin.net --- Host: localhost -- Generation Time: Jun 15, 2009 at 12:46 AM -- Server version: 5.0.27 -- PHP Version: 5.2.1 --- Database: `perkapalan` --
-- --------------------------------------------------------
--- Table structure for table `at_sea_evaluation` --
DROP TABLE IF EXISTS `at_sea_evaluation`; CREATE TABLE IF NOT EXISTS `at_sea_evaluation` ( `id` int(10) unsigned NOT NULL auto_increment, `id_spr` int(10) NOT NULL,
`tank_cleaning` varchar(10) NOT NULL, `heating_in_sea` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--- Dumping data for table `at_sea_evaluation` --
INSERT INTO `at_sea_evaluation` (`id`, `id_spr`, `tank_cleaning`, `heating_in_sea`) VALUES (1, 1, '12', '11');
-- --------------------------------------------------------
--- Table structure for table `bunker_consumption_condition` --
DROP TABLE IF EXISTS `bunker_consumption_condition`; CREATE TABLE IF NOT EXISTS `bunker_consumption_condition` ( `id` int(10) unsigned NOT NULL auto_increment, `id_spr` int(10) NOT NULL, `bcc_mfo` varchar(10) NOT NULL,
`bcc_mdo` varchar(10) NOT NULL, `bcc_hsd` varchar(10) NOT NULL, `ket_mfo` varchar(40) NOT NULL, `ket_mdo` varchar(40) NOT NULL, `ket_hsd` varchar(40) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--- Dumping data for table `bunker_consumption_condition` --
INSERT INTO `bunker_consumption_condition` (`id`, `id_spr`, `bcc_mfo`, `bcc_mdo`, `bcc_hsd`, `ket_mfo`, `ket_mdo`, `ket_hsd`) VALUES (1, 1, '0', '0', '15.20', 'Consumtion Ok', 'Consumtion Ok', 'Over Consumtion');
-- --------------------------------------------------------
--- Table structure for table `bunker_consumption_in_fix_note` --
DROP TABLE IF EXISTS `bunker_consumption_in_fix_note`; CREATE TABLE IF NOT EXISTS `bunker_consumption_in_fix_note` (
`id` int(10) unsigned NOT NULL auto_increment, `id_spr` int(11) NOT NULL, `cs_mfo` varchar(10) NOT NULL, `cs_mdo` varchar(10) NOT NULL, `cs_hsd` varchar(10) NOT NULL, `ch_mfo` varchar(10) NOT NULL, `ch_mdo` varchar(10) NOT NULL, `ch_hsd` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--- Dumping data for table `bunker_consumption_in_fix_note` --
INSERT INTO `bunker_consumption_in_fix_note` (`id`, `id_spr`, `cs_mfo`, `cs_mdo`, `cs_hsd`, `ch_mfo`, `ch_mdo`, `ch_hsd`) VALUES (1, 1, '20', '8', '4', '2', '1.5', '4');
-- --------------------------------------------------------
--- Table structure for table `bunker_consumption_per_fn` --
DROP TABLE IF EXISTS `bunker_consumption_per_fn`; CREATE TABLE IF NOT EXISTS `bunker_consumption_per_fn` ( `id` int(10) unsigned NOT NULL auto_increment, `id_spr` int(10) NOT NULL, `csa_mfo` varchar(10) NOT NULL, `csa_mdo` varchar(10) NOT NULL, `csa_hsd` varchar(10) NOT NULL, `ca_mfo` varchar(10) NOT NULL, `ca_mdo` varchar(10) NOT NULL, `ca_hsd` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--- Dumping data for table `bunker_consumption_per_fn` --
INSERT INTO `bunker_consumption_per_fn` (`id`, `id_spr`, `csa_mfo`, `csa_mdo`, `csa_hsd`, `ca_mfo`, `ca_mdo`, `ca_hsd`) VALUES (1, 1, '26', '10', '7', '14.560', '3.450', '22.220');
-- --------------------------------------------------------
--- Table structure for table `bunker_consumption_port_evaluation` --
DROP TABLE IF EXISTS `bunker_consumption_port_evaluation`; CREATE TABLE IF NOT EXISTS `bunker_consumption_port_evaluation` ( `id` int(10) unsigned NOT NULL auto_increment, `id_spr` int(10) NOT NULL, `cip_mfo` varchar(10) NOT NULL, `cip_mdo` varchar(10) NOT NULL, `cip_hsd` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--- Dumping data for table `bunker_consumption_port_evaluation` --
INSERT INTO `bunker_consumption_port_evaluation` (`id`, `id_spr`, `cip_mfo`, `cip_mdo`, `cip_hsd`) VALUES (1, 1, '19', '3', '1');
-- --------------------------------------------------------
--- Table structure for table `bunker_consumtion` --
DROP TABLE IF EXISTS `bunker_consumtion`; CREATE TABLE IF NOT EXISTS `bunker_consumtion` ( `id_bunker` int(10) unsigned NOT NULL auto_increment, `id_spr` int(10) NOT NULL, `port_from` varchar(25) collate latin1_general_ci NOT NULL, `port_to` varchar(25) collate latin1_general_ci NOT NULL, `date_from` date NOT NULL, `utc_from` time NOT NULL, `date_to` date NOT NULL, `utc_to` time NOT NULL, `distance` varchar(7) collate latin1_general_ci NOT NULL, `sea_time` varchar(7) collate latin1_general_ci NOT NULL, `av_speed` float NOT NULL, `atd_mfo` varchar(7) collate latin1_general_ci NOT NULL, `atd_mdo` varchar(7) collate latin1_general_ci NOT NULL, `atd_hsd` varchar(7) collate latin1_general_ci NOT NULL, `ata_mfo` varchar(7) collate latin1_general_ci NOT NULL, `ata_mdo` varchar(7) collate latin1_general_ci NOT NULL, `ata_hsd` varchar(7) collate latin1_general_ci NOT NULL, `rep_mfo` varchar(7) collate latin1_general_ci NOT NULL,
`rep_mdo` varchar(7) collate latin1_general_ci NOT NULL, `rep_hsd` varchar(7) collate latin1_general_ci NOT NULL, `atd1_mfo` varchar(7) collate latin1_general_ci NOT NULL, `atd1_mdo` varchar(7) collate latin1_general_ci NOT NULL, `atd1_hsd` varchar(7) collate latin1_general_ci NOT NULL, `speed` varchar(7) collate latin1_general_ci NOT NULL, `sailing_time_acc` varchar(7) collate latin1_general_ci NOT NULL, `sailing_time_sea` varchar(7) collate latin1_general_ci NOT NULL, `port_time` varchar(7) collate latin1_general_ci NOT NULL, `speed_condition` varchar(10) collate latin1_general_ci NOT NULL, `delay_speed` varchar(7) collate latin1_general_ci NOT NULL, `despatch_speed` varchar(7) collate latin1_general_ci NOT NULL, PRIMARY KEY (`id_bunker`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;
--- Dumping data for table `bunker_consumtion` --
INSERT INTO `bunker_consumtion` (`id_bunker`, `id_spr`, `port_from`, `port_to`, `date_from`, `utc_from`, `date_to`, `utc_to`, `distance`, `sea_time`, `av_speed`, `atd_mfo`, `atd_mdo`, `atd_hsd`, `ata_mfo`, `ata_mdo`, `ata_hsd`, `rep_mfo`, `rep_mdo`, `rep_hsd`, `atd1_mfo`, `atd1_mdo`, `atd1_hsd`, `speed`,
`sailing_time_acc`, `sailing_time_sea`, `port_time`, `speed_condition`, `delay_speed`, `despatch_speed`) VALUES (1, 1, '1', '2', '2009-06-01', '05:00:00', '2007-09-20', '11:00:00', '300', '30', 10, '234,56', '123,450', '222,22', '220', '120', '200', '200', '23', '34', '401', '140', '233', '10', '1.25', '1.25', '1,98', 'Speed Ok', '0', '0'), (2, 2, '', '', '2009-06-04', '05:00:00', '2009-06-05', '07:00:00', '', '', 12, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''), (3, 2, '2', '3', '2009-06-05', '05:00:00', '2009-06-07', '12:00:00', '', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
-- --------------------------------------------------------
--- Table structure for table `cargo_diff_evaluation` --
DROP TABLE IF EXISTS `cargo_diff_evaluation`; CREATE TABLE IF NOT EXISTS `cargo_diff_evaluation` ( `id_cargo` int(10) unsigned NOT NULL auto_increment, `id_spr` int(10) NOT NULL, `id_activity` int(10) NOT NULL, `tanggal` date NOT NULL, `atd_port` varchar(30) NOT NULL, `pre_bl` varchar(10) NOT NULL,
`pre_sfal` varchar(10) NOT NULL, `pre_sfbd` varchar(10) NOT NULL, `pre_sfad` varchar(10) NOT NULL, `pre_ar` varchar(10) NOT NULL, `pre_diff_r1` varchar(10) NOT NULL, `pre_r1` varchar(10) NOT NULL, `pre_diff_r2` varchar(10) NOT NULL, `pre_r2` varchar(10) NOT NULL, `pre_diff_r3` varchar(10) NOT NULL, `pre_r3` varchar(10) NOT NULL, `ker_bl` varchar(10) NOT NULL, `ker_sfal` varchar(10) NOT NULL, `ker_sfbd` varchar(10) NOT NULL, `ker_sfad` varchar(10) NOT NULL, `ker_ar` varchar(10) NOT NULL, `ker_diff_r1` varchar(10) NOT NULL, `ker_r1` varchar(10) NOT NULL, `ker_diff_r2` varchar(10) NOT NULL, `ker_r2` varchar(10) NOT NULL, `ker_diff_r3` varchar(10) NOT NULL, `ker_r3` varchar(10) NOT NULL, `sol_bl` varchar(10) NOT NULL, `sol_sfal` varchar(10) NOT NULL, `sol_sfbd` varchar(10) NOT NULL,
`sol_sfad` varchar(10) NOT NULL, `sol_ar` varchar(10) NOT NULL, `sol_diff_r1` varchar(10) NOT NULL, `sol_r1` varchar(10) NOT NULL, `sol_diff_r2` varchar(10) NOT NULL, `sol_r2` varchar(10) NOT NULL, `sol_diff_r3` varchar(10) NOT NULL, `sol_r3` varchar(10) NOT NULL, PRIMARY KEY (`id_cargo`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--- Dumping data for table `cargo_diff_evaluation` --
INSERT INTO `cargo_diff_evaluation` (`id_cargo`, `id_spr`, `id_activity`, `tanggal`, `atd_port`, `pre_bl`, `pre_sfal`, `pre_sfbd`, `pre_sfad`, `pre_ar`, `pre_diff_r1`, `pre_r1`, `pre_diff_r2`, `pre_r2`, `pre_diff_r3`, `pre_r3`, `ker_bl`, `ker_sfal`, `ker_sfbd`, `ker_sfad`, `ker_ar`, `ker_diff_r1`, `ker_r1`, `ker_diff_r2`, `ker_r2`, `ker_diff_r3`, `ker_r3`, `sol_bl`, `sol_sfal`, `sol_sfbd`, `sol_sfad`, `sol_ar`, `sol_diff_r1`, `sol_r1`, `sol_diff_r2`, `sol_r2`, `sol_diff_r3`, `sol_r3`) VALUES (1, 1, 1, '2007-09-20', '1', '123450', '123330', '123225', '0', '123500', '120', '0.09720534', '105', '2', '-275', '-0.0000222', '123450', '123410', '123300',
'113280', '10000', '40', '0.03240178', '110', '4', '20', '0.00000162', '123450', '123380', '123180', '113300', '10000', '70', '0.05670311', '200', '6', '-120', '0.0000097'), (2, 2, 0, '0000-00-00', '', '', '', '', '', '', '', '', '', '8', '', '', '', '', '', '', '', '', '', '', '10', '', '', '', '', '', '', '', '', '', '', '12', '', '');
-- --------------------------------------------------------
--- Table structure for table `idle` --
DROP TABLE IF EXISTS `idle`; CREATE TABLE IF NOT EXISTS `idle` ( `id` int(10) unsigned NOT NULL auto_increment, `id_spr` int(10) NOT NULL, `idle1` varchar(10) NOT NULL, `idle2` varchar(10) NOT NULL, `idle3` varchar(10) NOT NULL, `idle4` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `idle` --
INSERT INTO `idle` (`id`, `id_spr`, `idle1`, `idle2`, `idle3`, `idle4`) VALUES (1, 1, '1', '2', '4', '2');
-- --------------------------------------------------------
--- Table structure for table `in_port_evaluation` --
DROP TABLE IF EXISTS `in_port_evaluation`; CREATE TABLE IF NOT EXISTS `in_port_evaluation` ( `id` int(10) unsigned NOT NULL auto_increment, `id_spr` int(10) NOT NULL, `heating_in_port` varchar(10) NOT NULL, `ballasting` varchar(10) NOT NULL, `deballasting` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--- Dumping data for table `in_port_evaluation`
--
INSERT INTO `in_port_evaluation` (`id`, `id_spr`, `heating_in_port`, `ballasting`, `deballasting`) VALUES (1, 1, '45', '22', '26');
-- --------------------------------------------------------
--- Table structure for table `maneuvering` --
DROP TABLE IF EXISTS `maneuvering`; CREATE TABLE IF NOT EXISTS `maneuvering` ( `id` int(10) unsigned NOT NULL auto_increment, `id_spr` int(10) NOT NULL, `man1` varchar(10) NOT NULL, `man2` varchar(10) NOT NULL, `man3` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--- Dumping data for table `maneuvering`
--
INSERT INTO `maneuvering` (`id`, `id_spr`, `man1`, `man2`, `man3`) VALUES (1, 1, '3', '4', '2');
-- --------------------------------------------------------
--- Table structure for table `ms_activity` --
DROP TABLE IF EXISTS `ms_activity`; CREATE TABLE IF NOT EXISTS `ms_activity` ( `id_activity` int(10) unsigned NOT NULL auto_increment, `nama_activity` varchar(30) NOT NULL, `activity_stat` tinyint(2) NOT NULL default '0', PRIMARY KEY (`id_activity`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--- Dumping data for table `ms_activity` --
INSERT INTO `ms_activity` (`id_activity`, `nama_activity`, `activity_stat`) VALUES (1, 'Discharging', 0), (2, 'Closed Bunker', 0);
-- --------------------------------------------------------
--- Table structure for table `ms_officer` --
DROP TABLE IF EXISTS `ms_officer`; CREATE TABLE IF NOT EXISTS `ms_officer` ( `id_officer` int(10) unsigned NOT NULL auto_increment, `np_officer` varchar(15) NOT NULL, `nama_officer` varchar(50) NOT NULL, `officer_stat` tinyint(2) NOT NULL, PRIMARY KEY (`id_officer`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--- Dumping data for table `ms_officer` --
INSERT INTO `ms_officer` (`id_officer`, `np_officer`, `nama_officer`, `officer_stat`) VALUES (1, '112233', 'Gunawan Santoso', 0), (2, '145987', 'Heri Irawan', 0), (3, '369333', 'Pep Guardiola', 0), (4, '753951', 'Marcelo Lippi', 0), (5, '187535', 'Marco Van Basten', 0);
-- --------------------------------------------------------
--- Table structure for table `ms_port` --
DROP TABLE IF EXISTS `ms_port`; CREATE TABLE IF NOT EXISTS `ms_port` ( `id_port` int(10) unsigned NOT NULL auto_increment, `nama_port` varchar(50) collate latin1_general_ci NOT NULL, `port_stat` tinyint(2) NOT NULL default '0', PRIMARY KEY (`id_port`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;
--
-- Dumping data for table `ms_port` --
INSERT INTO `ms_port` (`id_port`, `nama_port`, `port_stat`) VALUES (1, 'Tanjung Priok', 0), (2, 'Tanjung Gerem', 0), (3, 'Pangkalbalam', 0), (4, 'Samratulangi', 0), (5, 'Cilacap', 0);
-- --------------------------------------------------------
--- Table structure for table `ms_spr` --
DROP TABLE IF EXISTS `ms_spr`; CREATE TABLE IF NOT EXISTS `ms_spr` ( `id_spr` int(10) unsigned NOT NULL auto_increment, `id_vessel` varchar(50) collate latin1_general_ci NOT NULL, `no_voyage` int(10) NOT NULL, `condition_sea_passage` varchar(10) collate latin1_general_ci NOT NULL, `user_update` varchar(30) collate latin1_general_ci NOT NULL, `tanggal_masuk` date NOT NULL,
`chief_officer` varchar(15) collate latin1_general_ci NOT NULL, `chief_engineer` varchar(15) collate latin1_general_ci NOT NULL, `master` varchar(15) collate latin1_general_ci NOT NULL, PRIMARY KEY (`id_spr`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;
--- Dumping data for table `ms_spr` --
INSERT INTO `ms_spr` (`id_spr`, `id_vessel`, `no_voyage`, `condition_sea_passage`, `user_update`, `tanggal_masuk`, `chief_officer`, `chief_engineer`, `master`) VALUES (1, 'MT. SINDANG /P 1111', 1, 'Laden', 'admin', '2009-06-08', '112233', '187535', '753951'), (2, 'MT. SINDANG /P 1111', 2, '', 'admin', '2009-06-13', '', '', '');
-- --------------------------------------------------------
--- Table structure for table `ms_vessel` --
DROP TABLE IF EXISTS `ms_vessel`; CREATE TABLE IF NOT EXISTS `ms_vessel` ( `id_vessel` int(10) unsigned NOT NULL auto_increment, `nama_vessel` varchar(50) collate latin1_general_ci NOT NULL, `vessel_stat` smallint(2) NOT NULL default '0', PRIMARY KEY (`id_vessel`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;
--- Dumping data for table `ms_vessel` --
INSERT INTO `ms_vessel` (`id_vessel`, `nama_vessel`, `vessel_stat`) VALUES (1, 'MT. SINDANG /P 3333', 0), (2, 'MT. SINDANG /P 2222', 0), (3, 'MT. SINDANG /P 1111', 0);
-- --------------------------------------------------------
--- Table structure for table `ms_voyage` --
DROP TABLE IF EXISTS `ms_voyage`; CREATE TABLE IF NOT EXISTS `ms_voyage` ( `id_voyage` int(10) unsigned NOT NULL auto_increment, `id_vessel` int(10) NOT NULL, `nama_voyage` varchar(20) NOT NULL, `voyage_stat` tinyint(2) NOT NULL default '0', PRIMARY KEY (`id_voyage`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--- Dumping data for table `ms_voyage` --
INSERT INTO `ms_voyage` (`id_voyage`, `id_vessel`, `nama_voyage`, `voyage_stat`) VALUES (1, 3, '11/DD/2007', 0), (2, 3, '11/DA/2007', 0), (3, 3, '11/EE/2007', 0), (4, 2, '22/XX/2007', 0), (5, 2, '22/OO/2007', 0), (6, 2, '22/YY/2007', 0), (7, 1, '33/MM/2007', 0), (8, 1, '33/NN/2007', 0),
(9, 1, '33/PP/2007', 0);
-- --------------------------------------------------------
--- Table structure for table `officer` --
DROP TABLE IF EXISTS `officer`; CREATE TABLE IF NOT EXISTS `officer` ( `id_officer` int(10) unsigned NOT NULL auto_increment, `id_spr` int(10) NOT NULL, `chief_officer` int(10) NOT NULL, `chief_engineer` int(10) NOT NULL, `master` int(10) NOT NULL, PRIMARY KEY (`id_officer`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--- Dumping data for table `officer` --
-- --------------------------------------------------------
--- Table structure for table `rate_performance` --
DROP TABLE IF EXISTS `rate_performance`; CREATE TABLE IF NOT EXISTS `rate_performance` ( `id_rate` int(10) unsigned NOT NULL auto_increment, `id_spr` int(10) NOT NULL, `avg_rate` varchar(10) NOT NULL, `seq_load` varchar(10) NOT NULL, `pre_disch` varchar(10) NOT NULL, `pre_commenced_date` date NOT NULL, `pre_commenced_time` time NOT NULL, `pre_complete_date` date NOT NULL, `pre_complete_time` time NOT NULL, `pre_stop1` varchar(10) NOT NULL, `pre_stop2` varchar(10) NOT NULL, `pre_stop3` varchar(10) NOT NULL, `pre_stop4` varchar(10) NOT NULL, `pre_total_time` varchar(10) NOT NULL, `pre_rate` varchar(10) NOT NULL, `pre_rate_agree` varchar(10) NOT NULL, `pre_rate_condition` varchar(10) NOT NULL,
`pre_delay` varchar(10) NOT NULL, `pre_despatch` varchar(10) NOT NULL, `ker_disch` varchar(10) NOT NULL, `ker_commenced_date` date NOT NULL, `ker_commenced_time` time NOT NULL, `ker_complete_date` date NOT NULL, `ker_complete_time` time NOT NULL, `ker_stop1` varchar(10) NOT NULL, `ker_stop2` varchar(10) NOT NULL, `ker_stop3` varchar(10) NOT NULL, `ker_stop4` varchar(10) NOT NULL, `ker_total_time` varchar(10) NOT NULL, `ker_rate` varchar(10) NOT NULL, `ker_rate_agree` varchar(10) NOT NULL, `ker_rate_condition` varchar(10) NOT NULL, `ker_delay` varchar(10) NOT NULL, `ker_despatch` varchar(10) NOT NULL, `sol_disch` varchar(10) NOT NULL, `sol_commenced_date` date NOT NULL, `sol_commenced_time` time NOT NULL, `sol_complete_date` date NOT NULL, `sol_complete_time` time NOT NULL, `sol_stop1` varchar(10) NOT NULL, `sol_stop2` varchar(10) NOT NULL,
`sol_stop3` varchar(10) NOT NULL, `sol_stop4` varchar(10) NOT NULL, `sol_total_time` varchar(10) NOT NULL, `sol_rate` varchar(10) NOT NULL, `sol_rate_agree` varchar(10) NOT NULL, `sol_rate_condition` varchar(10) NOT NULL, `sol_delay` varchar(10) NOT NULL, `sol_despatch` varchar(10) NOT NULL, PRIMARY KEY (`id_rate`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--- Dumping data for table `rate_performance` --
INSERT INTO `rate_performance` (`id_rate`, `id_spr`, `avg_rate`, `seq_load`, `pre_disch`, `pre_commenced_date`, `pre_commenced_time`, `pre_complete_date`, `pre_complete_time`, `pre_stop1`, `pre_stop2`, `pre_stop3`, `pre_stop4`, `pre_total_time`, `pre_rate`, `pre_rate_agree`, `pre_rate_condition`, `pre_delay`, `pre_despatch`, `ker_disch`, `ker_commenced_date`, `ker_commenced_time`, `ker_complete_date`, `ker_complete_time`, `ker_stop1`, `ker_stop2`, `ker_stop3`, `ker_stop4`, `ker_total_time`, `ker_rate`, `ker_rate_agree`, `ker_rate_condition`, `ker_delay`, `ker_despatch`, `sol_disch`, `sol_commenced_date`, `sol_commenced_time`,
`sol_complete_date`, `sol_complete_time`, `sol_stop1`, `sol_stop2`, `sol_stop3`, `sol_stop4`, `sol_total_time`, `sol_rate`, `sol_rate_agree`, `sol_rate_condition`, `sol_delay`, `sol_despatch`) VALUES (2, 1, '20', '1', '19614', '2007-09-17', '13:00:00', '2007-09-18', '13:00:00', '1', '1', '1', '1', '20', '980,70', '700', 'Ok', '0', '0,334', '19620', '2007-09-17', '18:20:00', '200709-19', '18:20:00', '1', '1', '1', '1', '44', '445,91', '700', 'Slow', '0,665', '0', '25000', '2007-09-17', '18:30:00', '2007-09-19', '18:20:00', '1', '1', '1', '1', '36', '694,44', '900', 'Slow', '0,343', '0'), (3, 2, '22', '1', '', '0000-00-00', '00:00:00', '0000-00-00', '00:00:00', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '00:00:00', '0000-00-00', '00:00:00', '', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '00:00:00', '0000-00-00', '00:00:00', '', '', '', '', '', '', '', '', '', '');
-- --------------------------------------------------------
--- Table structure for table `schedules` --
DROP TABLE IF EXISTS `schedules`; CREATE TABLE IF NOT EXISTS `schedules` ( `id_schedule` int(10) unsigned NOT NULL auto_increment, `nama_vessel` varchar(30) NOT NULL, `atd` date NOT NULL, `ata` date NOT NULL,
`user_update` varchar(50) NOT NULL, `tanggal_masuk` date NOT NULL, PRIMARY KEY (`id_schedule`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--- Dumping data for table `schedules` --
INSERT INTO `schedules` (`id_schedule`, `nama_vessel`, `atd`, `ata`, `user_update`, `tanggal_masuk`) VALUES (1, 'MT. SINDANG /P 1111', '2009-06-01', '2009-06-08', 'admin', '2009-06-14');
-- --------------------------------------------------------
--- Table structure for table `ship_activity` --
DROP TABLE IF EXISTS `ship_activity`; CREATE TABLE IF NOT EXISTS `ship_activity` ( `id` int(10) unsigned NOT NULL auto_increment, `id_spr` int(10) NOT NULL, `tank_cleaning_start_date` varchar(10) NOT NULL,
`tank_cleaning_start_time` varchar(10) NOT NULL, `tank_cleaning_finish_date` varchar(10) NOT NULL, `tank_cleaning_finish_time` varchar(10) NOT NULL, `heating_at_sea_start_date` varchar(10) NOT NULL, `heating_at_sea_start_time` varchar(10) NOT NULL, `heating_at_sea_finish_date` varchar(10) NOT NULL, `heating_at_sea_finish_time` varchar(10) NOT NULL, `heating_in_port_start_date` varchar(10) NOT NULL, `heating_in_port_start_time` varchar(10) NOT NULL, `heating_in_port_finish_date` varchar(10) NOT NULL, `heating_in_port_finish_time` varchar(10) NOT NULL, `ballasting_start_date` varchar(10) NOT NULL, `ballasting_start_time` varchar(10) NOT NULL, `ballasting_finish_date` varchar(10) NOT NULL, `ballasting_finish_time` varchar(10) NOT NULL, `deballasting_start_date` varchar(10) NOT NULL, `deballasting_start_time` varchar(10) NOT NULL, `deballasting_finish_date` varchar(10) NOT NULL, `deballasting_finish_time` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--- Dumping data for table `ship_activity`
--
INSERT INTO `ship_activity` (`id`, `id_spr`, `tank_cleaning_start_date`, `tank_cleaning_start_time`, `tank_cleaning_finish_date`, `tank_cleaning_finish_time`, `heating_at_sea_start_date`, `heating_at_sea_start_time`, `heating_at_sea_finish_date`, `heating_at_sea_finish_time`, `heating_in_port_start_date`, `heating_in_port_start_time`, `heating_in_port_finish_date`, `heating_in_port_finish_time`, `ballasting_start_date`, `ballasting_start_time`, `ballasting_finish_date`, `ballasting_finish_time`, `deballasting_start_date`, `deballasting_start_time`, `deballasting_finish_date`, `deballasting_finish_time`) VALUES (1, 1, '2009-06-13', '05:00:00', '2009-06-13', '11:00:00', '2009-06-13', '12:00:00', '2009-06-14', '05:00:00', '2009-06-14', '05:00:00', '2009-06-15', '11:00:00', '200906-15', '11:00:00', '2009-06-15', '11:00:00', '2009-06-15', '11:00:00', '2009-06-15', '11:00:00');
-- --------------------------------------------------------
--- Table structure for table `ship_movement` --
DROP TABLE IF EXISTS `ship_movement`;
CREATE TABLE IF NOT EXISTS `ship_movement` ( `id` int(10) unsigned NOT NULL auto_increment, `id_spr` int(10) NOT NULL, `sm_date` date NOT NULL, `sm_local_time` time NOT NULL, `nor_accepted_date` date NOT NULL, `nor_accepted_time` time NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--- Dumping data for table `ship_movement` --
INSERT INTO `ship_movement` (`id`, `id_spr`, `sm_date`, `sm_local_time`, `nor_accepted_date`, `nor_accepted_time`) VALUES (1, 1, '2009-06-13', '05:00:00', '2009-06-15', '06:00:00');
-- --------------------------------------------------------
--- Table structure for table `user` --
DROP TABLE IF EXISTS `user`; CREATE TABLE IF NOT EXISTS `user` ( `username` char(30) collate latin1_general_ci NOT NULL, `password` varchar(50) collate latin1_general_ci NOT NULL, `user_stat` smallint(2) NOT NULL, PRIMARY KEY (`username`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
--- Dumping data for table `user` --
INSERT INTO `user` (`username`, `password`, `user_stat`) VALUES ('admin', '4297f44b13955235245b2497399d7a93', 2), ('sahib', '4297f44b13955235245b2497399d7a93', 1), ('herman', '4297f44b13955235245b2497399d7a93', 2), ('hermin', '4297f44b13955235245b2497399d7a93', 1);