DESIGN AND IMPLEMENTATION OF A COMPUTERIZED FUEL DISPENSER SYSTEM A CASE STUDY OF AP FILLING STATION

DESIGN AND IMPLEMENTATION OF A COMPUTERIZED FUEL DISPENSER SYSTEM (A CASE STUDY OF AP FILLING STATION, CALABAR)

CHAPTER ONE/INTRODUCTION

1.0 Introduction

Nigeria is blessed with abundant natural resources of which petroleum products play a major role. At present, Nigeria is the ninth world producer and sixth world exporter of crude oil. On the domestic economy, the petroleum sector generates over 90% of the country’s foreign exchange earnings, and provides employment in various forms to Nigerians . In addition, the tremendous growth in oil earnings has influenced significantly Nigeria’s international relations, and sometimes the politics of oil has taken centre stage in the nation’s history of international relations in the last few decades. [1] observed that after almost half a century of oil exploration in Nigeria, the oil industry is earning a mature status in comparison to other industries in the country such that significant progress has been made in terms of oil exploration and sale of crude oil abroad. Unfortunately, the domestic management of petroleum resources such as fuel is fraught with a number of problems. There are occasional product shortages, inefficient product distribution and contending pump price of petrol.

These problems are compounded by ethnic and civil disturbances in the Nigeria-Delta oil producing areas. This situation sometimes leads to destruction and vandalization of oil pipelines, disturbances in operation of the oil explorations and damage to life and properties. Over the years, the supply of petroleum products, mainly white products into the Nigeria market has been through the private and public organizations. The public organizations are the government agents and functionaries such as the Nigerian National Petroleum Corporation (NNPC) and its subsidiaries, the Department of Petroleum Resources (DPR), the Petroleum Products Pricing Regulatory Authority (PPPRA) and Pipeline Product and Marketing Company (PPMC) while the private sectors are the indigenous and foreign organizations. The indigenous sector was introduced in 1978 with more than 20 private independent marketers after a year of operations. The foreign (major) oil marketers operating in the country are Mobil Oil Nigeria Plc, MRS Nigeria Plc, Total Nigeria Plc, Con oil Plc, Oando Nigeria Plc and African Petroleum Plc.

1.1 Theoretical Background

The technology used to implement the system is database technology. An interface is created using Visual BASIC 6.0 programming language and is connected to the database using adodc control tool. The source code that can be used to query the database for lifting entries of petroleum product for a particular date is shown below:

Private Sub Command2_Click()

Adodc1.Recordset.Filter = “ARRIVAL_DATE =’” & Text1.Text & “‘”

End Sub

Fig 1.1: Arrival Entries database

1.2 Statement of Problem

Fuel oil distribution companies service their customers with fuel. The problems are:

  1. It is difficult to accurately keep record of the distribution details of the tanker lorries and to know the sales per day, number of litres sold so as to determine when to re-order for more fuel in the filling station.
  2. Most customers that demand for the product do not get it on time because of poor management of fuel order and occasional shortages.
  3. Also, it is difficult to instantly get report of the details of fuel dispensed daily,
  4. The manual system of recording the litres sold at the end of the day is still in use as there is no computerized system to solve this problem.
  5. Most filling stations run out of fuel because they cannot track down quickly the number of litres sold, thereby making them to run out of the product without knowing.

It is in view of these problems that this research study is carried out.

1.3 Aim and Objectives of the Study

The aim of the study is to design and implement a computerized fuel dispenser system. The following are the specific objectives:

  • To develop a database system that will keep record of fuel received in the filling station.
  • To track down the litres sold daily and total amount
  • To develop a system that will enable management of the filling station to know when they should order for more fuel.
  • To develop a system that will aid easy updating and reporting of fuel dispensing record.

1.4 Significance of the Project

The significance of the study is that it will enable the management of AP filling station to easily manage their fuel dispensing record. It will save time and promote smooth running of the filling station by enabling them to monitor their fuel supply level. This will ensure that they always have fuel to service their customers. The study will also serve as a useful reference material to other researchers seeking for related information on the subject.

1.5 Scope of the Study

This study covers the design and implementation of a computerized fuel dispenser system, using AP filling station, calabar as a case study. It is limited to keeping record of fuel dispensing records such as lifting of petroleum product, arrival of petroleum product and daily sales records.

 

1.6 Organization of the Research

This research work is organized into five chapters. Chapter one is concerned with the introduction of the research study and it presents the preliminaries, theoretical background, statement of the problem, aim and objectives of the study, significance of the study, scope of the study, organization of the research and definition of terms.

Chapter two focuses on the literature review, the contributions of other scholars on the subject matter is discussed.

Chapter three is concerned with the system analysis and design. It presents the research methodology used in the development of the system, it analyzes the present system to identify the problems and provides information on the advantages and disadvantages of the proposed system. The system design is also presented in this chapter.

