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

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