Rekayasa Perangkat Lunak - Sistem Terintegrasi Antar 2 Perusahaan

REKAYASA PERANGKAT LUNAK

i

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


1

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 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

6.2 Rancangan EER ................................................................................................ 12

6.2.1 Deskripsi Tabel ...................................................................................... 12

7. Design Object Oriented ................................................................................................ 16

7.1 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

7.2 Use Case Diagram ............................................................................................ 21

7.2.1 Use Case Sistem Hotel .......................................................................... 21

7.3 Class Diagram ................................................................................................... 21

7.3.1 Class Sistem Integrasi Agen Hotel ......................................................... 21

7.4 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

8. Implementasi Design User Interface ............................................................................ 25

8.1 Design User Interface Hotel ............................................................................... 25


2

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

8.2 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

8.3 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


3

Daftar Gambar

Gambar 1. Arsitektur Sistem ........................................................................................................ 6

Gambar 2. DFD Level Konteks ...................................................................................................... 7

Gambar 3. DFD Level 1................................................................................................................. 8

Gambar 4. DFD Level 2 Proses Upload Data Hotel ........................................................................ 9

Gambar 5. DFD Level 2 Proses Pengecekan Kamar Hotel .............................................................. 9

Gambar 6. DFD Level 2 Proses Pemesanan Hotel ....................................................................... 10

Gambar 7. DFD Level 2 Proses Pembayaran Hotel ...................................................................... 11

Gambar 8. Rancangan EER ......................................................................................................... 12

Gambar 9. Activity Diagram Daftar ............................................................................................ 16

Gambar 10. Activity Diagram Login .............................................................................................. 17

Gambar 11. Activity Diagram Cek Kamar ...................................................................................... 18

Gambar 12. Activity Diagram Pesan Kamar .................................................................................. 19

Gambar 13. Activity Diagram Pembayaran ................................................................................... 20

Gambar 14. Use Case Sistem Hotel .............................................................................................. 21

Gambar 15. Class Sistem Informasi Agen Hotel ............................................................................ 21

Gambar 16. Sequence Diagram mengelola data hotel .................................................................. 22

Gambar 17. Sequence Diagram Mengelola Data Customer .......................................................... 23

Gambar 18. Sequence diagram pemesanan hotel ........................................................................ 24

Gambar 19. Form Hotel ............................................................................................................... 25

Gambar 20. Form Hotel Chain...................................................................................................... 26

Gambar 21. Form City .................................................................................................................. 26

Gambar 22. Form Calendar .......................................................................................................... 27

Gambar 23. Form Tipe Kamar ...................................................................................................... 27

Gambar 24. Form Tarif Kamar Harian........................................................................................... 28

Gambar 25. Form Room Available ............................................................................................... 28

Gambar 26. Form Kamar .............................................................................................................. 29

Gambar 27. Form Tempat Wisata ................................................................................................ 29

Gambar 28. Halaman Utama........................................................................................................ 30

Gambar 29. Form Daftar .............................................................................................................. 31

Gambar 30. Form Login ............................................................................................................... 32

Gambar 31. Halaman Profil Member ........................................................................................... 33

Gambar 32. Form Cari Hotel ........................................................................................................ 34

Gambar 33. Halaman Hasil Pencarian Hotel ................................................................................. 35

Gambar 34. Halaman List Tipe Kamar .......................................................................................... 36

Gambar 35. Form Booking ........................................................................................................... 37

Gambar 36. Halaman Sukses Booking .......................................................................................... 38

Gambar 37. Form Login Bank ....................................................................................................... 39

Gambar 38. Form Profil Nasabah ................................................................................................. 39

Gambar 39. Transfer 1 ................................................................................................................. 40

Gambar 40. Transfer 2 ................................................................................................................. 40

Gambar 41. Transfer 3 ................................................................................................................. 40

Gambar 42. Form Transaksi ......................................................................................................... 41


4

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.


5

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


6

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


7

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. DFD Level Konteks

6.1.2 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.


8

Gambar 3. DFD Level 1

6.1.3 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.


9

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


10

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


11

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


12

6.2 Rancangan EER

Gambar 8. Rancangan EER

6.2.1 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;


13

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,


14

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,


15

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;


16

7. Design Object Oriented

7.1 Activity Diagram

7.1.1 Activity Daftar

Gambar 9. Activity Diagram Daftar


17

7.1.2 Activity Login

Gambar 10. Activity Diagram Login


18

7.1.3 Activity Cek Kamar

Gambar 11. Activity Diagram Cek Kamar


19

7.1.4 Activity Pesan Kamar

Gambar 12. Activity Diagram Pesan Kamar


20

7.1.5 Activity Pembayaran

Gambar 13. Activity Diagram Pembayaran


21

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


22

7.4 Sequence Diagram

7.4.1 Sequence Diagram Mengelola Data Hotel

Gambar 16. Sequence Diagram mengelola data hotel


23

7.4.2 Sequence Diagram Mengelola Data Customer

Gambar 17. Sequence Diagram Mengelola Data Customer


24

7.4.3 Sequence Diagram Pemesanan Hotel

Gambar 18. Sequence diagram pemesanan hotel


25

8. Implementasi Design User Interface

8.1 Design User Interface Hotel

8.1.1 Form Hotel

Gambar 19. Form Hotel


26

8.1.2 Form Hotel Chain

Gambar 20. Form Hotel Chain

8.1.3 Form City

Gambar 21. Form City


27

8.1.4 Form Calendar

Gambar 22. Form Calendar

8.1.5 Form Tipe Kamar

Gambar 23. Form Tipe Kamar


28

8.1.6 Form Tarif Kamar Harian

Gambar 24. Form Tarif Kamar Harian

8.1.7 Form Room Available

Gambar 25. Form Room Available


29

8.1.8 Form Kamar

Gambar 26. Form Kamar

8.1.9 Form Tempat Wisata

Gambar 27. Form Tempat Wisata


30

8.2 Design User Interface Agency

8.2.1 Halaman Utama

Gambar 28. Halaman Utama


31

8.2.2 Form Daftar

Gambar 29. Form Daftar


32

8.2.3 Form Login

Gambar 30. Form Login


33

8.2.4 Form Profil Member

Gambar 31. Halaman Profil Member


34

8.2.5 Form Cari Hotel

Gambar 32. Form Cari Hotel


35

8.2.6 Halaman Hasil Pencarian Hotel

Gambar 33. Halaman Hasil Pencarian Hotel


36

8.2.7 List Tipe Kamar

Gambar 34. Halaman List Tipe Kamar


37

8.2.8 Form Booking

Gambar 35. Form Booking


38

8.2.9 Halaman sukses booking

Gambar 36. Halaman Sukses Booking


39

8.3 Desain Tampilan Bank

8.3.1 Form Login

Gambar 37. Form Login Bank

8.3.2 Form Profil Nasabah

Gambar 38. Form Profil Nasabah


40

8.3.3 Form Transfer

Gambar 39. Transfer 1




41

8.3.4 Form Transaksi

Gambar 42. Form Transaksi

Rekayasa Perangkat Lunak - Sistem Terintegrasi Antar 2 Perusahaan

Documents