Chapter four presents the system implementation and documentation, the choice of programming language, analysis of modules, choice of programming language and system requirements for implementation.

Chapter five focuses on the summary, constraints of the study, conclusion and recommendations are provided in this chapter based on the study carried out.

Download Full Material-N5000

Related Post

Automated web based court case information management system

Automated web based court case information management system

CHAPTER ONE/INTRODUCTION

Background to the study 

 

The Judiciary is the system of courts of justice in a country, the arm of government charged with the responsibility to administer justice. Nigeria’s legal system was built on a foundation of received Anglo-Saxon common law, statutory law, and other documents. (The Judicial Secretary, 2016). It is independent from other government functions and provides a forum for the just resolution of disputes in order to preserve the rule of law and to protect the rights and liberties guaranteed by the Constitution of Nigeria. The Nigerian Judiciary consists of the Superior Courts of Judicature, which include the Supreme Court, the Court of Appeal, the High Court and the lower courts currently comprising the Circuit Courts, the District Courts and the Juvenile Courts. The Fast Track, Commercial Courts, Human Rights Court, Financial, Industrial (Labor) and Land Courts have recently been established as divisions of the High Court to facilitate the speedy resolution of disputes, particularly those of a specialized nature. (Dickson, 2015)

The advancements of the 21st century have led to an emergence of many disciplines with great potential to solve existing problems. One such potential field is Technology, which has over the years been increasingly adopted in many processes to avert the problems of ineffective and inefficient service delivery. (Chrisphine, 2012). One of the key areas of interest is automation of the judicial processes. Many challenges have been faced in the process of attaining justice including delays due to misplacement of the case files at the registry when reference is ought to be made. As legal practice has become more technologically advanced, pressure mounts on the courts is to join the flow of technological progress in other to provide a good service delivery. In addition, to emphasis on government transparency, to build public trust and confidence in judicial institutions. (Slowes, 2012)

Electronic Case Distribution System (eCDS) was introduced in Judicial Service of Nigeria. Under the Electronic Case Distribution System (eCDS), cases are assigned to the judges by the registrar. The system was to select adjudication cases at the High Court and was automated to eliminate suspicion of case fixing. It was introduced to judicial staffs and other stakeholders in Kumasi by Robert Cudjoe the Director of ICT in Judicial Service. (Joy FM, 2011)

The court can now electronically manage a case from the filing state and assigning cases to judges.

 

Case management

 

Case management is one of the main management activities in use within courts. The other main management effort is court management. While case management is connected to the primary processes in courts, which includes court administration and other processes that are directly related to case processing, the court management is connected to the secondary processes in courts and involves activities like strategy making, human resource management, research and development, Technology, finance, and maintenance of the build environment. (Rooze, 2010).

 

Component of case management

 

Electronic case management systems provide support and automation in case management. In order to support or automate case management, it is necessary to understand the components of case management as a management support. A typical process in court consists: (a) receive documents; (b) administrative preparation; (c) content preparation; (d) court decision-making;

(e) content elaboration; (f) administrative completion; (g) send and archive. (Rooze, 2010).

 

         Statement of the Problem

 

Recently, Prosecuting Attorney’s current case management system is a desktop base application where cases that are registered are printed out and pasted on the notice board to enhance public access. The courts print out the cases that will be held in that particular week and keeps the outdated cases that have already been held in excel on the desktop. Due to this clients need to come back to the court to confirm the day its case will be held and sometimes leads to frustrations.

 

This project seek is to control and allow complete registration of all cases related to court activities to enhance reduction of time and eliminating manual works. The System delivers core functionality that is to provide meaningful ancillary benefits to the courts, such as more efficient data entry, more effective data retrieval, better tools and enhanced bar and public access, thus the public can have access to it anytime and anywhere.

Well developed and implemented Electronic Court Case Management System (eCCMS) make it possible for a court to stick more closely to a published standard schedule and timetable, which the court can track cases better, and controls the use of resources and notify and inform all on what has been decided and what is to be expected.

 

             Purpose of the study

 

To study the influence of the Electronic Case Management System (eCCMS) on implementation and effectiveness of court service delivery in the Law Court Complex, Judicial Service of Nigeria.

         Project Aims and Objectives

The aim of this project is to develop and implement an Electronic Court Case Management System (eCCMS) to control and allow complete registration of all court case which are related to the court by the domain user thus registrar, who can register, update, delete, and search case and create report. The flow of information provides communication and notification between the courts and public.

 

         The following are the Objectives of the Project

 

  • To implement an Electronic Court Case Management System (eCCMS) for case registration which are related to courts, and creation, modification and updating through user
  • The software will allow information to be entered by users, control information in the system and tracking of current case status to enhance public
  • The system “Event” and “Scheduling” is to determine new case arrivals, session appointments, case deadline, reservation of courtroom and the judge who will head the case.
  • To develop friendly user interfaces combined with intuitive
  • To create a database to store, manage and backup case
  • To create an administrator page that will show statistical

 

 

         Significance of the study

 

 

