Design and implementation of a computerized guest information tracking systemINTRODUCTION 1.1 BACKGROUND OF STUDY. Information technology is an essential tool to guest tracking. The faster and more effectively it works, the safer our business management is. Information system (IS) refers to a system that comprises of persons, data records and activities that process data and information in an organization, and it includes the organization‟s manual and automated processes. In a narrow sense, the term information system refers to the specific application software that is used to store data records in a computer system and automates some of the information-processing activities of the organization. The term information technology has ballooned to encompass many aspects of computing and technology, and the term has become very recognizable. The information technology umbrella can be quite large, covering many fields. IT professionals perform a variety of duties that range from installing applications to designing complex computer networks and information database. Since the first wave of computerization in the 1970‟s, the implementation of information technology within policing has been questioned and often met with resistance. The development of an information technology strategy must be viewed in the context of increasing expectations and pressure for reform within organizations. 2 The business environment in which banks operate is changing; increased demands for efficiency has led to information technology being recognized as a valuable and innovative addition to guest tracking system. Over the last decade, computer and telecommunication technologies have developed at an extraordinary rate. Increased computer power, advances in data transmission, attractive and user-friendly graphic interfaces present bank with unprecedented capacity to collect, store, analyze and share data with stakeholders inside and outside of bank. Historically, the innovation of information systems has served as the catalyst for dramatic changes in the organization work and has presented both opportunities and challenges to operators. Some banks have made tremendous efforts in creating databases for guest information system for security purposes. 1.2 STATEMENT OF PROBLEM Keeping record of visitors in a bank has been a big task for the management. Often the identity of the guest is forgotten as soon as he/she leaves the bank. This is a big security risk as there is need to maintain an automated record of daily visitors to the bank in case security issues arise. 3 1.3 PURPOSE OF STUDY The purpose of this study is to design software that will serve as an electronic register to keep record of daily guest to the bank. The software will maintain a centralized database system for the purpose of information sharing. 1.4 SIGNIFICANCE OF THE STUDY The software developed will be beneficial to the bank management in so many ways: 1. Maintain a centralized database for Guest records 2. Retrieve previous information on guest from the system easily using serial query language 3. Have a good surveillance on the guest information for security purposes 4. Know the number of guest they receive on daily basis 5. Track the frequency of a guest visitation to the bank 1.5 OBJECTIVE OF STUDY The purpose of this research work is to develop a system that should be able to achieve the following: 1. To provide an electronic register to keep record of guest visit to the bank 2. To produce a system where information and output report will be produced much faster, more accurately and more detailed. 4 3. Keeping record of total number of guest coming to the bank on daily basis. 4. Keep track of old guest in case of any security breach. 5. Provide password to prevent unauthorized users from accessing and manipulating information. 1.6 SCOPE OF THE STUDY This research project covers only records on the banks managers guest and some other management staff, as it will be difficult to maintain guest record on every staff of the bank. 1.7 CONSTRAINS AND LIMITATION Due to time constraint and limited resources, the use of biometric could not be incorporated into the work for authentic identification of guest. 1.8 DEFINTION OF TERMS ARRIVAL FILE: This is master file consisting of the guest name, companies name and address, state, country, nationality, profession etc. which also include the mode of payment to be used by the guest. DATABASE: This is the collection of related data/information GUEST: This guest are used in the contest of the work refers to individual, companies or corporate bodies that visited the bank 5 SOFTWARE: This is the logically written instruction that control the

Project Abstract

Information technology is an essential tool for guest tracking, with information systems playing a crucial role in storing and processing data. The implementation of information technology within organizations has been met with resistance, but it is increasingly recognized as valuable for enhancing efficiency. This research project focuses on the design and implementation of a computerized guest information tracking system for banks. The system aims to maintain a centralized database for guest records, facilitate easy retrieval of information, enhance security surveillance, track visitor frequency, and prevent unauthorized access. The project scope covers guest records for bank managers and staff, with limitations including the lack of biometric authentication due to time and resource constraints. Key terms include arrival file, database, guest, and software.

Project Overview

