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 CONTENT
Title
Abstract
Certificate
Acknowledgement
Table of Content
CHAPTER ONE: INTRODUCTION
Background of the Study
Statement of Problems
Objectives 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 SOFTWARE
TYPES OF SOFTWARE
DATABASE DESIGN AND MANAGEMENT
CLASSIFICATION OF DATABASE
2.3 FUNCTIONS OF INFORMATION SYSTEM
2.3.1 Functions of an information system
2.4 TYPES OF INFORMATION SYSTEMS
2.4.1 Types of Information system
2.5 MANAGEMENT INFORMATION SYSTEM
CHAPTER THREE: METHODOLOGY AND ANALYSIS OF THE EXISTING SYSTEM
3.1 GENERAL DESCRIPTION OF THE EXISTING SYSTEM
3.2 FACT-FINDING METHODS USED
3.2.1 Primary Source
3.2.2 Secondary Source
3.3 OBJECTIVES OF THE EXISTING SYSTEM
3.4 ORGANIZATIONAL STRUCTURE
3.5 INPUT ANALYSIS
3.6 PROCESS ANALYSIS
3.7 OUTPUT ANALYSIS
3.8 INFOMATION FLOW DIAGRAM
3.9 PROBLEMS OF THE EXISTING SYSTEM
CHAPTER FOUR: DESIGN AND IMPLEMENTATION OF THE NEW SYSTEM
4.1 DESIGN STANDARD
4.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 FLOWCHART
4.7 SYSTEM REQUIREMENTS
4.7.1 Hardware Requirements
4.7.2 Software Requirements
CHAPTER FIVE: SUMMARY, CONCLUSION AND RECOMMENDATIONS
5.1 SUMMARY
5.2 CONCLUSION
Recommendation
REFERENCES
APPENDICES
APPENDIX - A
APPENDIX – B
APPENDIX – C
APPENDIX – D
APPENDIX – E
APPENDIX – F
APPENDIX – F
APPENDIX – G
SOURCE CODE
CHAPTER ONE
INTRODUCTION:
This chapter gives an overview about the aim, objectives, background and operation environment of the system.
1.1 BACKGROUND OF THE STUDY
SeaportBilling 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 PROBLEMS
The 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 STUDY
The 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 issue
2. To Request column for seaport management for providing new goods
3. To create A separate column for billing
4. 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 STUDY
The 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 STUDY
1. Unavailability of academic materials.
2. Transport problem
3. Lack of financial support
4. Lack of Time
5. Unavailability of programming software such as vb.Net.
1.9 SCOPE OF THE STUDY
This 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 STUDY
During 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 TERMS
Seaport: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 controlling
System: 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.
.