DESIGN AND IMPLEMENTATION OF A COMPUTERIZED SEAPORT BILLING SYSTEM (A CASE STUDY OF NIGERIAN PORT AUTHORITY, ONNE, RIVERS STATE)
ABSTRACT: The Design and Implementation of Seaport billing system is an academic work which aims in developing a computerized system to maintain all the daily works of billing in the seaport. This project has many features which are generally not available in normal seaport management systems like facility of user login and a facility of admin login through which the admin can monitor the whole system. It also has facility of awarehouse where imported goods can be stored and monitored. It has also a facility where payment can be made and it is a computerized robust payment system. It also has the facility of showing all the report of bills that are paid and purchase. Overall this project of ours is being developed to help the warehouse management to maintain the Seaport in the best way possible and also reduce the human efforts. The Programming language used in developing this application software is Visual Basic.net 2012. It runs in Windows 98 to Latest windows 10. It also requires Microsoft access 2010 re-distribution to avoid errors.
TABLE OF CONTENTTitle Abstract Certificate Acknowledgement Table of Content CHAPTER ONE: INTRODUCTIONBackground of the Study Statement of ProblemsObjectives of the Study Significance of the Study Limitation of the Study Scope of the Study Assumption of the Study Definition of Terms CHAPTER TWO: LITERATURE REVIEW LIBRARY MANAGEMENT SYSTEM SOFTWARETYPES OF SOFTWAREDATABASE DESIGN AND MANAGEMENTCLASSIFICATION OF DATABASE2.3 FUNCTIONS OF INFORMATION SYSTEM2.3.1 Functions of an information system2.4 TYPES OF INFORMATION SYSTEMS2.4.1 Types of Information system2.5 MANAGEMENT INFORMATION SYSTEMCHAPTER THREE: METHODOLOGY AND ANALYSIS OF THE EXISTING SYSTEM3.1 GENERAL DESCRIPTION OF THE EXISTING SYSTEM3.2 FACT-FINDING METHODS USED3.2.1 Primary Source3.2.2 Secondary Source3.3 OBJECTIVES OF THE EXISTING SYSTEM3.4 ORGANIZATIONAL STRUCTURE3.5 INPUT ANALYSIS 3.6 PROCESS ANALYSIS3.7 OUTPUT ANALYSIS3.8 INFOMATION FLOW DIAGRAM3.9 PROBLEMS OF THE EXISTING SYSTEMCHAPTER FOUR: DESIGN AND IMPLEMENTATION OF THE NEW SYSTEM4.1 DESIGN STANDARD4.2 OUTPUT SPECIFICATION AND DESIGN 4.3 INPUT DESIGN AND SPECIFICATION 4.4 FILE DESIGN 4.4.1 Structure for file “payment” 4.4.2 Structure for file “warehouse form”4.6 SYSTEM FLOWCHART4.7 SYSTEM REQUIREMENTS4.7.1 Hardware Requirements 4.7.2 Software RequirementsCHAPTER FIVE: SUMMARY, CONCLUSION AND RECOMMENDATIONS5.1 SUMMARY5.2 CONCLUSION RecommendationREFERENCESAPPENDICESAPPENDIX - AAPPENDIX – BAPPENDIX – CAPPENDIX – DAPPENDIX – EAPPENDIX – FAPPENDIX – FAPPENDIX – GSOURCE CODE
CHAPTER ONEINTRODUCTION:This chapter gives an overview about the aim, objectives, background and operation environment of the system.1.1 BACKGROUND OF THE STUDYSeaportBilling System is an application which is generally small or medium in size. It is used by seaport authority to manage the warehouse using a computerized system where all various transactions and billings are done in the warehouse of the seaport. Billing report, payment and customer Modules are also included in this system which would keep track of the customer andbills in the warehouse and also a detailed description about the goods or items stored in the warehouse. With this computerized system there will be no loss of records or member records which generally happens when a non - computerized system is used. In addition, Summary/Statistics report module is also included in seaport Management System. All these modules are able to help warehouse manager to manage the warehouse with more convenience and in a more efficient way as compared to warehouse systems which are not computerized.1.2 STATEMENT OF THE PROBLEMSThe problems found in the seaport during operations was so much that there were cases where goods got missing, if it is not stolen by the frauds it may be stolen by the staff, part of some goods were shared among people before taking to the warehouse, manual issuing of receipt, Unidentification of goods in the warehouse, time required to record as well as presenting an Information and also the cost of purchasing goods, also transportation issue was another problem were ships got wreck on its way. Lack of effectiveness in their methods of record keeping, further compounds the problem. 1.3 OBJECTIVE OF THE STUDYThe project aims and objectives that will be achieved after completion of this project are discussed in this subchapter. The aims and objectives are as follows:1. To resolve billing issue2. To Request column for seaport management for providing new goods3. To create A separate column for billing4. To provide login page where the admin can access the system.5. To provide Summary/Statistical report where all goods are being sold and how many are left.1.6 SIGNIFICANCE OF THE STUDYThe significance of this study was to help and give a benefit to the concerned group below. This study will be beneficial to the following: Customers: Through computerized seaport billing system, they can easily book forgoods that they wantwithout going through the traditional way of searching for where they will make their payment. Convenience is more visible for it is not time-consuming, resulting to a number of accomplished works. Seaport and warehouse management:The computerized seaport billing system would improve the monitoring capacities of those who maintain the seaport. It would be easier to determine whether particular goods are in the warehouse or not. In addition, they can easily identify when all goods are being sold and how much. Furthermore, the seaport management would be much guided when it comes to recognizing new inventory goods, letting them arrange it promptly and accordingly.1.7 LIMITATION OF THE STUDY1. Unavailability of academic materials.2. Transport problem3. Lack of financial support4. Lack of Time 5. Unavailability of programming software such as vb.Net.1.9 SCOPE OF THE STUDYThis research work will concentrate on Warehouse entry,Profile (Registration and login details), Payment, Bill report, Summary/ Statistics, Calculator, Customer and Supplier menu which includes handling of some queries like; updating record, deleting record and searching for Customers who have already paid and warehouse information via Items, Supplier details, payment method, and shipping as the case may be. It is a case study of Nigerian Seaport Authority, Onne, Port Harcourt. 1.8 ASSUMPTION OF THE STUDYDuring the process of data collection, information relating to seaport Management System was obtained from IBOM E - LIBRARY. The information was collected from the admin staff during the course of my industrial attachment. Hence, it is assumed that all the data collected are correct and contains no false information.1.8 DEFINITION OF TERMSSeaport:A large town on or near a coast with a harbor that big ships can be used. Management: It is the co-ordination of all the resources of an Organization through the process of planning, Organization, directing and controllingSystem: Physical component of a computer that is used to perform certain task.Data: Numbers, Text or image which is in the form suitable for Storage in or processing by a computer, or incomplete Information. Information: A meaning full material derived from computer data by organizing it and interpreting it in a specified way.Input: Data entered into a computer for storage or processing. Output: Information produced from a computer after processing. Information System: A set of interrelated components that collect (or retrieve), process, store and distribute information to support decision making and control in an organization. Seaport Management System: A seaport management system, also known as an automated seaport system is software that has been developed to handle functions of a seaport. 1. COMPUTER:-Computer is an electronic device that accepts data as Input, processes data and gives out information as output to the user.2. SOFWARE:-Software is set of related programs that are designed by the manufacturer to control the hardware and to enable the computer perform a given task.3. HARDWARE: - Hardware is a physical part of a computer that can be touched, seen, feel which are been control by the software to perform a given task.4. DATABASE: - Database is the collection of related data in an organized form.5. PROGRAMMING: - programmingisa set of coded instruction which the computers understands and obey.6. TECHNOLOGY: -Technology is the branch of knowledge that deals with the creation and use technical and their interrelation with life, society and the environment, drawing upon such as industrial art, engineering, applied science and pure science.7. Algorithm : A set of logic rules determined during the design phase of a data matching application. The ‘blueprint’ used to turn logic rules into computer instructions that detail what step to perform in what order.8. Application: The final combination of software and hardware which performs the data matching.9. Data matching database: A structured collection of records or data that is stored in a computer system.10. Data cleansing: The proactive identification and correction of data quality issues which affect an agency’s ability to effectively use its data.11. Data integrity : The quality of correctness, completeness and complain with the intention of the creators of the data i.e ‘fit for purpose’12. Enrollment : The process of an individual to enroll aith an agency. Involves the initial collection of identifying details..