Design and Implementation of an Online Airline Booking System Using Php, Mysql, Java Script and Cascading Style Sheets Case Study: Air Tanzama Corporation, Entebbe Branch the Republic of Ugan

Subscribe to access this work and thousands more

Table of Content

DECLARATION.

APPROVAL

ACKNOWLEDGEMENT iii

ABSTRACT viii

CHAPTER ONE 1

1.0 Introduction 1

1. 1 Background ofthe study i

1.2 Statement ofthe problem 2

1.3.1 General objectives 3

1.3.2 Specific objectives 3

1.4 Scope ofthe study 3

1.5 Significance ofthe study 4

1.6 Conceptual framework 5

CHAPTER TWO 6

Literature review 6

2.0 Introduction 6

2.1 Review ofthe related literature 6

2.2 Database 8

2.2.1 Database system 9

2.2.2 Database Management System (DBMS) 9

2.3 Recent development 11

2.3.1. Internet Booking Engine (IBE) use videcom to make online reservation .11

2.4 Problem area 12

2.5 Application area 12

2.6 Conclusion 13

CHAPTER THREE 14

Methodology 14

3.0. Introduction 14

3.1. Organization unit to be studied 14

3.2. Study population 14

3.3 Sample size 14

3.4. Data collection procedures! tools 15

iv

3.4.1. Primary methods .15

3.4.2. Secondary method 16

3.5 Data analysis and analysis of user requirement 17

3.6 Development methodology 17

3.7. Design technique and tools 18

3.8. Development tools for the system 19

3.8.1 Other tools which were used are 21

3.9. Information system plan 22

3.9.1. Feasibility analysis 22

3.9.2. Project plan and schedule 22

3.9.3. Risk assessment 23

3.10. Conclusion 24

CHAPTER FOUR 25

Analysis and Design of the New System 25

4.0 Introduction 25

4.1 Requirements analysis and specification 25

4.1.1 Functional requirements 25

4.1.2 Non-functional requirements 26

4.2 System designing 28

4.2.1 Database design 28

4.2.1.1 Logical Design 28

4.2.1.2 Entity relation diagram of a new system 28

4.2.1.3 Database entities 29

4.2.1.4 Entity relationships 30

4.2.1.5 Entity relationship table 30

4.2.1.6 Entity relationship diagram 31

4.2.1.2 Physical design 32

4.2.1.2.1 Customer table 32

4.2.1.2.2 Offer table 34

4.2.1.2.3 User table 35

4.2.1.2.4 Flights table 35

4.2.2 Interface design 37

4.2.2.1 Customer home/main pageS 37

4.2.2.2 Booking page 38

4.2.2.3 Booking flight-personal details 39

4.2.2.4 Confirmation page 40

4.2.2.5 Flight details page~ 41

V

4.2.2.6 Administrator pages: .42

4.2.2.7 Configuration page 43

4.2.2.8 Customer maintenance page 45

4.3 System testing: - Testing the developed system 46

4.4 System implementation: 47

4.5 System Conversion 47

CHAPTER FIVE 48

5.1 Introduction 48

5.2 Lessons learnt 48

5.3 Limitation of the study 48

5.4 Recommendations 49

5.5 Conclusion 49

APPENDICES 5o

APPENDIX I: Guiding Questions for the staffs at booking office 50

APPENDIX II: Guiding Questions for Customers 51

APPENDIX III: Code for the customer home page 52

APPENDIX IV: Code for the booking page 58

APPENDIX V: Code for the booking flight/personal detail page 63

APPENDIX VI: Project Cost 70

APENDIX VII: Project Plan and Schedule 71

APENDIX VIII : References 72

ABSTRACT This project aimed at the design and implementation of online airline booking; a system to aid in the management and operation of the customer service. Online airline booking system is one of the essential applications of E-commerce. With the development of internet and security technology, more and more people begin to consume online, which is more convenient and personal than traditional way. Online airline booking systems which are not carefully designed basing on good security practices may lead to data loss, misplacement, inconsistencies and redundancies. Methods that were used to gather information about the current system includes; unstructured interviews, document analysis and observation. It gives detailed review of the selected methods instruments of data analysis and presentations that were used when analyzing and designing ofthe new system. The method applied attempted to establish and analyze the status of the problem, appraising it effectiveness where problems existed, to try and find solutions. The study was carried out at ATC, Entebbe branch as a case study. The system was written in PHP/MySQL and designed with user friendly interface that would ensure ease of use and avoid errors and other shortfalls that arise with the classic file system. The literature review elaborates and gives a detailed perspective of online booking system, dynamic websites and database as viewed by different authors and researchers, effects and benefits of databases and data management system.

Subscribe to access this work and thousands more
Overall Rating

0

5 Star
(0)
4 Star
(0)
3 Star
(0)
2 Star
(0)
1 Star
(0)
APA

ELIAS, R & JOHN, F (2022). Design and Implementation of an Online Airline Booking System Using Php, Mysql, Java Script and Cascading Style Sheets Case Study: Air Tanzama Corporation, Entebbe Branch the Republic of Ugan. Afribary. Retrieved from https://afribary.com/works/design-and-implementation-of-an-online-airline-booking-system-using-php-mysql-java-script-and-cascading-style-sheets-case-study-air-tanzama-corporation-entebbe-branch-the-republic-of-uganda

MLA 8th

ELIAS, RONALD and FREDRICK JOHN "Design and Implementation of an Online Airline Booking System Using Php, Mysql, Java Script and Cascading Style Sheets Case Study: Air Tanzama Corporation, Entebbe Branch the Republic of Ugan" Afribary. Afribary, 20 Aug. 2022, https://afribary.com/works/design-and-implementation-of-an-online-airline-booking-system-using-php-mysql-java-script-and-cascading-style-sheets-case-study-air-tanzama-corporation-entebbe-branch-the-republic-of-uganda. Accessed 04 Dec. 2022.

MLA7

ELIAS, RONALD, FREDRICK JOHN . "Design and Implementation of an Online Airline Booking System Using Php, Mysql, Java Script and Cascading Style Sheets Case Study: Air Tanzama Corporation, Entebbe Branch the Republic of Ugan". Afribary, Afribary, 20 Aug. 2022. Web. 04 Dec. 2022. < https://afribary.com/works/design-and-implementation-of-an-online-airline-booking-system-using-php-mysql-java-script-and-cascading-style-sheets-case-study-air-tanzama-corporation-entebbe-branch-the-republic-of-uganda >.

Chicago

ELIAS, RONALD and JOHN, FREDRICK . "Design and Implementation of an Online Airline Booking System Using Php, Mysql, Java Script and Cascading Style Sheets Case Study: Air Tanzama Corporation, Entebbe Branch the Republic of Ugan" Afribary (2022). Accessed December 04, 2022. https://afribary.com/works/design-and-implementation-of-an-online-airline-booking-system-using-php-mysql-java-script-and-cascading-style-sheets-case-study-air-tanzama-corporation-entebbe-branch-the-republic-of-uganda