ABSTRACT
This research work is focused on the development of a transaction processing system for music and event management using Raffia City Heritage band as a case study. The problems necessitated this study include: manual method of processing business transactions is still applicable in existing system, poor record keeping of transaction records, missing transaction records due to paper based system for recording transactions and delay in the retrieval of transaction information reports. The objectives of the study include to design a database application that can be used to capture transaction processing information for music and event management, to create a system that will process the captured information and provide relevant output about the status of the transaction, to implement a system that can be used to easily retrieve needed report about business transactions. The software development methodology used is Object Oriented Analysis and Design Methodology (OOADM). The programming language used is PHP (pHp Hypertext pre-processor) and the database used is MySql. It was concluded that it is possible to implement a transaction processing system for music and event management. The system facilitates the proper storage/retrieval of music and event management information and it serves as a management information system to guide the decision of the company. It was recommended that more research should be encouraged in the area of transaction processing system for music and event management, and the management of the company should replace or complement the manual system of managing music and event management information with a computerized system.
TABLE OF CONTENTS
Title Page – – – – – – – – i
Certification – – – – – – – – – ii
Approval – – – – – – – – – iii
Dedication – – – – – – – – iv
Acknowledgment – – – – – – – – v
Abstract – – – – – – – – vi
Table of Contents – – – – – – – – vii-ix
List of Tables – – – – – – – – x
List of Figures – – – – – – – – xi
CHAPTER ONE: INTRODUCTION
1.0 Introduction – – – – – – – 1
1.1 Background of the Study – – – – – – 1-2
1.2 Statement of Problem – – – – – 2-3
1.3 Aim and Objectives of the Study – – – 3
1.4 Significance of the Study – – – – – – 3-4
1.5 Scope of the Study – – – – – – – 4
1.6 Organization of the Research – — – – – 4
1.7 Definition of Terms – – – – – – 5
CHAPTER TWO: LITERATURE REVIEW
2.0 Introduction – – – – – – – 6
2.1 Theoretical Background – – – – – – 6-8
2.2 Concept of Transaction Processing – – – – 9
2.2.1 Transaction Processing System Features – – – 9-10
2.2.2 Types of Transaction Processing – – – – – 10
2.3 Databases for Transaction Processing – – – – 10-11
2.4 Transaction Processing System Data Recovery Process – 12-13
2.5 Ways to Improve Event Management – – – – 13-15
2.6 Event Planning and Management for Rental Industry – – 15-20
CHAPTER THREE: SYSTEM ANALYSIS AND DESIGN
- Introduction – – – – – – – 21
3.1 Research Methodology – – – – – 21
3.2 Analysis of the Existing System – – – – 21
3.2.1 Disadvantages of the Existing System – – – 22
3.3 Analysis of the Proposed System – – – – 22
3.2.3.1 Advantages of the Proposed system – – – 22-23
3.4 System Design – – – – – – – 23
3.4.1 Input layout – – – – – – – 24
3.4.2 Output Layout – – 25
3.4.3 Algorithm – – 25
3.4.4 Program Flowchart – – 26-28
3.4.5 Database Design – – – – – 29
3.4.6 System Architecture – – – – – 29-30
3.4.7 Use Case Diagram/Class Diagram- – – – – 31-32
CHAPTER FOUR: SYSTEM IMPLEMENTATION AND DOCUMENTATION
4.0 Introduction – – – – – – 33
4.1 System Design Diagram – – – – – 33
4.2 Analysis of Modules – – – – 33-34
4.3 Choice of Programming Language – – 34
4.4 Programming Environment – – – – 34
4.4.1 Hardware Requirements – – – – – 34
4.4.2 Software Requirements – – – – – 34-35
4.5 Implementation – – – – – – 35
CHAPTER FIVE: SUMMARY, CONCLUSION AND RECOMMENDATIONS
5.0 Introduction – – – – – – – – 36
5.1 Constraints of the Study – – – – – – 36
5.2 Summary – – – – – 36
5.3 Conclusion – – – – – – 37
5.4 Recommendations – – – – – – 37
References – – – – – – 38
Appendix A (Source Code)- – – – – – 39-45
Appendix B (Output) – – – 46-49
LIST OF TABLES
Page Number
Table 3.1: Output Layout – – – – – – 24
Table 3.2: Database design – – – – – 30
LIST OF FIGURES
Figure 2.1: Login page – – – – – – 8
Figure 2: Main Menu flowchart – – – – – 26
Figure 3: Booking flowchart – – – – – 27
Figure 4: Administrator flowchart – – – – 28
Figure 5: Architecture of the System – – – – 30
Figure 6: Use case diagram – – – – – 31
Figure 7: Class diagram – – – – – – 32
Figure 8: System Design Diagram – – – – 33
BIBLIOGRAPHY
CHAPTER ONE
INTRODUCTION
1.0 Introduction
This chapter presents the general introduction to the study on transaction processing system for music and event management. It presents the background of the study, statement of the problem, aim and objectives of the study, significance of the study, scope of the study, organization of the research and definition of terms.
The growth in the transaction processing industry portends good things for small businesses. As is the case with most sound business decisions, managers should acquire proper education and knowledge about transaction processing before committing to it. It is, after all, just a new way to manage commercial transactions.
1.1 Background of the Study
Transaction processing is a term that refers to the adding, changing, deleting, or looking up of a record in a data file or database by entering the data at a terminal or workstation. Most transaction processing systems also include a method of ensuring that all the information entered as a transaction is simultaneously saved. When a large number of transactions are taken and then stored to be dealt with at a later time, the process is known as batch processing. Different examples of transaction processing include automated teller machines, credit card authorizations, online bill payments, self-checkout stations at grocery stores, the trading of stocks over the Internet, and various other forms of electronic commerce.At the center of most commercial interactions is a transaction so, every business has to deal with its commercial transactions in some form. How a company decides to manage these transactions can be an important factor in its success. As a business grows, the number of transactions it must manage usually grows as well. Careful planning must be done in order to ensure that transaction management does not become too complex. Transaction processing is a tool that can help growing businesses deal with their increasing number of transactions.
Every event management organization need to keep proper records of transaction and process them. Achieving this manually is possible but also time consuming. To facilitate proper record keeping and processing of transaction, an automated system is needed. Automating the records for music and event management will guarantee efficient management of the business organization. Reports about music and events to be conducted can be easily retrieved. It is in view of the need to implement a transaction processing system for event management that necessitated this study.
1.2 Statement of the Problem
Many business enterprises still depend on the manual system of operations for recording business transactions, this system is ineffective compared to computerized systems that offer the benefits of high level of storage, quick processing and easy retrieval of needed information. The following problems were identified:
- Manual method of processing business transactions is still applicable in existing system.
- Poor record keeping of transaction records.
- Missing transaction records due to paper based system for recording transactions.
- Delay in the retrieval of transaction information reports.
- Complaints by clients due to lack of proper record keeping.
- Absence of an automated system for recording and processing music and event management information.
