77891663 Petrol Pump Management System PDF

Preview

Summary

ACKNOWLEDGEMENTThe merits of our project depends only on the wide panorama of the people whohave devoted their precious time , and provided valuable suggestion as well asguidance to our project.We are highly obliged to our H.O MAHESH GURUNANI SIR and ourH.O MANISH SALVI SIR sir who passed our projec...

Description

ACKNOWLEDGEMENT

The merits of our project depends only on the wide panorama of the people who have devoted their precious time , and provided valuable suggestion as well as guidance to our project.

We are highly obliged to our H.O.D MAHESH GURUNANI SIR and our H.O.D MANISH SALVI SIR sir who passed our project at its very initial stage of planning. Also he told us to work on our project at the starting of the year. Also he told us to take the help of him if we want in our project.

We also express our gratitude towards our project guide VIKAS AGRAWAL SIR who has guided as well as helped from the apex of our project. We also express our gratitude to our project co-guide KIRAN SIR whose comments has greatly helped us to make our project more approachable towards the user.

We would also like to thanks our lab assistant who allowed to work on pc of their lab and also helped in our project for taking some printout. Also we thanks to their keen interest in our project and their intellectual assistance throughout their completion of their project.

The collection of the various ideas , and the progress of our project depends upon the intellectual of all the staff members of INFORMATION TECHNOLOGY AND COMPUTER ENGINEERING DEPARTMENTS.

Finally we would like to express our group members who have project and made it successful by the time of submission.

duly worked on the

www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/ Final Year Project's is One place for all Engineering Projects, Presentation, seminar, summer training report and lot more. NOTE:-This work is copyright (©) to its Authors. This is only for Educational Purpose.

Affiliated to Maharashtra state board of technical education

(MSBTE) MUMBAI

CERTICATE This is to certify that

BHAVIN MISTRY. SUJIT MOURYA. CHINTAN RAMANANDI. MIHIR JARIWALA. Have submitted this project work entitled “Petrol Pump Management System” is a bonafied record of project work carried out in partial fulfillment for the award of the

DIPLOMA IN

INFORMATION TECHNOLOGY This is a record of their own work carried out by them under our supervision and Guidance --------------------------------------------Project Guide VIKAS AGRAWAL ---------------------H.O.D(I.F) (MAHESH GURUNANI)

---------------------------PRINCIPAL (MR.S.M.GANECHARI)

2005-2006

2 www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/

www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/ Final Year Project's is One place for all Engineering Projects, Presentation, seminar, summer training report and lot more. NOTE:-This work is copyright (©) to its Authors. This is only for Educational Purpose.

PREFACE

Computerisation is worldwide and requires only software to run huge industries and institution. TODAY THE INDUSTRIAL WORLD IS LARGELY HIT BY AUTOMATION.

Here we present our project of PETROL MANAGEMENT . The aim of our project is to acquaint our user with various detail of our system. Thus this report give you the brief overview of our project.

Our project report is divided into various chapter. In which the first chapter is introduction which gives the introduction about the whole project what the project is what is the main content of our project. The second chapter is about the system development life cycle means it gives us the information about how we had designed our project . The third chapter is about the language which we used in our project. And also the frontend language which we used in our project. The fourth chapter is about the DFD OF OUR PROJECT.

THE fifth chapter deals with the detail explanation of our project. It describes the various forms which we used in our project and what that forms means. The sixth and seventh chapter deals with the advantage and the application of our project.

Then eight chapter deals with future expansion of our project.

3 www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/

www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/ Final Year Project's is One place for all Engineering Projects, Presentation, seminar, summer training report and lot more. NOTE:-This work is copyright (©) to its Authors. This is only for Educational Purpose.

CONTENTS

CH.NO 1

TOPIC INTRODUDTION 1.1

P.N. 6

Industries as the backbone Of the country.

1.2

Current status of automation In industries.

2

1.3

About Petrol Management.

1.4

Manual handling of the pumps.

PROJECT PLAN 2.1 Feasiblity study 2.1.1 Operational 2.1.2 Technical 2.1.3

Cost/benefit analysis

2.2 Life-Cycle phase 2.3 System Analysis 2.4 System requirements. 4 www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/

9

www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/ Final Year Project's is One place for all Engineering Projects, Presentation, seminar, summer training report and lot more. NOTE:-This work is copyright (©) to its Authors. This is only for Educational Purpose. 2.5 Data-flow-diagram 2.5.1 Context DFD 2.5.2 DFD-Level- 1 2.5.3

DFD-Level-2

2.5.4 DFD-Level- 3 2.6 System design 2.7 Coding detail 2.8 System Testing 2.9 Maintenance

3

WHY VB 6.0 3.1

Overview of a visual basic language.

3.2

The several features of VB.

3.3

19

Connecting VB with backend MS-ACCESS.

4

