REKAYASA PERANGKAT LUNAK
SISTEM INFORMASI PADA PERUSAHAAN AGEN MAJU MAPAN
Oleh : 1. Akhmad Zaenal Muttaqin
1211503493
2. Christian Yonathan S
1211501075
3. Demmy Dwi Ramadhan
1211500176
4. Eddo Careera Iriyanto Putra
1211501877
5. Ivanny Silviana Santoso
1211501885
6. M. Khailani Ridwan
1211503568
JURUSAN ILMU KOMPUTER FAKULTAS MATEMATIKA DAN ILMU PENGETAHUAN ALAM UNIVERSITAS GADJAH MADA 2014 i
REKAYASA PERANGKAT LUNAK
Daftar Isi Daftar Isi ............................................................................................................................... 1 Daftar Gambar ...................................................................................................................... 3 1.
Deskripsi Permasalahan ................................................................................................ 4
2.
Proses Bisnis ................................................................................................................. 4
3.
Analisis Sistem .............................................................................................................. 4 3.1
Analisis Kebutuhan .............................................................................................. 4
3.2
Spesifikasi Fungsional/Proses ............................................................................. 5
3.3
Spesifikasi Modul ................................................................................................. 5
4.
Spesifikasi Data ............................................................................................................. 6
5.
Design Arsitektur Sistem................................................................................................ 6
6.
Design Proses ............................................................................................................... 7 6.1
6.2
Data Flow Diagram .............................................................................................. 7 6.1.1
Data Flow Diagram Level 0 (Konteks) ...................................................... 7
6.1.2
Data Flow Diagram Level 1 ...................................................................... 7
6.1.3
Data Flow Diagram Level 2 ...................................................................... 8
Rancangan EER ................................................................................................ 12 6.2.1
7.
Design Object Oriented ................................................................................................ 16 7.1
7.2
Activity Diagram................................................................................................. 16 7.1.1
Activity Daftar ......................................................................................... 16
7.1.2
Activity Login .......................................................................................... 17
7.1.3
Activity Cek Kamar ................................................................................. 18
7.1.4
Activity Pesan Kamar ............................................................................. 19
7.1.5
Activity Pembayaran .............................................................................. 20
Use Case Diagram ............................................................................................ 21 7.2.1
7.3 7.4
Use Case Sistem Hotel .......................................................................... 21
Class Diagram ................................................................................................... 21 7.3.1
8.
Deskripsi Tabel ...................................................................................... 12
Class Sistem Integrasi Agen Hotel ......................................................... 21
Sequence Diagram ............................................................................................ 22 7.4.1
Sequence Diagram Mengelola Data Hotel.............................................. 22
7.4.2
Sequence Diagram Mengelola Data Customer....................................... 23
7.4.3
Sequence Diagram Pemesanan Hotel ................................................... 24
Implementasi Design User Interface ............................................................................ 25 8.1
Design User Interface Hotel ............................................................................... 25 1
REKAYASA PERANGKAT LUNAK
8.2
8.3
8.1.1
Form Hotel ............................................................................................. 25
8.1.2
Form Hotel Chain ................................................................................... 26
8.1.3
Form City ............................................................................................... 26
8.1.4
Form Calendar ....................................................................................... 27
8.1.5
Form Tipe Kamar ................................................................................... 27
8.1.6
Form Tarif Kamar Harian........................................................................ 28
8.1.7
Form Room Available............................................................................. 28
8.1.8
Form Kamar ........................................................................................... 29
8.1.9
Form Tempat Wisata .............................................................................. 29
Design User Interface Agency ........................................................................... 30 8.2.1
Halaman Utama ..................................................................................... 30
8.2.2
Form Daftar ............................................................................................ 31
8.2.3
Form Login ............................................................................................. 32
8.2.4
Form Profil Member ............................................................................... 33
8.2.5
Form Cari Hotel ...................................................................................... 34
8.2.6
Halaman Hasil Pencarian Hotel.............................................................. 35
8.2.7
List Tipe Kamar ...................................................................................... 36
8.2.8
Form Booking......................................................................................... 37
8.2.9
Halaman sukses booking ....................................................................... 38
Desain Tampilan Bank....................................................................................... 39 8.3.1
Form Login ............................................................................................. 39
8.3.2
Form Profil Nasabah .............................................................................. 39
8.3.3
Form Transfer ........................................................................................ 40
8.3.4
Form Transaksi ...................................................................................... 41
2
REKAYASA PERANGKAT LUNAK
Daftar Gambar
Gambar 1. Gambar 2. Gambar 3. Gambar 4. Gambar 5. Gambar 6. Gambar 7. Gambar 8. Gambar 9. Gambar 10. Gambar 11. Gambar 12. Gambar 13. Gambar 14. Gambar 15. Gambar 16. Gambar 17. Gambar 18. Gambar 19. Gambar 20. Gambar 21. Gambar 22. Gambar 23. Gambar 24. Gambar 25. Gambar 26. Gambar 27. Gambar 28. Gambar 29. Gambar 30. Gambar 31. Gambar 32. Gambar 33. Gambar 34. Gambar 35. Gambar 36. Gambar 37. Gambar 38. Gambar 39. Gambar 40. Gambar 41. Gambar 42.
Arsitektur Sistem ........................................................................................................ 6 DFD Level Konteks ...................................................................................................... 7 DFD Level 1................................................................................................................. 8 DFD Level 2 Proses Upload Data Hotel ........................................................................ 9 DFD Level 2 Proses Pengecekan Kamar Hotel .............................................................. 9 DFD Level 2 Proses Pemesanan Hotel ....................................................................... 10 DFD Level 2 Proses Pembayaran Hotel ...................................................................... 11 Rancangan EER ......................................................................................................... 12 Activity Diagram Daftar ............................................................................................ 16 Activity Diagram Login .............................................................................................. 17 Activity Diagram Cek Kamar ...................................................................................... 18 Activity Diagram Pesan Kamar .................................................................................. 19 Activity Diagram Pembayaran ................................................................................... 20 Use Case Sistem Hotel .............................................................................................. 21 Class Sistem Informasi Agen Hotel ............................................................................ 21 Sequence Diagram mengelola data hotel .................................................................. 22 Sequence Diagram Mengelola Data Customer .......................................................... 23 Sequence diagram pemesanan hotel ........................................................................ 24 Form Hotel ............................................................................................................... 25 Form Hotel Chain...................................................................................................... 26 Form City .................................................................................................................. 26 Form Calendar .......................................................................................................... 27 Form Tipe Kamar ...................................................................................................... 27 Form Tarif Kamar Harian........................................................................................... 28 Form Room Available ............................................................................................... 28 Form Kamar.............................................................................................................. 29 Form Tempat Wisata ................................................................................................ 29 Halaman Utama........................................................................................................ 30 Form Daftar .............................................................................................................. 31 Form Login ............................................................................................................... 32 Halaman Profil Member ........................................................................................... 33 Form Cari Hotel ........................................................................................................ 34 Halaman Hasil Pencarian Hotel ................................................................................. 35 Halaman List Tipe Kamar .......................................................................................... 36 Form Booking ........................................................................................................... 37 Halaman Sukses Booking .......................................................................................... 38 Form Login Bank ....................................................................................................... 39 Form Profil Nasabah ................................................................................................. 39 Transfer 1 ................................................................................................................. 40 Transfer 2 ................................................................................................................. 40 Transfer 3 ................................................................................................................. 40 Form Transaksi ......................................................................................................... 41
3
REKAYASA PERANGKAT LUNAK
1. Deskripsi Permasalahan Dewasa ini, banyak orang yang mulai menyukai kegiatan travelling. Tetapi terkendala oleh informasi yang kurang lengkap tentang lokasi penginapan yang ada disekitar tempat tujuan travelling. Misalkan seseorang ingin berpergian ke suatu tempat, tetapi dikarenakan kurangnya informasi tentang lokasi penginapan yang ingin dituju, banyak yang mengurungkan niat untuk travelling daripada beresiko tidak mendapat tempat penginapan. Disinilah peran agen membantu memberikan informasi lokasi penginapan pada tempat tujuan travelling. Namun, pada proses kegiatan pemesanan hotel pada agen Travel Plus masih dilakukan secara manual dan tatap muka. Agen harus mengecek ketersediaan kamar hotel secara manual. Lalu Customer harus menunggu agen mengecek ketersediaan kamar. Setelah itu, Agen harus melakukan konfirmasi pesanan ke hotel secara manual. Hal tersebut menyebabkan pelayanan menjadi tidak efisien dalam kegiatan pemesanan hotel yang akan dipesan.
2. Proses Bisnis Proses bisnis yang terjadi antara pihak Agent dengan pihak Hotel adalah sebagai berikut: a) Pihak Hotel memberikan informasi berupa detail hotel dan detail kamar kepada Agent. b) Pihak Hotel memberikan informasi berupa ketersediaan kamar kepada pihak Agent. c) Pihak Agent memberikan informasi berupa detail hotel dan detail kamar yang tersedia kepada pihak Customer. d) Pihak Customer memberikan data diri kepada Agent, sebelum melakukan pemesanan. e) Pihak Customer harus melunasi tagihan pembayaran melalui Bank, untuk menyelesaikan proses pemesanan. f) Pihak Agent memberikan informasi berupa informasi pemesanan yang sudah dibayar oleh Customer melalui bank kepada pihak Hotel.
3. Analisis Sistem 3.1 Analisis Kebutuhan Karena semakin berkembangnya dunia dengan bantuan teknologi dan informasi, maka segala sesuatunya ingin lebih dimudahkan. Pada kenyataannya, tidak memungkinkan seseorang harus mengunjungi lokasi penginapan sebelum berpergian. Disinilah peran utama portal website sebuah Agen Travel Plus yang memungkingkan setiap orang lebih mudah untuk mengetahui informasi tempat penginapan dari berbagai tempat tujuan travelling. Customer dapat mengaksesnya tanpa harus pergi dari rumah ataupun mencari lokasi penginapan. Berikut beberapa poin kebutuhan yang harus dipenuhi oleh portal website sbb : a) Portal website dapat memberikan informasi detail hotel dan detail kamar.
4
REKAYASA PERANGKAT LUNAK
b) Portal website dapat memberikan informasi pada Customer ketersediaan kamar di tiap-tiap hotel . c) Customer dapat melakukan pemesanan hotel berdasarkan tempat tujuan travelling melalui portal website ini. d) Portal website dapat memberikan informasi pada Customer mengenai total biaya yang harus dibayar oleh Customer. e) Customer yang sudah melakukan pembayaran biaya booking melalui Bank dinyatakan
sudah
selesai
melakukan
pemesanan,
sebaliknya
tidak
melakukan pembayaran maka pesanan dinyatakan batal. 3.2 Spesifikasi Fungsional/Proses Proses yang terjadi antara pihak Agent dengan pihak Hotel sebagai berikut: a) Proses Upload Data Hotel adalah proses yang terjadi saat Hotel memberikan informasi detail hotel dan detail kamar pada pihak Agent. b) Proses Pengecekkan Kamar Hotel adalah proses yang terjadi saat Customer melihat list hotel dan list kamar yang tersedia berdasarkan tempat tujuan travelling, tanggal Check-In dan Check-Out. c) Proses Pemesanan Hotel adalah proses setelah Customer memilih hotel dan kamar yang diinginkan. d) Proses Pembayaran Booking adalah proses yang terjadi setelah Customer melakukan proses pemesanan , Customer harus membayar sesuai jumlah biaya tagihan melalui bank. e) Proses Update Ketersediaan Kamar Hotel adalah proses yang terjadi setelah customer melakukan pembayaran. Proses ini bertujuan untuk mengupdate ketersediaan kamar pada suatu hotel. 3.3 Spesifikasi Modul Spesifikasi modul berdasarkan pemodelan data sebagai berikut : a) Modul Customer adalah modul yang diperuntukkan untuk layanan Customer dalam Proses Pemesanan Hotel, Proses Pembayaran Booking. b) Modul Agent adalah modul yang diperuntukkan untuk layanan Agent dalam mengelola data hotel pada Proses Pengecekkan Kamar Hotel dan juga data Reservasi yang dilakukan Customer. c) Modul Hotel adalah modul yang diperuntukkan untuk layanan Hotel dalam Proses Upload Data Hotel dan Proses Update Ketersediaan Kamar Hotel
5
REKAYASA PERANGKAT LUNAK
yang dilakukan oleh pihak Hotel, kemudian diinformasikan kepada pihak Agent. d) Modul Bank adalah modul yang diperuntukkan untuk layanan Proses Pembayaran Booking yang dilakukan oleh Customer, kemudian Bank menginformasikan transaksi tersebut ke pihak Agen.
4. Spesifikasi Data Data Input
Tujuan travelling, atau Nama Hotel. Waktu Menginap (Check-In, Berapa Malam, Check-Out).
Kode Booking.
Data Output
Menampilkan list berdasarkan (Tujuan travelling, atau Nama Hotel) dengan batas waktu antara tanggal Check-In dan Check-Out.
Nama Hotel, Kamar Hotel, Tipe Kamar yang dibooking, Jumlah Booking kamar, Harga Kamar.
5. Design Arsitektur Sistem
Gambar 1.
Arsitektur Sistem
6
REKAYASA PERANGKAT LUNAK
6. Design Proses 6.1 Data Flow Diagram 6.1.1
Data Flow Diagram Level 0 (Konteks)
Terdiri dari 4 entitas yaitu Customer, Agen, Hotel, dan Bank dalam Sistem Terintegrasi Maju Mapan.
Gambar 2.
6.1.2
DFD Level Konteks
Data Flow Diagram Level 1
Terdiri dari 5 proses, 4 entitas dan 6 data store. Entitasnya terdiri dari Hotel, Customer, Agen, dan Bank. Prosesnya terdiri dari Proses Upload Data Hotel, Proses Pengecekan Kamar Hotel, Proses Pemesanan Hotel, Proses Pembayaran Hotel, dan Proses Update Ketersediaan Kamar. Data Storenya terdiri dari Tabel Hotel, Tabel Tipe Kamar, Tabel Customer, Tabel Booking, Tabel Transaksi dan Tabel Avail Kamar.
7
REKAYASA PERANGKAT LUNAK
Gambar 3.
6.1.3
DFD Level 1
Data Flow Diagram Level 2
6.1.3.1 Proses Upload Data Hotel
Terdiri dari 2 entitas, 2 proses dan 2 data store. Entitasnya terdiri dari Hotel dan Agen. Prosesnya terdiri dari Proses Upload Detil Hotel dan Load Data Hotel. Data Storenya terdiri dari Tabel Hotel dan Tabel Tipe Kamar.
8
REKAYASA PERANGKAT LUNAK
Gambar 4.
DFD Level 2 Proses Upload Data Hotel
6.1.3.2 2 Proses Pengecekan Kamar Hotel
Terdiri dari 1 entitas, 2 proses, dan 2 data store. Entitasnya terdiri dari Customer. Prosesnya terdiri dari Proses Cek List Hotel dan Cek List Kamar. Data Storenya terdiri dari Tabel Hotel dan Tabel Tipe Kamar.
Gambar 5.
DFD Level 2 Proses Pengecekan Kamar Hotel
9
REKAYASA PERANGKAT LUNAK 6.1.3.3 Proses Pemesanan Hotel
Terdiri dari 1 entitas, 4 proses, dan 4 data store. Entitasnya terdiri dari Customer. Prosesnya terdiri dari Proses Login, Pilih Hotel, Pilih Kamar, dan Pesan. Data Storenya terdiri dari Tabel Customer, Tabel Tipe Kamar, Tabel Hotel, dan Tabel Booking.
Gambar 6.
DFD Level 2 Proses Pemesanan Hotel
10
REKAYASA PERANGKAT LUNAK 6.1.3.4 Proses Pembayaran Hotel
Terdiri dari 2 entitas, 3 proses, dan 3 data store. Entitasnya terdiri dari Customer dan Bank. Prosesnya terdiri dari Proses Cek Transaksi, Cek Detil Pesanan, dan Transaksi Bank. Data Storenya terdiri dari Tabel Booking, Tabel Tipe Kamar dan Tabel Transaksi Bank.
Gambar 7.
DFD Level 2 Proses Pembayaran Hotel
11
REKAYASA PERANGKAT LUNAK
6.2 Rancangan EER
Gambar 8.
6.2.1
Rancangan EER
Deskripsi Tabel
DROP TABLE IF EXISTS `agents`; CREATE TABLE `agents` ( `agent_id` char(8) NOT NULL, `agent_details` varchar(45) DEFAULT NULL, PRIMARY KEY (`agent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `agent_reservation`; CREATE TABLE `agent_reservation` ( `agent_reservation_id` char(8) NOT NULL, `agent_id` char(8) NOT NULL, `total_guest_count` int(11) DEFAULT NULL, `agent_reservation_made_date` varchar(45) DEFAULT NULL, PRIMARY KEY (`agent_reservation_id`), KEY `fk_agent_reservation_agents1_idx` (`agent_id`), CONSTRAINT `fk_agent_reservation_agents1` FOREIGN KEY (`agent_id`) REFERENCES `agents` (`agent_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
12
REKAYASA PERANGKAT LUNAK DROP TABLE IF EXISTS `booking_status`; CREATE TABLE `booking_status` ( `booking_status_code` char(8) NOT NULL, `booking_status_desc` varchar(45) DEFAULT NULL, PRIMARY KEY (`booking_status_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `calender`; CREATE TABLE `calender` ( `day_date` date NOT NULL, `day_number` varchar(45) DEFAULT NULL, `business_day_YN` varchar(45) DEFAULT NULL, PRIMARY KEY (`day_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `city_code`; CREATE TABLE `city_code` ( `city_code` char(8) NOT NULL, `city_name` varchar(45) DEFAULT NULL, PRIMARY KEY (`city_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `guets`; CREATE TABLE `guets` ( `guest_number` char(8) NOT NULL, `guest_details` varchar(45) DEFAULT NULL, PRIMARY KEY (`guest_number`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `hotel_chains`; CREATE TABLE `hotel_chains` ( `hotel_chain_code` char(8) NOT NULL, `hotel_chain_name` varchar(45) DEFAULT NULL, PRIMARY KEY (`hotel_chain_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `hotel_characteristic`; CREATE TABLE `hotel_characteristic` ( `characteristic_code` char(8) NOT NULL, `characteristic_code_desc` varchar(45) DEFAULT NULL, PRIMARY KEY (`characteristic_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `room_types`; CREATE TABLE `room_types` ( `room_type_code` char(8) NOT NULL, `room_standard_rate` varchar(45) DEFAULT NULL, `room_type_description` varchar(45) DEFAULT NULL, PRIMARY KEY (`room_type_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `star_ratings`; CREATE TABLE `star_ratings` ( `star_rating_code` char(8) NOT NULL, `star_rating_value` varchar(45) DEFAULT NULL, PRIMARY KEY (`star_rating_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `hotels`; CREATE TABLE `hotels` ( `hotel_id` char(8) NOT NULL,
13
REKAYASA PERANGKAT LUNAK `hotel_name` varchar(45) DEFAULT NULL, `hotel_email` varchar(45) DEFAULT NULL, `hotel_address` varchar(45) DEFAULT NULL, `hotel_postalcode` varchar(45) DEFAULT NULL, `hotel_url` varchar(45) DEFAULT NULL, `other_hotel_details` varchar(45) DEFAULT NULL, `star_ratings_star_rating_code` char(8) NOT NULL, `country_code_country_code` char(8) NOT NULL, `hotel_chains_hotel_chain_code` char(8) NOT NULL, PRIMARY KEY (`hotel_id`), KEY `fk_hotels_star_ratings1_idx` (`star_ratings_star_rating_code`), KEY `fk_hotels_country_code1_idx` (`country_code_country_code`), KEY `fk_hotels_hotel_chains1_idx` (`hotel_chains_hotel_chain_code`), CONSTRAINT `fk_hotels_country_code1` FOREIGN KEY (`country_code_country_code`) REFERENCES `city_code` (`city_code`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_hotels_hotel_chains1` FOREIGN KEY (`hotel_chains_hotel_chain_code`) REFERENCES `hotel_chains` (`hotel_chain_code`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_hotels_star_ratings1` FOREIGN KEY (`star_ratings_star_rating_code`) REFERENCES `star_ratings` (`star_rating_code`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `spesific_hotel_char`; CREATE TABLE `spesific_hotel_char` ( `character_code` char(8) NOT NULL, `hotel_id` char(8) NOT NULL, KEY `fk_spesific_hotel_char_hotel_characteristic_idx` (`character_code`), KEY `fk_spesific_hotel_char_hotels1_idx` (`hotel_id`), CONSTRAINT `fk_spesific_hotel_char_hotels1` FOREIGN KEY (`hotel_id`) REFERENCES `hotels` (`hotel_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_spesific_hotel_char_hotel_characteristic` FOREIGN KEY (`character_code`) REFERENCES `hotel_characteristic` (`characteristic_code`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `rooms`; CREATE TABLE `rooms` ( `room_number` char(8) NOT NULL, `hotels_hotel_id` char(8) NOT NULL, `room_type_code` char(8) NOT NULL, `room_actual_rate` varchar(45) DEFAULT NULL, `smoking_room_YN` varchar(45) DEFAULT NULL, `lantai` varchar(2) DEFAULT NULL, PRIMARY KEY (`room_number`,`hotels_hotel_id`), KEY `fk_rooms_hotels1_idx` (`hotels_hotel_id`), KEY `fk_rooms_room_types1_idx` (`room_type_code`), CONSTRAINT `fk_rooms_hotels1` FOREIGN KEY (`hotels_hotel_id`) REFERENCES `hotels` (`hotel_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_rooms_room_types1` FOREIGN KEY (`room_type_code`) REFERENCES `room_types` (`room_type_code`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `bookings`; CREATE TABLE `bookings` ( `booking_id` char(8) NOT NULL,
14
REKAYASA PERANGKAT LUNAK `agent_reservation_id` char(8) NOT NULL, `booking_status_code` char(8) NOT NULL, `hotel_id` char(8) NOT NULL, `room_number` char(8) NOT NULL, `guest_number` char(8) NOT NULL, `date_from` datetime DEFAULT NULL, `date_to` datetime DEFAULT NULL, PRIMARY KEY (`booking_id`), KEY `fk_bookings_guets1_idx` (`guest_number`), KEY `fk_bookings_agent_reservation1_idx` (`agent_reservation_id`), KEY `fk_bookings_booking_status1_idx` (`booking_status_code`), KEY `fk_bookings_rooms1_idx` (`room_number`,`hotel_id`), CONSTRAINT `fk_bookings_agent_reservation1` FOREIGN KEY (`agent_reservation_id`) REFERENCES `agent_reservation` (`agent_reservation_id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_bookings_booking_status1` FOREIGN KEY (`booking_status_code`) REFERENCES `booking_status` (`booking_status_code`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_bookings_guets1` FOREIGN KEY (`guest_number`) REFERENCES `guets` (`guest_number`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_bookings_rooms1` FOREIGN KEY (`room_number`, `hotel_id`) REFERENCES `rooms` (`room_number`, `hotels_hotel_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `daily_room_rates`; CREATE TABLE `daily_room_rates` ( `hotel_id` char(8) NOT NULL, `room_number` char(8) NOT NULL, `day_date` date NOT NULL, `daily_room_rate_offered` int(11) DEFAULT NULL, `daily_room_rate_accepted` varchar(45) DEFAULT NULL, KEY `fk_daily_room_rates_Calender1_idx` (`day_date`), KEY `fk_daily_room_rates_rooms1_idx` (`room_number`,`hotel_id`), CONSTRAINT `fk_daily_room_rates_Calender1` FOREIGN KEY (`day_date`) REFERENCES `calender` (`day_date`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_daily_room_rates_rooms1` FOREIGN KEY (`room_number`, `hotel_id`) REFERENCES `rooms` (`room_number`, `hotels_hotel_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `room_available`; CREATE TABLE `room_available` ( `hotel_id` char(8) NOT NULL, `day_date` date NOT NULL, `room_type_code` char(8) NOT NULL, `room_available_count` int(11) DEFAULT NULL, KEY `fk_room_available_room_types1_idx` (`room_type_code`), KEY `fk_room_available_Calender1_idx` (`day_date`), KEY `fk_room_available_hotels1_idx` (`hotel_id`), CONSTRAINT `fk_room_available_Calender1` FOREIGN KEY (`day_date`) REFERENCES `calender` (`day_date`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_room_available_hotels1` FOREIGN KEY (`hotel_id`) REFERENCES `hotels` (`hotel_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_room_available_room_types1` FOREIGN KEY (`room_type_code`) REFERENCES `room_types` (`room_type_code`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
15
REKAYASA PERANGKAT LUNAK
7. Design Object Oriented 7.1 Activity Diagram 7.1.1
Activity Daftar
Gambar 9.
Activity Diagram Daftar
16
REKAYASA PERANGKAT LUNAK 7.1.2
Activity Login
Gambar 10.
Activity Diagram Login
17
REKAYASA PERANGKAT LUNAK 7.1.3
Activity Cek Kamar
Gambar 11.
Activity Diagram Cek Kamar
18
REKAYASA PERANGKAT LUNAK 7.1.4
Activity Pesan Kamar
Gambar 12.
Activity Diagram Pesan Kamar
19
REKAYASA PERANGKAT LUNAK 7.1.5
Activity Pembayaran
Gambar 13.
Activity Diagram Pembayaran
20
REKAYASA PERANGKAT LUNAK
7.2 Use Case Diagram 7.2.1
Use Case Sistem Hotel
Gambar 14.
Use Case Sistem Hotel
7.3 Class Diagram 7.3.1
Class Sistem Integrasi Agen Hotel
Gambar 15.
Class Sistem Informasi Agen Hotel
21
REKAYASA PERANGKAT LUNAK
7.4 Sequence Diagram 7.4.1
Sequence Diagram Mengelola Data Hotel
Gambar 16.
Sequence Diagram mengelola data hotel
22
REKAYASA PERANGKAT LUNAK 7.4.2
Sequence Diagram Mengelola Data Customer
Gambar 17.
Sequence Diagram Mengelola Data Customer
23
REKAYASA PERANGKAT LUNAK 7.4.3
Sequence Diagram Pemesanan Hotel
Gambar 18.
Sequence diagram pemesanan hotel
24
REKAYASA PERANGKAT LUNAK
8. Implementasi Design User Interface 8.1 Design User Interface Hotel 8.1.1
Form Hotel
Gambar 19.
Form Hotel
25
REKAYASA PERANGKAT LUNAK 8.1.2
Form Hotel Chain
Gambar 20.
8.1.3
Form Hotel Chain
Form City
Gambar 21.
Form City
26
REKAYASA PERANGKAT LUNAK 8.1.4
Form Calendar
Gambar 22.
8.1.5
Form Calendar
Form Tipe Kamar
Gambar 23.
Form Tipe Kamar
27
REKAYASA PERANGKAT LUNAK 8.1.6
Form Tarif Kamar Harian
Gambar 24.
8.1.7
Form Tarif Kamar Harian
Form Room Available
Gambar 25.
Form Room Available
28
REKAYASA PERANGKAT LUNAK 8.1.8
Form Kamar
Gambar 26.
8.1.9
Form Kamar
Form Tempat Wisata
Gambar 27.
Form Tempat Wisata
29
REKAYASA PERANGKAT LUNAK
8.2 Design User Interface Agency 8.2.1
Halaman Utama
Gambar 28.
Halaman Utama
30
REKAYASA PERANGKAT LUNAK 8.2.2
Form Daftar
Gambar 29.
Form Daftar
31
REKAYASA PERANGKAT LUNAK 8.2.3
Form Login
Gambar 30.
Form Login
32
REKAYASA PERANGKAT LUNAK 8.2.4
Form Profil Member
Gambar 31.
Halaman Profil Member
33
REKAYASA PERANGKAT LUNAK 8.2.5
Form Cari Hotel
Gambar 32.
Form Cari Hotel
34
REKAYASA PERANGKAT LUNAK 8.2.6
Halaman Hasil Pencarian Hotel
Gambar 33.
Halaman Hasil Pencarian Hotel
35
REKAYASA PERANGKAT LUNAK 8.2.7
List Tipe Kamar
Gambar 34.
Halaman List Tipe Kamar
36
REKAYASA PERANGKAT LUNAK 8.2.8
Form Booking
Gambar 35.
Form Booking
37
REKAYASA PERANGKAT LUNAK 8.2.9
Halaman sukses booking
Gambar 36.
Halaman Sukses Booking
38
REKAYASA PERANGKAT LUNAK
8.3 Desain Tampilan Bank 8.3.1
Form Login
Gambar 37.
8.3.2
Form Login Bank
Form Profil Nasabah
Gambar 38.
Form Profil Nasabah
39
REKAYASA PERANGKAT LUNAK 8.3.3
Form Transfer
Gambar 39.
Transfer 1
Gambar 40.
Transfer 2
Gambar 41.
Transfer 3
40
REKAYASA PERANGKAT LUNAK 8.3.4
Form Transaksi
Gambar 42.
Form Transaksi
41
