1 SISTEM INFORMASI PEMESANAN PADA AGEN PERJALANAN Tiurma Laosma Agustina Purba / Jurusan Sistem Komputer, Fakultas Teknik Universitas Kristen Maranath...
Tiurma Laosma Agustina Purba / 0927039 Jurusan Sistem Komputer, Fakultas Teknik Universitas Kristen Maranatha Jalan Prof. drg. Surya Sumantri, MPH 65 Bandung
ABSTRAK Dalam dunia industri Tour dan travel, banyak sekali data yang dikelola dan pengelolaan tersebut dilakukan hampir setiap hari. Data – data dalam industri Tour dan travel sangatlah banyak dan memiliki sifat yang selalu berubah – ubah, dan perubahan data tersebut tidak menentu setiap waktunya. Pengelolaan data yang sangat banyak akan menjadi sangat rumit bila dilakukan dengan cara manual. Pengelolaan secara manual juga bisa menimbulkan kemungkinan terjadinya kesalahan dalam pengelolaan data. Sistem Informasi Pemesanan pada Agen Perjalanan ini dibuat dengan harapan untuk dapat meminimalkan kemungkinan kesalahan yang terjadi dalam melakukan pengelolaan data dan membantu mengurangi kerumitan dalam pengelolaan data. Sistem ini dibuat dirancang dengan menggunakan program Delphi 7.0, Interbase sebagai databasenya, dan Rave Report untuk pembuatan laporan.
i
Universitas Kristen Maranatha
ELECTRONIC – BOOKING SYSTEM FOR TRAVEL AGENT OFFICE
Tiurma Laosma Agustina Purba / 0927039 Jurusan Sistem Komputer, Fakultas Teknik Universitas Kristen Maranatha Jalan Prof. drg. Surya Sumantri, MPH 65 Bandung
ABSTRACT In Tour and travel industry, lots of data is managed every day. The data is frequently updated. Data management become very complicated when it is done manually. Manual data management is error prone. This Electronic Booking System for Travel Agent Office have a goal to minimize human error and the cumbersome of manual data management. This system developed using Delphi 7.0 program, Interbase as the database, and Rave Report to generate official reports.
ii
Universitas Kristen Maranatha
DAFTAR ISI
ABSTRAK ....................................................................................................... i ABSTRACT....................................................................................................... ii DAFTAR ISI ................................................................................................... iii DAFTAR GAMBAR ...................................................................................... viii BAB I PENDAHULUAN ............................................................................... 1 1.1 LATAR BELAKANG ................................................................. 1 1.2 IDENTIFIKASI MASALAH ....................................................... 2 1.3 TUJUAN ..................................................................................... 2 1.4 PEMBATASAN MASALAH ...................................................... 2 1.5 SISTEMATIKA PEMBAHASAN ............................................... 2 BAB II LANDASAN TEORI ......................................................................... 4 2.1 Sistem .......................................................................................... 4 2.1.1
Definisi Sistem .............................................................. 4
2.1.2
Karakteristik Sistem ...................................................... 5
Sejarah Singkat ............................................................. 17
2.5.3
Pemakaian Dasar ........................................................... 17
2.6 SDLC ( System Development Life Cycle ) ....................................... 18 2.7 Diagram Konteks ( Context Diagram ) ........................................... 19 2.8 Diagram Arus Data ( Data Flow Diagram ) .................................... 19 2.9 Arsitektur Sistem ............................................................................ 20 2.9.1
Sistem Tunggal / Mandiri ( Stand Alone )...................... 20
2.9.2
Sistem Tersentralisasi ( Centralized System ) ................ 20
2.9.3
Sistem Client – Server .................................................. 21
2.10 Interbase ...................................................................................... 21 2.11 Borland Delphi ............................................................................ 22 BAB III PERANCANGAN ............................................................................ 24 3.1 Digram Konteks ......................................................................... 24 3.2 Bagan Berjenjang ....................................................................... 25 3.3 Diagram Arus Data ..................................................................... 26 3.3.1 Diagram Tingkat Nol Sistem Informasi Pemesanan Pada Agen Perjalanan ............................................................ 26 3.3.2 DAD Tingkat Satu Penginputan Data .............................. 27 3.3.3 DAD Tingkat Satu Memproses Pesanan .......................... 28 3.3.4 DAD Tingkat Satu Proses Transaksi Pembayaran ........... 29 3.3.5 DAD Tingkat Satu Proses Pembuatan Laporan ............... 29 3.3.6 DAD Keseluruhan ........................................................... 31 3.4.
Perancangan Database ............................................................. 32 3.4.1 Perangkat Lunak .............................................................. 32 3.4.2 Konfigurasi SQL Manager 2008....................................... 33 3.4.3 Membuat Tabel ................................................................ 39 3.4.4 Rancangan Delapan Belas Tabel ...................................... 41
4.1. Proses pada Form Customer ...................................................... 95 4.2. Proses pada Form Staff .............................................................. 100 4.3.
Proses pada Form Tiket Pesawat .............................................. 104
4.4. Proses pada Form Voucher Hotel .............................................. 112 4.5. Proses pada Form Tour ............................................................. 118 4.6. Proses Transaksi Tiket ............................................................... 122 4.7.
Proses Pemesanan Voucher ...................................................... 124
4.8.
Proses Transaksi Tour .............................................................. 126
4.9. Form Transaksi Tunai ............................................................... 128 4.10. Form Pembayaran Kredit .......................................................... 129 4.11. Form Pelunasan......................................................................... 130 4.12. Form Pembayaran ..................................................................... 130 BAB V KESIMPULAN DAN SARAN .......................................................... 131 5.1
Context Diagram Sistem Agen Perjalanan ................................ 24
Gambar 3.2
Bagan Berjenjang Sistem Informasi Pemesanan Agen Perjalanan ................................................................................. 25
Gambar 3.3
DAD Tingkat Nol .................................................................... 27
Gambar 3.4
DAD Tingkat Satu Memproses Penginputan Data ..................... 28
Gambar 3.5
DAD Tingkat Satu Memproses Pesanan.................................... 28
Gambar 3.6
Proses Transaksi Pembayaran ................................................... 29
Gambar 3.7
DAD Proses Pembuatan Laporan .............................................. 30
Gambar 3.8
DAD Sistem Pemesanan Pada Agen Pemesanan Keseluruhan Proses Satu hingga Proses Empat ......................... 31
Gambar 3.9
DAD Sistem Pemesanan pada Agen Pemesanan Pada Agen Pemesanan Keseluruhan Lima Proses ..................... 31
Gambar 3.10 SQL Manager 2008 ..................................................................... 32 Gambar 3.11 Tampilan SQL Manager 2008 ..................................................... 32 Gambar 3.12 Register Host ............................................................................ 33 Gambar 3.13 Register Host Wizard Spesifik................................................... 34 Gambar 3.14 Create Database ......................................................................... 34 Gambar 3.16 Create Database Icon ................................................................. 35 vi
Universitas Kristen Maranatha
Gambar 3.17 Host Name .................................................................................. 35 Gambar 3.18 Create Database ......................................................................... 35 Gambar 3.19 Hasil Pernyataan SQL ................................................................. 43 Gambar 3.20 Icon Register Database ............................................................... 36 Gambar 3.21 Register Database ....................................................................... 36 Gambar 3.22 Pemilihan Nama Host ............................................................... 37 Gambar 3.23 Tampilan Register Database Spesifik ......................................... 37 Gambar 3.24 Register Database Spesifik Database Name ............................. 38 Gambar 3.25 Register Database pada Local Host .......................................... 38 Gambar 3.26 Membuat SQL ............................................................................ 39 Gambar 3.27 SQL Script Icon .......................................................................... 39 Gambar 3.38 SQL Script ............................................................................... 40 Gambar 3.29 Jendela Skrip SQL ...................................................................... 40 Gambar 3.30 Eksekusi Skrip SQL .................................................................... 40 Gambar 3.31 Skrip SQL Tabel Customer ......................................................... 41 Gambar 3.32 Tabel Customer ......................................................................... 41 Gambar 3.33 Skrip SQL Tabel Staff ................................................................. 42 Gambar 3.34 Tabel Staff .................................................................................. 42 Gambar 3.35 Skrip SQL Tabel Airline dan Airlinedetail ................................ 43 Gambar 3.36 Tabel Airline ............................................................................. 43 Gambar 3.37 Tabel Airlinedetail .................................................................... 43 Gambar 3.38 Skrip SQL Tabel Hotel dan Hoteldetail ....................................... 44 Gambar 3.39 Tabel Hotel ................................................................................. 44 Gambar 3.40 Tabel Hoteldetail....................................................................... 45 Gambar 3.41 Skrip SQL Tabel Tour ................................................................. 45 Gambar 3.42 Tabel Tour ................................................................................ 45 Gambar 3.43 Skrip SQL Tabel Tiket dan Tiketdetail...................................... 46 vii
Universitas Kristen Maranatha
Gambar 3.44 Tabel Tiket ................................................................................ 46 Gambar 3.45 Tabel Tiketdetail ....................................................................... 46 Gambar 3.46 Skrip SQL Tabel Voucher dan Voucherdetail ............................ 47 Gambar 3.47 Tabel Voucher ........................................................................... 47 Gambar 3.48 Tabel Voucherdetail .................................................................. 48 Gambar 3.49 Skrip SQL Tabel Tourorder dan Tourorderdetail ...................... 48 Gambar 3.50 Tabel Tourorder ........................................................................ 49 Gambar 3.51 Tabel Tourorderdetail ............................................................... 49 Gambar 3.52 Skrip SQL Tabel Totalbayar ..................................................... 49 Gambar 3.53 Tabel Totalbayar ....................................................................... 50 Gambar 3.54 SQL Skrip Tabel Pelunasan ...................................................... 50 Gambar 3.55 Tabel Pelunasan ........................................................................ 51 Gambar 3.56 Skrip SQL Tabel Kredit ............................................................ 51 Gambar 3.57 Tabel Kredit .............................................................................. 52 Gambar 3.58 Skrip SQL Tabel Kreditlunas .................................................... 52 Gambar 3.59 Tabel Kreditlunas ...................................................................... 53 Gambar 3.60 Skrip SQL Tabel Pembayaran ................................................... 53 Gambar 3.61 Relasi Tabel .............................................................................. 54 Gambar 3.62 Borland Delphi 7 ....................................................................... 54 Gambar 3.63 Tampilan Awal Borland Delphi 7 ............................................. 55 Gambar 3.64 Menu Awal ............................................................................... 55 Gambar 3.65 Mainmenu ................................................................................. 56 Gambar 3.66 Main Menu List ......................................................................... 56 Gambar 3.67 Main Menu Reservasi ............................................................... 57 Gambar 3.68 Main Menu Transaksi ............................................................... 57 Gambar 3.69 Main Menu Other...................................................................... 57 Gambar 3.70 Data Module ............................................................................. 58 viii
Universitas Kristen Maranatha
Gambar 3.71 Konfigurasi IBDatabase ............................................................ 59 Gambar 3.72 Tragen
Gambar 3.73 IBQuery .................................................................................. 60 Gambar 3.74 DataSource ............................................................................... 60 Gambar 3.75 Implementasi u_module ............................................................ 61 Gambar 3.76 Form Customer ......................................................................... 62 Gambar 3.77 Pengaturan Radiogroup Form Customer ................................... 63 Gambar 3.78 Form Staff ................................................................................. 64 Gambar 3.79 Radio Group Form Staff............................................................ 65 Gambar 3.80 Form Tiket ................................................................................ 67 Gambar 3.81 Radio Group ( 1 ) Form Tiket Pesawat ..................................... 68 Gambar 3.82 Radio Group ( 2 ) Form Tiket Pesawat ..................................... 69 Gambar 3.83 Form Voucher ........................................................................... 70 Gambar 3.84 Radio Group ( 1 ) Form Voucher .............................................. 72 Gambar 3.85 Radio Group ( 2 ) Form Voucher .............................................. 72 Gambar 3.86 Form Tour ................................................................................ 74 Gambar 3.87 Radio Group Form Tour ........................................................... 75 Gambar 3.88 Form Pesan Tiket ...................................................................... 76 Gambar 3.89 Form Pesan Voucher ................................................................. 78 Gambar 3.90 Form Pesan Tour ...................................................................... 81 Gambar 3.91Form Tunai .................................................................................. 83 Gambar 3.92 Form Kredit .............................................................................. 86 Gambar 3.93 Form Pelunasan ........................................................................ 88 Gambar 3.94 Form Pembayaran ..................................................................... 90 Gambar 3.95 Komponen Report ..................................................................... 92 Gambar 3.96 Desain Rave Report .................................................................. 93 Gambar 4.1 Tampilan Awal Sistem .................................................................. 94 ix
Universitas Kristen Maranatha
Gambar 4.2 Form Customer ............................................................................. 95 Gambar 4.3 Tabel Customer Sebelum Pemasukan Data ................................... 95 Gambar 4.4 Data Customer Baru ...................................................................... 96 Gambar 4.5 Tabel Customer Setelah Data Masuk............................................. 96 Gambar 4.6 Informasi Data Masuk Customer................................................... 96 Gambar 4.7 Data Customer Baru ...................................................................... 97 Gambar 4.8 Hapus Data Customer ................................................................... 97 Gambar 4.9 Kotak Dialog................................................................................. 98 Gambar 4.10 Pencarian berdasarkan Kode Customer ....................................... 98 Gambar 4.11 Pencarian berdasarkan Nama Customer ...................................... 98 Gambar 4.12 Pencarian berdasarkan Alamat Customer .................................... 99 Gambar 4.13 Data Customer ............................................................................ 99 Gambar 4.14 Form Staff .................................................................................. 100 Gambar 4.15 Tabel Staff Sebelum Pemasukan Data ......................................... 100 Gambar 4.16 Data Staff Baru .......................................................................... 101 Gambar 4.17 Tabel Staff Setelah Pemasukan Data ........................................... 101 Gambar 4.18 Informasi Data Staff Masuk ......................................................... 101 Gambar 4.19 Data Staff Baru ............................................................................ 102 Gambar 4.20 Hapus Data Staff ......................................................................... 102 Gambar 4.21 Kotak Dialog ............................................................................... 103 Gambar 4.22 Pencarian berdasarkan Kode Staff ............................................... 103 Gambar 4.23 Pencarian berdasarkan Nama Staff .............................................. 103 Gambar 4.24 Pencarian berdasarkan Alamat Staff ............................................ 104 Gambar 4.25 Data Staff .................................................................................. 104 Gambar 4.26 Form Staff ................................................................................. 105 Gambar 4.27 Tabel Airline Sebelum Pemasukan Data .................................... 105 Gambar 4.28 Tabel Airlinedetail Sebelum Pemasukan Data ........................... 105 x
Universitas Kristen Maranatha
Gambar 4.29 Data Tiket Baru......................................................................... 106 Gambar 4.30 Tabel Airline Setelah Data Masuk ............................................. 106 Gambar 4.31 Tabel Airlinedetail Setelah Data Masuk .................................... 106 Gambar 4.32 Data Tiket Baru......................................................................... 107 Gambar 4.33 Hapus Data Airline dan Tiket .................................................... 107 Gambar 4.34 Pencarian Berdasarkan Kode Airline ........................................... 108 Gambar 4.35 Pencarian Berdasarkan Tanggal ................................................ 108 Gambar 4.36 Pencarian Berdasarkan Source .................................................. 109 Gambar 4.37 Pencarian Berdasarkan Destination ............................................. 109 Gambar 4.38 Pencarian Berdasarkan Departure ............................................. 110 Gambar 4.39 Pencarian Berdasarkan Arrival .................................................... 110 Gambar 4.40 Pencarian Berdasarkan Kelas pada Tab Tiket Detail ................. 111 Gambar 4.41 Data Tiket ................................................................................. 111 Gambar 4.42 Form Voucher ........................................................................... 112 Gambar 4.43 Tabel Hotel Sebelum Pemasukan Data ........................................ 112 Gambar 4.44 Tabel Hoteldetail Sebelum Pemasukan Data ............................... 113 Gambar 4.45 Data Hotel dan Kamar Baru ...................................................... 113 Gambar 4.46 Tabel Hotel Setelah Data Masuk ............................................... 113 Gambar 4.47 Tabel Hoteldetail Setelah Data Masuk ........................................ 114 Gambar 4.48 Data Voucher Data .................................................................... 115 Gambar 4.49 Hapus Data Hotel dan Voucher ................................................. 115 Gambar 4.50 Pencarian Berdasarkan Nama Hotel .......................................... 116 Gambar 4.51 Pencarian Berdasarkan Kota........................................................ 116 Gambar 4.52 Pencarian Berdasarkan Bintang Hotel ......................................... 117 Gambar 4.53 Pencarian Berdasarakan Tipe Kamar ........................................... 117 Gambar 4.54 Data Hotel ................................................................................. 118 Gambar 4.55 Form Tour .................................................................................. 118 xi
Universitas Kristen Maranatha
Gambar 4.56 Tabel Tour Sebelum Pemasukan Data ....................................... 119 Gambar 4.57 Data Tour Baru ........................................................................... 119 Gambar 4.58 Tabel Tour Masuk ....................................................................... 119 Gambar 4.59 Data Tour Baru ........................................................................... 120 Gambar 4.60 Hapus Data Tour ......................................................................... 120 Gambar 4.61 Pencarian Berdasarkan Nama Tour ............................................. 121 Gambar 4.62 Pencarian Berdasarkan Tanggal ................................................ 121 Gambar 4.63 Data Tour .................................................................................. 122 Gambar 4.64 Form Awal Pesan Tiket ............................................................ 122 Gambar 4.65 Pengisian Identitas Customer ...................................................... 123 Gambar 4.66 Pengisian Kriteria Pesanan Tiket ................................................. 123 Gambar 4.67 Perekaman Pesanan Data Tiket ................................................... 123 Gambar 4.68 Faktur Pesan Tiket ...................................................................... 124 Gambar 4.69 Konfirmasi Pembayaran .............................................................. 124 Gambar 4.70 Form Awal Pesan Voucher.......................................................... 125 Gambar 4.71 Pengisian Kriteria Pesanan Voucher............................................ 125 Gambar 4.72 Faktur Pemesanan Voucher Hotel ............................................... 126 Gambar 4.73 Pengisian Kriteria Pesanan Tour ................................................. 126 Gambar 4.74 Faktur Pesan Tour ....................................................................... 127 Gambar 4.75 Transaksi Pemesanan Tour .......................................................... 127 Gambar 4.75 Transaksi Pembayaran Tunai ...................................................... 128 Gambar 4.76 Data Transaksi Pembayaran Tunai ............................................. 128 Gambar 4.77 Transaksi Pembayaran Kredit...................................................... 129 Gambar 4.78 Data Pembayaran Kredit ............................................................. 129 Gambar 4.79 Transaksi Pelunasan .................................................................... 130 Gambar 4.80 Transaksi Pembayaran Ke Vendor .............................................. 131