COMPLETE EXPLANATION

22

5

ADVANTAGES

55

6

FUTURE EXPANSION

56

7

LIST OF FIGURES

8

BIBLIOGRAPHY

5 www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/

57

www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/ Final Year Project's is One place for all Engineering Projects, Presentation, seminar, summer training report and lot more. NOTE:-This work is copyright (©) to its Authors. This is only for Educational Purpose.

1 INTRODUCTION

These project means that what the various activities are been carried out at the petrol system. In these project we will be including about how we can find out the information about the various petrol pump. Also in our project we will be including how we can find that which person has came when and when he will be going out. Also we will including that which person has sold how many litres of petrol, diesel, oil.

Also we can find that what is the amount he has received on a particular day. Also in our project we will be including the sales module in which a person can find what is the work done by a particular person on that day. Also a person can find out whether a person is present on that day or not.

6 www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/

www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/ Final Year Project's is One place for all Engineering Projects, Presentation, seminar, summer training report and lot more. NOTE:-This work is copyright (©) to its Authors. This is only for Educational Purpose. Also a person can find thru net what is the cost of the particular petrol, diesel, oil per liter. Also we will be including how we can find that what is the bonus a particular employee is getting. Also we will be including how we can find full details of all employee like his address, phone number etc. Also if we want to get a information of a particular employee we can get thru database.

Also we can find about what salary a employee is getting in our project. Also we will be including how we can find what is the amount of petrol, diesel, oil a employee has sold. Also we will be including how we can find which employee is working in which shift and also his daily reports. Also we will be including how we can find which is the senior staff in petrolpump.

Also we will be including some of the database reports of how we can update the particular information about a employee. Also we will be including how a person can get the information about which employee is the most experiences and which is the newly joint. Also we will be including how we can get the information of which employee has joint at which time and at which date.

1.1

INDUSTRIES AS THE BACKBONE OF THE COUNTRY:-

Now a days all the companies are being developing with the help of software. First there were no many software company in the country but as the world is progressing many software engineers are also being developed.Due to this software industries all work is done easily by the help of computers. There is no need to maintain a file record all the record can be saved in the computer.

1.2 CURRENT STATUS OF AUTOMATION IN INDUSTRIES:7 www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/

www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/ Final Year Project's is One place for all Engineering Projects, Presentation, seminar, summer training report and lot more. NOTE:-This work is copyright (©) to its Authors. This is only for Educational Purpose.

Before the computer were developed all work was done manually. So in order to overcome this computer was developed. Now the whole world has developed due to autoamation. Means with the help of computer all work is done automatically. In industries also the work is done thru the help of computer only so there is no need of keeping more workers in industries. Because as the work is done automatically the world is progressing due to this. In pune,hydrebad&banglore the software industries are developing in more percentage so there also the work is done automatically in industries.

1.3

ABOUT PETROL MANAGEMENT

As the work at petrol pump is done manually so it becomes

hard for the supervisor

to maintain a daily record. So for that we decide to make this project in which all the work is done with the help of one computer. Our project gives the supervisor to maintain a daily record in an easiest way. In our project there are several forms we had included. Our project is totally based on VB LANGUAGE. In our project we had included a form named OPERATION in which the supervisor can find the detail information of the employee. Also with this he can delete the employee record if he wants. In our project we have a module named product cost in which we can get the cost of each product. Also we have a module named staff management in which we can get the information about each staff like about his address , phone number , joining date , native address. Also in our project we have a report which has an ado connectivity which is useful for entering the data to the database table. Also we have a report form in which there are several reports like pumps daily report , shift delivery report , pumps report , cumulative daily report , salary report. This all has an database querry which is useful for entering the data of the database. Also this petrol pump management system will be useful for many pumps. Also we have provided the password facility for each module in our project for its safety purpose so if there are any confidential matter then it can be preserved by giving the password to that module so only the supervisor can open it no any other employee can open it.

8 www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/

1.4

www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/ Final Year Project's is One place for all Engineering Projects, Presentation, seminar, summer training report and lot more. NOTE:-This work is copyright (©) to its Authors. This is only for Educational Purpose. MANUAL HANDLING OF PUMPS:-

In all petrol pumps if supervisor want to maintain the record of the pumps then he has to go to each pumps for calculating the readings of each pumps. But in our project we have provided facility to the supervisor in such that he can keep records of each pump just by sitting on one computer. If the supervisor wants to calculate to litres sold by an employee then he can view that just by clicking on module named litres sold this will display him the detail information of that employee how much he was given the petrol at the starting of the day and how much he has sold in whole day and the amount he has calculated. Also the supervisor can see whether the target given to him was completed or not. Also he can keep the record of the employee which are deleted and also can view whether the employee is paid the bonus or not. This will provide the supervisor to do his job easily any time he wants to access the data from the report of the any employee. Also if the supervisor wants the record of the pump then he can view that easily without having any effort of going to their and calculating the reading individually of the pump. This will be useful for viewing the information of all the pump available in the petrol pump.