<p> </p><div><b><p><b>INTRODUCTION</b></p><p><b>1.1 BACKGROUND OF STUDY.</b></p><p>Information technology is an essential tool to guest tracking. The faster and more effectively it works, the safer our business management is.</p><p>Information system (IS) refers to a system that comprises of persons, data records and activities that process data and information in an organization, and it includes the organization‟s manual and automated processes. In a narrow sense, the term information system refers to the specific application software that is used to store data records in a computer system and automates some of the information-processing activities of the organization.</p><p></p><p>The term information technology has ballooned to encompass many aspects of computing and technology, and the term has become very recognizable. The information technology umbrella can be quite large, covering many fields. IT professionals perform a variety of duties that range from installing applications to designing complex computer networks and information database.</p><p>Since the first wave of computerization in the 1970‟s, the implementation of information technology within policing has been questioned and often met with resistance. The development of an information technology strategy must be viewed in the context of increasing expectations and pressure for reform within organizations. 2</p><p>The business environment in which banks operate is changing; increased demands for efficiency has led to information technology being recognized as a valuable and innovative addition to guest tracking system.</p><p>Over the last decade, computer and telecommunication technologies have developed at an extraordinary rate. Increased computer power, advances in data transmission, attractive and user-friendly graphic interfaces present bank with unprecedented capacity to collect, store, analyze and share data with stakeholders inside and outside of bank.</p><p>Historically, the innovation of information systems has served as the catalyst for dramatic changes in the organization work and has presented both opportunities and challenges to operators.</p><p>Some banks have made tremendous efforts in creating databases for guest information system for security purposes.</p><p></p></b></div><b><div><p><b>1.2 STATEMENT OF PROBLEM</b></p><p>Keeping record of visitors in a bank has been a big task for the management. Often the identity of the guest is forgotten as soon as he/she leaves the bank. This is a big security risk as there is need to maintain an automated record of daily visitors to the bank in case security issues arise. 3</p><p><b>1.3 PURPOSE OF STUDY</b></p><p>The purpose of this study is to design software that will serve as an electronic register to keep record of daily guest to the bank. The software will maintain a centralized database system for the purpose of information sharing.</p><p><b>1.4 SIGNIFICANCE OF THE STUDY</b></p><p>The software developed will be beneficial to the bank management in so many ways:</p><p>1. Maintain a centralized database for Guest records</p><p></p><p>2. Retrieve previous information on guest from the system easily using serial query language</p><p>3. Have a good surveillance on the guest information for security purposes</p><p>4. Know the number of guest they receive on daily basis</p><p>5. Track the frequency of a guest visitation to the bank</p><p><b>1.5 OBJECTIVE OF STUDY</b></p><p>The purpose of this research work is to develop a system that should be able to achieve the following:</p><p>1. To provide an electronic register to keep record of guest visit to the bank</p><p>2. To produce a system where information and output report will be produced much faster, more accurately and more detailed.</p><p>4</p><p>3. Keeping record of total number of guest coming to the bank on daily basis.</p><p>4. Keep track of old guest in case of any security breach.</p><p>5. Provide password to prevent unauthorized users from accessing and manipulating information.</p><p><b>1.6 SCOPE OF THE STUDY</b></p><p>This research project covers only records on the banks managers guest and some other management staff, as it will be difficult to maintain guest record on every staff of the bank.</p><p><b>1.7 CONSTRAINS AND LIMITATION</b></p><p>Due to time constraint and limited resources, the use of biometric could not be incorporated into the work for authentic identification of guest.</p><p><b>1.8 DEFINTION OF TERMS</b></p><p>ARRIVAL FILE: This is master file consisting of the guest name, companies name and address, state, country, nationality, profession etc. which also include the mode of payment to be used by the guest.</p><p>DATABASE: This is the collection of related data/information</p><p>GUEST: This guest are used in the contest of the work refers to individual, companies or corporate bodies that visited the bank 5</p><p>SOFTWARE: This is the logically written instruction that control the</p><p></p></div><h3></h3></b><br> <br><p></p>