Design and Implementation of a Computer Based Warehousing Information System A Case Study of Nigeria Ports Authority Npa Lagos

Design and Implementation of a Computer Based Warehousing Information System

Project / Seminar Material
Reference ID: PS-17909-TM

DEDICATION

This research material titled “Design and Implementation of a Computer Based Warehousing Information System” is dedicated to God for his enabling grace, and to all computer enthusiasts who contributed to make life a pleasant experience during my research documentation.

ACKNOWLEDGEMENT

I extend my sincere gratitude to all those who contributed to the completion of this project. Special thanks to my Supervisor (Name of your Supervisor), the Head of Department (Name of your HOD), the Lecturers in the department of Computer Science (CS), Book Authors and Profound Scholars of existing or related project material on “Design and Implementation of a Computer Based Warehousing Information System” for their invaluable guidance, support, and expertise throughout the journey.

I am also grateful to your study area (mention any funding organizations, if applicable) for their financial assistance. This research would not have been possible without the encouragement and assistance of some stakeholders (mention any mentors, teachers, or colleagues). Additionally, I would like to acknowledge the understanding and patience of my family and friends during this endeavor. Your unwavering support has been a constant source of motivation. Thank you all for being part of this meaningful endeavor.

TABLE OF CONTENTS

PRELIMINARY PAGES


CHAPTER ONE