2 PROJECT PLAN 9 www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/

www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/ Final Year Project's is One place for all Engineering Projects, Presentation, seminar, summer training report and lot more. NOTE:-This work is copyright (©) to its Authors. This is only for Educational Purpose. 2.1 FEASIBLITY STUDY:-

It deals with handling system problem. The feasibility study proposes one or more conceptual solutions to the problem set for the project. The conceptual solutions give an idea of what the system will look like. They define what will be done on the computer and what will remain manual. They also indicate what input will be needed by the system and what output will be produced by the system. Also it tells that whether the plan of the project is been made by the people. Here also it tells the timing of the project that whether it is completed in time or not. They also indicate whether the input will be needed by the system and what manual the output produced i.e in feasibility study the analyst has to do evaluation of existing systems and procedures. He has to present a number of alternative solutions to the user requirements.

2.1.1 OPERATIONAL:-

This feasibility study deals with the operation of the project. Here we are going to explain the whole operation of the project .In this project we have provide the ado connection which is useful for the connectivity of the database. This will provide the connection so that with which we can open more then one form due to this ado connection. This project is totally based on the visual basic language and in this visual basic we have provided the connection and also we have used ms-access so that we can create an database table. Here we have provided the user name and password facility so that there are some form which should provide security purpose. A system development project are likely to be feasible if it meets user requirements , needs , and expectation. User acceptance is an important determinant of operational feasibility. It requires careful consideration. Here also there are several reports generated by the database access so that which will be useful for entering the record of the employee .

10 www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/

www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/ Final Year Project's is One place for all Engineering Projects, Presentation, seminar, summer training report and lot more. NOTE:-This work is copyright (©) to its Authors. This is only for Educational Purpose.

2.1.2

TECHNICAL:-

This is a technical problem feasibility study. A system development project is likely to be feasible if it meets the user requirement. Here we have decided to use technical language called VISUAL BASIC and MS-ACCESS. The purpose behind this is that we are more familiar with this language and it is easily access by the other user. Also the code for writing this is very easy and we can get the information in many books. Also it deal with knowledge of current and emerging technology solutions. Also there are several coding which we have done that will be very useful in terms of technical term. It is concerned with the capacity of the proposed system to meet initial performance expectation and accommodate new functionality over the medium term.

2.1.3

COST/BENEFIT ANALYSIS:-

The cost of the project is less as compared to the other project. Also it is cheaper as compared to other project. Here only software is used so there is no need of extra cost that the project might be damaged. It is user friendly and can be interacted with other person. Also it can be used by any person if that person knows VB language then can be easily handled. Also there is no need of having any high range pc it can work with normal configuration pc.

2.2 LIFE CYCLE PHASE:In this life cycle phase there are several steps which are to be followed they are:1) System Engineering:This phase deals with the engineering part of the project. In system engineering work cannot be established before the system requirements for allocating the needs and subset of the requirements. In this we will be specifying the that whether it will be easy to 11 www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/

www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/ Final Year Project's is One place for all Engineering Projects, Presentation, seminar, summer training report and lot more. NOTE:-This work is copyright (©) to its Authors. This is only for Educational Purpose. work with this project or not. Also we have here provided the requirements like vb and msaccess.

2) System Analysis:Analysis is a detailed of the various operation performed by the system and the relationship exist between the system. In our project we analysed the relationship that we will be using in our project. In analysment we also decided how many module we will be including in our project. Also the brief overview of how our project will look like was done in the analysment. We also decided what type of connectivity we will be providing in our project was done. Also we referred some of the books of vb so that which will be useful for writing the code of the project. In analysement also we analyse that in how many days we will be completing our project so that it will be submitted in correct time as per the given schedule.

3) SYSTEM DESIGN:This is the most challenging phase of the System Development Life Cycle. In this phase we decided how our project design will look like. We designed several forms in VB which were to be include in our poject. There were around 29forms which were designed by us in which all the concepts was included. This designing of forms was helped by our project guide. It also focused on four steps:-

1)DATA STRUCTURE 2)SOFTWARE ARCHITECTURAL 3)PROCEDURAL DESIGN 4)CHARACTERISTICS

Also these designing was done only in vb in which we designed all the form and there are also some form which will be useful or entering the data so we designed that form in 12 www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/

www.final-yearprojects.co.cc | www.troubleshoot4free.com/fyp/ Final Year Project's is One place for all Engineering Projects, Presentation, seminar, summer training report and lot more. NOTE:-This work is copyright (©) to its Authors. This is only for Educational Purpose. database and also there are two module. This deigning finally was completed by us at the mid of the year.

4) CODE:This coding is done by us by referring the books in vb and some inf...