TABLE OF CONTENTS
CHAPTER ONE
Introduction and background
1.1 Introduction ........................................................................ 1
1.2 Background of the study ........................................................ 2
1.3 Problem statement ................................................................ 2
1.4 Reseat·ch questions ............................................................... 2
1.5 Main objective .................................................................... 3
. 1.5.1 Specific objectives ...................................... _. ..................... 3
1.6 Scope of the study ................................................................. 3
1.6.1 Geographical scope ............................................................. 3
1.6.2 Time scope ...................................................................... .4
1.7 Significance of the study ......................................................... 4
CHAPTER TWO
Literature review
2.1 Introduction ........................................................................... 5
2.2 Definition ............................................................................... 5
2.3 Types of record system ............................................................. 5
2.3.1 Manual rec01·d system ............................................................ 6
2.3.2 Computerized record system .................................................... 6
2.3.3 Main features of a database ..................................................... 7
2.4 Data base management systems ................................................... 8
2.4.1 Data base management system requirements ............................... 9
2.4.2 Roles &functions of a DBMS .................................................... 9
2.4.3 Examples of a database system ................................................. 1 0
2.5 Employee performance ............................................................. 10
2.5.1Comp sales Mgt syst& employee performance .............................. 10
2.6 Benefits of Using Comp Htl Mgt Syst ........................................... ll
2.6.1 Accuracy ............................................................................. 11
v
2.6.2 Speed ................................................................................ 11
2.6.3 Filling and retrieval ............................................................... 12
2.6.4 Internal controls .................................................................... 12
2. 7 Challenges Most Likely To RSK fro CMP sales &Sys ....................... 12
2. 7.1 Programming ....................................................................... 12
2. 7.2 System Maintainace ............................................................... 13
2.7.3 Fraud ................................................................................. 13
2.7.4 Legal & regularly issues .......................................................... 13
2.8 Summery .............................................................................. 13
CHAPTER THREE (METHODOLOGY)
3.1 Introduction ............................................................................. 14
3.2 Analysis of the system .................................................................... 15
3.2.1 Structured analysis ................................................................... 15
3.3 feasibility study ......................................................................... 16
3.3.1 Creating databases ................................................................... 16
3.3.2 Maintainace of databases .......................................................... 16
3.3.3 Requirement analysis ............................................................... 16
3.4 Data collection method ................................................................ 18
3.4.1 Questionnaire ........................................................................ 19
3.4.2 Interviews .............................................................................. 20
3.4.3 Existing information .................................................................. 20
3.3.4 Obseration ............................................................................... 20
3.5 Current system ............................................................................ 20
3.5 .1 Weakness of the current system ................................................... 21
3.5.2 Solutions to problems .................................................................. 21
3.5.3 Limitations .............................................................................. 21
3.6 Data flow diagram of the current system ........................................... 22
3. 7 Proposed Comp records Mgt Syst ................................................... 22
3.8 Controls for comp record Mgt Syst .................................................. 22
VI
3.9 Testing ................................................................................. 23
3.10 Conclusions ......................................................................... 23
CHAPTER FOUR
SYSTEMS ANALYSIS AND DESIGN
4.1 Systems Design ....................................................................... 24
4.1.1 Structured design ................................................................... 24
4.1.2 ERM ................................................................................. 24
4.2 Data Flow Diagram .......................................................................... 26
4.3 Tables ................................................................................... 27
4.4 Referential Integrity .................................................................. 29
4.4.1 Types of relationships ............................................................. 29
4.5 Context Level diagram ............................................................. 30
4.6 Queries ................................................................................. 30
4.6.1 Removal of an items from D/B ................................................. 31
4.6.2 Orders received by hotel ........................................................ 31
4.6.3 Clarence of an order .............................................................. 31
4.6.4 Price updates ....................................................................... 31
4.6.5Amt of item sold to particular customer ....................................... 31
4.6.6 Searching details of a particular customer ................................... 32
4.6. 7Expression builders ................................................................. 32
4.7 Forms ................................................................................... 32
4.7.1 Main menu Form ................................................................... 33
4.7.2 Supplier .............................................................................. 34
4.7.3 Employee registration form ...................................................... 35
4.7.4 Customer order form .............................................................. 36
VI!
CHAPTER FIVE
SYSTEM IMPLIMENTATION AND OPERATATION
5.1 Introduction ............................................................................. 38
5.2 Summery of the finding ............................................................... 38
5.3 Recommendations ...................................................................... 38
5.4 Limitations ............................................................................... 39
5.5 Conclusions .............................................................................. 39
Appendices ............................................................................. .47
References ................................................................................ 57
ABSTRACT The use of ICT offers great opp01iunities for improving the effectiveness and efficiency Of many businesses in the processes of caring out many transactions and in the processes disseminating information. Information and communication technologies can make great contributions to the improvement of business and the handling and management of information. This has made many companies that deal in a number of businesses to adopt ICT use. Unfortunately, few individuals or companies are willing to adopt to ICT because of ignorance and lack of adequate finances to start up computer systems. This is attributed to the huge sums of money that is needed to put up an information system making the adoption of information and communication technology in areas related to hotel industry far slower than other sectors like the banking sector. This study therefore assessed how the adoption of! CT in the hotel business can facilitate access, dissemination and enhance better storage, retrieval, update and management of information with maximum safety hence improving on the time needed to processes a particular piece of information. However the use of ICTS comes along with its own challenges different to particular cases which must be addressed if any benefits are to be realized. Lack of clear information systems, low knowledge about computer and poor financing of the department are the major set backs to the use of I CT .Information systems in Sports view Hotel is majorly Manuel. It also depends on people to transfer information from one place to another and from one office to another. Problems like delay in the flow of information, difficulty in allocating information are a common phenomenon as a result decisions can be made basing on inadequate and inaccurate information. This research therefore shows that a lot is to be done both b the government and the private sector in order to get maximum value out the adoption of!CT.
WULA, N (2022). Design and Implementation of a Database Management System Case Study: Sports View Hotel. Afribary. Retrieved from https://tracking.afribary.com/works/design-and-implementation-of-a-database-management-system-case-study-sports-view-hotel
WULA, NAND "Design and Implementation of a Database Management System Case Study: Sports View Hotel" Afribary. Afribary, 19 Jul. 2022, https://tracking.afribary.com/works/design-and-implementation-of-a-database-management-system-case-study-sports-view-hotel. Accessed 24 Nov. 2024.
WULA, NAND . "Design and Implementation of a Database Management System Case Study: Sports View Hotel". Afribary, Afribary, 19 Jul. 2022. Web. 24 Nov. 2024. < https://tracking.afribary.com/works/design-and-implementation-of-a-database-management-system-case-study-sports-view-hotel >.
WULA, NAND . "Design and Implementation of a Database Management System Case Study: Sports View Hotel" Afribary (2022). Accessed November 24, 2024. https://tracking.afribary.com/works/design-and-implementation-of-a-database-management-system-case-study-sports-view-hotel