INTRODUCTION


    CHAPTER TWO

    LITERATURE REVIEW

    • 2.1 Introduction

    CHAPTER THREE

    SYSTEM ANALYSIS AND DESIGN

    • 3.1 Methodology Adopted
    • 3.1.1 Problem Identification Using SSADM
    • 3.2 Analysis of the Existing System
    • 3.2.1 Dataflow of the Existing System
    • 3.2.2 Disadvantages Of The Existing System
    • 3.2.3 Weakness of the existing System
    • 3.3 Feasibility Study
    • 3.3.1 Economic Feasibility
    • 3.3.2 Technical Feasibility
    • 3.3.3 Operational Feasibility
    • 3.4 Analysis of the Proposed System
    • 3.4.1 Data Flow Diagram of the Proposed System
    • 3.4.2 Advantages of the Proposed System
    • 3.4.3 Justification of the Proposed System
    • 3.5 Functional Requirements
    • 3.5.1 Use Case Diagram Of The Admin / User Privileges
    • 3.6 Data Requirements
    • 3.7 High Level Model of the Proposed System

    CHAPTER FOUR

    SYSTEM DESIGN AND IMPLEMENTATION

    • 4.1 Objectives of the Design
    • 4.2 Cohesion and Decomposition High level Model
    • 4.3 Control Center / Overall Dataflow Diagram
    • 4.3.1 Proposed System Operation Flowchart
    • 4.4 System Specification and Design
    • 4.4.1 Input and Output Specification
    • 4.4.2 Database Specification and Design
    • 4.4.3 Data Dictionary
    • 4.5 Choice and Justification of Programming Language
    • 4.6 Program Documentation
    • 4.7 Implementation Techniques
    • 4.7.1 System Testing
    • 4.8 Programming Module Specification
    • 4.8.1 Installation
    • 4.9 Computer Hardware Minimum Requirement
    • 4.10 Software Requirement
    • 4.11 Personnel / User Training
    • 4.12 File Maintenance Module

    CHAPTER FIVE

    SUMMARY, CONCLUSION AND RECOMMENDATION

    • 5.1 Introduction
    • 5.2 Summary
    • 5.3 Conclusion
    • 5.4 Recommendation

    REFERENCES

    APPENDIX A - “SOURCE CODE”

    APPENDIX B - “OBJECT PROGRAM”

    ABSTRACT

    Warehousing information system is a software application or suite of applications designed to manage and optimize warehouse operations. The aim of the study is to design and implement A Computer Based Warehousing Information System. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will measure the improvements in efficiency, accuracy, and responsiveness achieved through the implementation of warehousing information system. The motivation that led to the implementation of the proposed system is that warehousing information system involves the collection and storage of sensitive data related to inventory, orders, and customers. Ensuring data security, protecting against cyber threats, and complying with data privacy regulations are critical concerns for organizations. The methodology adopted in this study is the structured system analysis and design methodology (SSADM) which is a technical approach for analyzing and designing an application or system by applying object throughout the software development process. The programming language used is HTML, CSS, JAVASCRIPT, PHP, SQL and JQUERY. The reason why web programming languages was used is because, it is platform independent and it is a web based application. The significance of effective warehousing information system implementation will lead to improved customer service by ensuring accurate and timely order fulfillment. Warehousing information system helps in maintaining regulatory compliance by accurately tracking inventory movements and ensuring proper handling of sensitive products. It also enhances warehouse security by monitoring access and reducing the risk of theft or loss The expected result is a computerized data warehouse that will enable real-time tracking of inventory levels, locations, and movements within the warehouse. This accuracy helps in reducing stock outs, overstocking, and associated costs, ensuring optimal inventory levels


    Design and Implementation of a Computer Based Warehousing Information System (A Case Study of Nigeria Ports Authority Npa Lagos)

    CHAPTER ONE

    1.1 Introduction

    Warehousing Information System (WIS) is a software application or suite of applications designed to manage and optimize warehouse operations, including inventory management, order processing, storage optimization, and logistics coordination (adapted from Huan et al., 2018). It is also a technological framework designed to manage and optimize warehouse operations using computer software and hardware. It integrates various functions such as inventory management, order fulfillment, storage optimization, and logistics coordination within a single platform. warehousing information system enables real-time tracking of inventory levels, facilitates accurate order processing, and enhances overall warehouse productivity.

    According to Li et al., (2020), warehousing information system is a critical component of modern logistics and supply chain management, providing essential capabilities for optimizing warehouse operations. WIS integrates various technologies to streamline inventory management, order processing, and overall warehouse efficiency (Li et al., 2020). This system plays a vital role in enhancing operational performance, reducing costs, and improving customer satisfaction through efficient handling and accurate tracking of goods within the warehouse environment.

    As a prelude to other parts of this study, this chapter will discuss the background upon which this study was initiated, the statement of problems that led to this study, the Aim and Objectives of the study. Others are Significance of the study, Scope of work, Limitation of the study and Definition of technical terms.


    1.2 Background of Study

    The history of Warehousing Information Systems (WIS) traces back to the evolution of computer technology and its application in improving warehouse management practices. Initially, warehousing operations relied on manual methods for inventory control and order processing. However, with the advent of computers and information technology, there was a significant shift towards automating and optimizing these processes.

    Early implementations of WIS focused on basic functionalities such as inventory tracking and order fulfillment. Over time, advancements in computing power, networking, and software development led to more sophisticated WIS that integrated with other enterprise systems like Enterprise Resource Planning (ERP) and Customer Relationship Management (CRM) software. This integration facilitated seamless data sharing across different departments and improved overall operational efficiency within warehouses.

    Historically, warehousing operations relied heavily on manual processes for inventory management, order fulfillment, and logistical operations. The advent of computerized systems in the mid-20th century marked a significant shift towards automation and digitalization within warehouses. Early systems focused on basic inventory tracking and order processing, gradually evolving into more sophisticated Warehouse Management Systems (WMS) and subsequently, comprehensive Warehousing Information Systems (WIS). The development of WIS has been driven by advancements in technology, particularly in areas such as barcode scanning, RFID (Radio-Frequency Identification), IoT (Internet of Things), and cloud computing. These technologies have enabled real-time visibility into warehouse operations, improved accuracy in inventory management, and enhanced operational efficiency.

    The challenges encountered that led to the execution of the research work is that, integrating WIS with existing ERP systems, CRM systems, and other business applications can be complex and resource-intensive. Compatibility issues and data synchronization challenges may arise, requiring careful planning and implementation. Further, warehousing information system involves the collection and storage of sensitive data related to inventory, orders, and customers. Ensuring data security, protecting against cyber threats, and complying with data privacy regulations are critical concerns for organizations.

    It is against the background that the developments of this software will enable the adoption of cloud-based WIS solutions is expected to grow, offering scalability, flexibility, and cost-effectiveness. Cloud platforms provide real-time data access, seamless updates, and enhanced collaboration across supply chain partners. Also, the access to accurate and real-time data through WIS enables informed decision-making. Warehouse managers can analyze performance metrics, identify trends, and make adjustments to improve operational effectiveness.


    1.3 Statement of Problem

    The statement of problems for a "Warehousing Information System" (WIS) typically addresses various challenges and issues that organizations face in managing warehouse operations effectively. These problems include:

    1. Integration Complexity: Integrating warehousing information system with existing ERP systems, CRM systems, and other business applications can be complex and resource-intensive. Compatibility issues and data synchronization challenges may arise, requiring careful planning and implementation.
    2. Initial Investment and ROI: The initial costs associated with implementing warehousing information system, including software, hardware, and training costs, can be significant. Organizations must carefully evaluate the return on investment (ROI) and long-term benefits to justify these expenses.
    3. Data Security and Privacy: Warehousing information system involves the collection and storage of sensitive data related to inventory, orders, and customers. Ensuring data security, protecting against cyber threats, and complying with data privacy regulations are critical concerns for organizations.

    1.4 Aim and Objectives of the Study

    The aim of the study is to design and implement a computer based warehousing information system. In achieving this aim, the following specific objectives were laid out as follows:

    1. To identify the key components and capabilities of WIS in optimizing warehouse processes such as inventory management, order fulfillment, and space utilization;
    2. To assess the existing methods and technologies used for managing warehouse operations;
    3. To measure the improvements in efficiency, accuracy, and responsiveness achieved through the implementation of warehousing information system;
    4. To explore the advantages gained and the obstacles faced by organizations during the adoption and integration of warehousing information system; and
    5. To provide actionable recommendations for enhancing the effectiveness and utilization of warehousing information system in warehouse management.

    1.5 Significance of Study

    The significance of effective warehousing information system implementation will lead to improved customer service by ensuring accurate and timely order fulfillment. Understanding its role in customer satisfaction and retention is crucial for businesses aiming to gain a competitive edge. Furthermore, as businesses expand and diversify their operations, warehousing information system scalability becomes crucial. Studying warehousing information system scalability helps businesses understand how to adapt their warehouse management systems to accommodate growth and evolving business needs.

    Moreover, warehousing information system can contribute to sustainability efforts by optimizing warehouse operations, reducing waste, and minimizing environmental impact. Understanding its role in promoting sustainable practices is increasingly important in today's business environment.

    Ultimately, studying Warehousing Information Systems not only provides practical insights into improving warehouse operations but also contributes to broader discussions on supply chain efficiency, technology adoption, and organizational performance in the digital age.


    1.6 Scope of Study

    The scope of this research is focused on the design and implementation of a computer based warehousing information system using Nigeria Ports Authority, Lagos State as a case study.


    1.7 Limitations of the Study

    During the course of this study, many things militated against its completion, some of which are:

    1. Time Constraint: The time frame given to accomplish this project was very short due to school academic calendar and it was carried out under pressure which made the researcher not to implement some necessary features.
    2. Establishment Policies: Establishment policies posed a serious limitation as most staffs are not ready to release information needed for this project work. There were lots of information needed from the staffs of this institution to enhance the study which took them time to release or they did not release at all for security purposes, hence the scope was reduced.
    3. Financial Constraint: Insufficient fund tends to impede the efficiency of the researcher in sourcing for the relevant materials, literature or information and in the process of data collection (internet).

    1.8 Definition of Terms

    Warehousing Information System (WIS):

    It is a software application or suite of applications designed to manage and optimize warehouse operations, including inventory management, order processing, storage optimization, and logistics coordination (adapted from Huan et al., 2018).

    Inventory Management:

    It is the process of overseeing and controlling the storage, movement, and availability of goods within a warehouse or distribution center to ensure adequate supply without excess (adapted from Chopra & Meindl, 2019).

    Order Processing:

    It is the sequence of steps involved in receiving, reviewing, and fulfilling customer orders, which may include picking, packing, and shipping (adapted from Simchi-Levi et al., 2020).

    CHAPTER TWO

    2.0 Literature Review

    2.1 Introduction

    This chapter focuses on the review of related literature. A literature review includes the current knowledge as well as theoretical and methodological contributions to a particular topic. It documents the state of the art with respect to the topic you are writing. It surveys the literature in the topic selected. In this research work the literature review includes the …

    Summary Headlines for Design and Implementation of a Computer Based Warehousing Information System