When this project is completed, it will benefit the following stakeholders: the industry (Judicial service), the society and the academia.

 

 

         The industry (Judicial Service)

 

 

The system will be used by the registrar for case registration and data processing (data storage and data retrieval) which involves creation, modification and updating information through user interface.

The Chief registrar as well will be able to know the activities that is going on in various courts such as the name of registrars and the judge in each court, the time the registrar spent after login and also show the total number of a case type in each court such as trespassing, defrauding, robbery, data breach etc.

 

         The society

 

 

The system will enable client or individuals to get access to a case details anywhere and anytime by going online to visit the webpage, which shows the details of a case such as the sitting date, the suit number, the name of the judge who will handle the case, the courtroom which the case will be held, the names of both plaintiff and defendant, etc.

 

         Academia

 

 

This project will illustrate how open source tools can be used for the development of web-based applications thereby making the academia  aware  of  the  benefits  of  using  cheaper  tools.  This project in future will allow other students to review the application and to think of new ways in which some components of the application will be improved or think of ways of adding new components to meet more needs.

 

 

         Methodology

 

 

The nature of the project recommended agile model of System Development Life Cycle (SDLC).The agile model process starts with a simple implementation of a subset of the software requirements and iteratively enhances the evolving versions until the full system is implemented.

 

The agile methodology gives the need to develop a system based on the requirements of the users, and enable to add up various units of the system pertaining the various feedbacks received from the users. At each iteration and increment, design modifications are made and new functional capabilities are added. And the phases includes Identifying Problems, Opportunities and Objectives, Determine Human Information Requirement, Analyzing System Needs, Designing the Recommended System, Developing and Documenting Software, Testing and Maintenance of the system.

 

Observation at the Supreme Court and The Law Court Complex showed that the Court had traditional ways with managing administration tasks, such as case registrations, viewing the case list (Cause list) to the public and scheduling of cases. The courts sometimes struggle with tracking cases since their system is a desktop based system. This problem presented itself as an opportunity that can be built upon. The public sometimes complains they had to come far away from their destination to check when a case will be held and the courtroom. People visiting the first time get frustrated since he will pass through many processes sometime wait for long to know the time a case will be held.

Obtaining this information a system will be designed that will meet the requirement of all the users both the Domain users and the public. In the design phase, every user interface will be designed for each section of the web application. Each user interface will be designed based on the principles of the User Experience (UX).

Localhost, MySQL and MariaDB will serve as database source. The familiarity with MySQL offers the chance to work without problems. The development of this web application will require HTML CSS, jQuery. These will help in the development of the user interface and its elements such as web forms, buttons, and modals.

Finally, PHP as server side programming language to interact with MySQL database and MariaDB. The web application will be implemented via a hosting plan. Users will be able to access the web application by going to the specified URL of the application. The design will ensure a smooth transition to the web application for all users of the system.

 

         Organization of the study

 

 

The project report is divided into five chapters. Chapter one of the study introduces the problem statement and describes how the specific problem will be addressed through the aims and objectives and it also contains the significance of this study. Chapter two focuses on the review of literature and relevant research associated with the problems addressed in the study. Chapter three presents the methodology and procedures used for data collection and analysis,  determining functional and non-functional requirements of such an application. In chapter four, covers the areas of implementing and testing of various prototypes at different stages in the development and also it also contains the various techniques and languages used in the development process. Chapter five offers a summary and discussion of findings, implications   for practice, present and future and recommendations for future research.

Download Full Material-N5000

DEVELOPMENT OF A WEB-BASED TAX ASSESSMENT SYSTEM

DEVELOPMENT OF A WEB-BASED TAX ASSESSMENT SYSTEM

ABSTRACT

The aim of this project was to develop a web-based system that will contain all the information about the private sector assets for tax assessment. The objective was to register and assess all the assets of the entire private sectors establishment in a particular area for tax payment. These assets include: land, heavy equipment, light equipment, motor/vehicle, residential building, commercial building, and industrial building etc. The system will carry out tax assessment of the assets and enable the user to know the amount of money to pay on for the assets as tax. The system performs the following function: e-registration, tax evaluation, listing of designated banks, tax offices, and business firms. A questionnaire was used as an instrument for data collection on information about the existing system. A Structural System Analysis and Design Methodology (SSADM) were used in the design of the software. The system was implemented using WAMP SERVER, PHP, HTML, CSS and MYSQL technologies. The result of the study revealed that the web-based system enables a client to register his/her business, generate an acknowledgement slip, conduct a tax evaluation of his assets, generate a tax invoice, display a list of officially designated banks for tax payment, display a list of tax offices. and also display a list of existing business firms in the area covered by the web-based system.

Download Full Material-N5000