gas agency system
TRANSCRIPT
_ _______________________________________________Page No. 1
Gas Agency System
Krunal D ParekhNiraj A Mokashi
Shravankumar Ahir
Submitted ForParticular Fulfillment Of
I.T DiplomaYear 2009
Government Polytechnic
_ _______________________________________________Page No. 2
Supervisor Certificate
This Is To Certify That Mr./Ms. ______________ ______________ Of I.T (Seat No. ____) Has Worked On Project. Entitled ___________________________, From __________ To __________ . This (S-506) Is In-House Project Of Three Credits.
He/She. Was Regular In His/Her Work And Devoted Around 100 Hours For The Project Including Analysis And Design. He/She Has Completed The Project Satisfactory.
Date: -Head/Coordinator. Supervisor.
_ _______________________________________________Page No. 3
Acknowledgement
Project work is an assignment where by the candidates coming out of the academic field exposure to the person, who are on the job. Therefore it affords an opportunity of leaving from others experience.
We are extremely thankful to dr. H.s patel, principal of government polytechnic, who allowed me to work on the project.
We are extremely thankful to mr. Indravadan , the owner of the krishana coporation for providing us information and details of the shop.
We express sincere thanks to our h.o.d mr. Parvez faruki for inspiring
me to take up the direction and also rendering her precious help and guides. Without her co-operation and direction, it would have been difficult for me to compicate this dissection.
We sincerely express our deep source of gratitude to our project guide miss.jigna gandhi who has been immense help to us supporting and guiding us throughout the project work.
I would like to take this opportunity to thanks my counselor mr. Utpal
dholakia and other faculty member for their consultant inspiration.
Last but not list my heartily thanks to my friends and all lab staff .
i would once again like to express my heartiest to all who helps me directly or indirectly throughout this project work.
_ _______________________________________________Page No. 4
Project ProfileProject Title : Gas Agency System
Oraganization
: Krishna Corporation
Project Guide : Miss Jigna Gandhi
Submittted By : Krunal D ParekhNiraj A MokashiShravankumar Ahir
Front-End : Visual Basic 6.0
Back-End : Microsoft Access
Documentation : Microsoft Word
Submited To : Information Technology DepartmentGovernment Polytechnic,Panjarapole, Ahmedabad,380015.
_ _______________________________________________Page No. 5
_ _______________________________________________Page No. 6
Introduction To Krishna Corporation
Overviewo Krishana Corporation Is Located At Off: Navghari Opp- Dena
Bank Padra –391 440.o Mr. Indravadanbhai Shah Is The Owner Of The Corporation.o The Gas Agency Since 1990.
Introduction To Gas Agency System
Overviewo Krishna Corporation provide to a different gas bottle.o It is responsible to keep tract of
Customer information Stock information Reports
o Customer information and user were added in the implement phase to account for the way we decide to implement security.
_ _______________________________________________Page No. 7
_ _______________________________________________Page No. 8
Hardware Requirement Compaq Keyboard Compaq Monitor Compaq Mouse Pentium Processor 64 Mb Ram 4 GB Hard Disk
Software Requirement Front End Tool Visual Basic 6.0 Back End Tool Microsoft Access
_ _______________________________________________Page No. 9
Tools Information
Visual Basic 6.0 (Front – End Tool) VB is a program language and development that allows you to
create programs that run under windows operating system. It enable you to develop many different type of application. It is a programming language used to create windows base
application. It makes it very easy to get the user interface of the application
and running it. It is very easy and it provides a very friendly environment while
programming in vb. It provides a vital link to graphics environment and allows you to
develop application base on stander windows features. Dialogue box, command buttons, pulls down menus, scroll bars and selection lists etc.
It also allows crating robust application that fully make use of the graphics, user interface.
By connect with access can be run and terminated through vb 6.0.
_ _______________________________________________Page No. 10
Application Hierarchy Of Vb.
An application is made up forms, controls, modules.
Forms are windows on which you built user interface.
Controls are building of user interface control also called active x control and command button that you used to display information to the user, gather information from the user, and respond to the user action.
Procedures are small routing you write that are callable from anywhere in your application into small components that can be called in many times.
Events in a very important in any windows programming language. An event is something that occurs in response to a user interaction with keyboard or mouse. Events are those messages that the operating system sends to the applications.
Formsi. Properties
ii. Property Procedures.iii. Event Handless.iv. Other Procedure
Controlsi. Property
ii. Event Handlesiii. Methods
_ _______________________________________________Page No. 11
Microsoft Access (Back – End Tool)
Microsoft access is one of the words most popular relational databases.
Using access you can create sophisticated and powerful database to store entry forms, reports and quires.
Using the access database wizards, you can quickly created detailed database that handles a number of business and personal functionary such as order entry, contact management.
It none of the database template in the database wizard suits your needs or if you just wont to create a database forms scratch, you can easily do so as well.
The access table wizard offers an easy way to create yours own table. Access also provides step-by-step guidance as you create your database.
Once you create an access table, you can easily modify it by adding, deleting, moving, or removing table fields.
Access also includes a power find and replace feature that lets you quickly update large amount of table.
_ _______________________________________________Page No. 12
System Study
Feasibility Study: To check whether the system once created will be feasible or not. A feasibility study is undertaken to determine the possibility all probability of either improving the existing system or developing a completely new system.
Technical Feasibility: To technical feasibility, it is checked that if the work for
the project can be done with present equipments, software and available personnel.
_ _______________________________________________Page No. 13
Cost Estimation
The category of the system is “organic” for this a = 3.2 and b = 1.05 are constant.The size of the system is 2.5 kdl (thousand of delivered line of code).
Initial cost estimation ei = a * (size)b
= 3.2 * (2.5)1.05
= 8.375
Eaf is effort adjustment factor.Reliability is high 1.15Database size is normal 1.00Complexity is very low 0.70Programmer experience is very low 1.29Programmer capacity is normal 1.00Language experience is low 1.07Analyst catalyst is normal 1.00
Eaf = 1.15 * 1.00 * 0.70 * 1.29 * 1.00 * 1.07 * 1.00 =1.11Final cost = ei * eaf = 8.375 * 1.11 = 9.30 pm
_ _______________________________________________Page No. 14
_ _______________________________________________Page No. 15
Existing System
Introduction
The krishna corporation does not own any existing computerized system currently, but are willing to convert their manual system into computerized system. They do all their transactions annually through record books.
Existing system
In manual system, to add a new customer they have to add records in register.
Suppose customer leave the town or city, so their records should be deleted. They delete their records from master register, which is difficult.
If a customer wants to change his or her address, it is difficult to update or change his or her profile into register.
In manual system it is difficult to maintain the stock. When a customer comes for cylinder refills they have to first check
their validity. Then they will book his refill in the register, which is very time consuming.
In manual system they have to daily update the stock register. Difficulty to see how much cylinder customer, company or company
itself has. Existing system is manual system rather than computerized.
_ _______________________________________________Page No. 16
Problems With Existing System
Entry into different register is very time consuming process. Sometimes it leads to ambiguous records.
It becomes difficult to do the deletion and any modification in the master register.
Updating master register for daily transaction is very tedious job and also very time consuming.
Duplication of records may occur.
Stock management is difficult in using register.
In existing system they are using different types of registers for different purpose.
Work distribution can’t be made easily.
To check customer’s history is difficult.
Probabilities of errors in calculation of bills, stock management etc.
_ _______________________________________________Page No. 17
Introduction Of Proposed System
This system involves
When a customer request for a gas refills, first check for his validations, prepare bills and handle those bills to particular deliveryman for delivery.
This system maintains customer’s all type of records.
It handle customers all requests for booking, gas refills and to provide them in time.
It also includes preparation of different reports.
_ _______________________________________________Page No. 18
Objectives Of Proposed System
The basic objectives of the system are to help the krishna corporation in addition, deletion, updating of records, generating reports.
History checking easily done.
Accurate work.
Fewer people required.
To make the security high.
Daily transactions are easily handled.
Fast transactions.
Work distribution is easily done.
Generation of different kinds of reports.
Reduction in redundancy.
Easily find that how many no. Of cylinder company has.
Easily find that how many cylinders are empty.
Easily find stock reports.
Gives fixed rate of the customer.
_ _______________________________________________Page No. 19
Features Of Proposed System
Manual work has to be reduced and result to be received quickly. To speed up the operation and decrease manpower, high cost. Increase security, speed, storing and accuracy. The customers have to face only one person at the counter for booking
cylinder. Managing and maintaining data becomes easier and cost effective due
to very high amount and reliability of storage space available in the proposed system.
The system has been developed under microsoft visual basic 6.0 as a front-end and microsoft access as a back-end tool.
_ _______________________________________________Page No. 20
Scope Of The System
Maintaining customer information.
Maintaining stock information.
Maintaining cylinder refills information.
Delivery of refills information.
Preparation of reports.
Handle the fix rate of the customer.
_ _______________________________________________Page No. 21
Requirement Analysis
As we have decided to develop a new system now it is a time to determine the new requirement for the new system. As the user is the most important part of any system it is required to find the users requirement to develop a user friendly system rather than having develop a developer friendly system.
the outputs required by the user that must be included into the proposed system are as follows.
The work for he particular user must be personalized. The customer information must be entered on such a way that it
is easier for user to understand. Daily reports and monthly reports are printed. Bills are printed as in required order. The user must be provided ease if he wants to switch from one
application to other at a time.
_ _______________________________________________Page No. 22
Fact Gathering Techniques
A fact gathering study was undertaken to study the activities involved krishna corporation. I have visited various person of the company. The system was studied by means of
Interviews Record review
InterviewsUser interview were conducted to determine the
qualitative information. These interview, which were unstructured interview provide opportunity to gathered information from respondents who are involve in the process for a long time. These interview provide information such as
Activities involved in process o given system. Limitation of existing manual system. Type and frequency of reports.
Record review To gather details about the system, many kinds of reports were reviewed. This study covered
Standard operating procedure. Reports generated by existing manual system. Input /output of the system.
_ _______________________________________________Page No. 23
_ _______________________________________________Page No. 24
_ _______________________________________________Page No. 25
Data Dictionary
Data dictionary is a store of information about the data in database. The dictionary defines the name, description, source of data, users of data, and keywords in data, formula to derive the data specification and such other details. Data dictionary brings common understanding of the data in the organization RDBMS provides software to create the dictionary. Use of data dictionary enforces the standards of processing, usage’s application and documentation in the organization.
Data dictionaries are an integral component of structured analysis, since data flow diagram by themselves do not fully describe the information about the system. The data dictionary provides additional information about the system.Description of all data used in the system is given in a data dictionary.
Analysts Use Data Dictionary For Five Important Reasons.
1) To manage the detail in large systems.2) To communicate a common meaning for all system elements.3) To document the features of the system.4) To facilitate analysis of the details in order to evaluate characteristics and determine where system changes should be made.5) To locate errors and omissions in the system.
_ _______________________________________________Page No. 26
Data Dictionary
The files used for this project are
Customer_master Customer_rate Cylinder_master Recived_master Trans_master Type_master
Table Name : Customer_Master
Sr.No Fields Data Type Size Constraints Description1 Customer_No Number 2 Primary Key Customer number2 Customer_Name Text 35 Not null Customer name3 Customer_Address Text 100 Not null Customer address4 City Text 15 Not null Customer city5 Phone_No1 Text 20 Customer phone6 Phone_No2 Text 20 Customer phone7 Fax Text 20 Customer fax8 Mobile Text 13 Customer mobile 9 E_Mail Text 35 Email address10 Customer_Type Number 3 Valid(0,1,2) Type of customer
Table Name : Customer_Rate
Sr.No Fields Data Type Size Constraints Description1 Customer_No Number 2 Foreign key Customer number2 Cylinder_Type_No Number 5 Foreign key Cylinder number3 Rate Number 5 Default-0 Selling rate
_ _______________________________________________Page No. 27
Table Name : Cylinder_Master
Sr. No.
Fields Data Type
Size Constraints Description
1 Cno Number 10 Primary key2 Cylinder_No Number 10 Not null Cylinder number3 Cylinder_Type_No Number 5 Foreign key Cylinder type4 Cylinder_Status Text 10 Empty or Full5 Cylinder_Location Number 5 Foreign Key Location of cylin
Table Name : Recived_Master
Sr. No Fields Data Type Size Constraints Description1 R_No Number 10 Primary Key Received number2 Customer_Type Number 10 Foreign Key Customer type3 Date1 Date/Time Date4 R_Bill_No Number 10 Received bill no.5 Challan_No Number 10 Challan no.6 Note1 Memo Note if needed
Table Name : Trans_Master
Sr. No Fields Data Type Size Constraints Description
1 T_No Number 5 Primary Key Transaction no.2 Customer_No Number 5 Foreign Key Customer number3 Date1 Date/Time Date4 Invoice_No Number 5 Not null Invoice No5 Challan_No Number 5 Not null Challan No6 Vehicle_No Text 20 Vehicle No7 Sales_Tax Text 20 Sales tax8 Del_Amt Number 16 Delivery amount9 Total_Amt Number 10 Not null Net amount10 Note1 Memo Note if needed
_ _______________________________________________Page No. 28
Table Name : Type_Master
Sr.No.
Fields Data Type
Size Constraints Description
1 Cylinder_Type Number 10 Primary Key Cylinder type2 Cylinder_Type_Name Text 50 Cylinder type name
_ _______________________________________________Page No. 29
HIERARCHY CHART
_ _______________________________________________Page No. 30
GAS AGENCYSYSTEM
DELIEVERY TO
CUSTOMER
RECEIVED FROM CUSTOMER
STOCK MAINTAIN
DELIVERYTOCOMPANY
RECEIVEDFROMCOMPANY
_ _______________________________________________Page No. 31
1 LEVEL DFD FOR SECOND MODULE
2.1CHECK
FORCYLIND
ER
2..2Add no
infoEmpty list
2.3MADE CHALL
AN THE
CUSTOMER
CYLINDER_MASTER
CYLINDER_MASTER
GIVE EMPTYCYLINDER
EMPTY CYLINDERINFORMATION
DELIVERYINFORMATION
customer
CUSTOMER
CHALLAN GIVENTO CUSTOMER
ACKNOWLEDGEMENT
_ _______________________________________________Page No. 32
CONTEXT DIAGRAM
CUSTOMER
GASAGEN
CY
COMPANY
REQUEST FORFULL CYLINDER
ACKNOWLEDGE
REQUEST FOR FILL
CYLINDER
ACKNOWLEDGE OR RECEIVED
CYLINDER
CHALLAN INFO
ACKNOWLEDGEMENTT TRANS INFO
CYLIN INFO
RECEIVED INFO
CHALLAN INFO
ACKNOWLEDGEMENT
CYLIN INFO
CHALLAN INFO
TRANS. INFO
CHALLAN INFO CYLIN INFO
CYLIN INFO
RECEIVED INFO
_ _______________________________________________Page No. 33
0 LEVEL DFD
1.0Deli. Mod
to cust
2.0Empty cylin
recieved
CUSTOMER
3.0Stock
update module
4.0Delie modu
to company
5.0full
cylinrecieve
d
REQUEST FOR CYLINDER
ACKNOWLEDGETRANSACTION_MASTER
CYLINDER_MASTER
COMPANYGIVE FULL CYLIN
ACKNOWLEDGEMENT
ACKNOWLEDGEMENT
CHALLAN _MASTER
RECEIVED_MASTERGIVEN EMPTY CYLINDER
CHALLAN_MASTER
CYLINDER_MASTER
ACKNOWLEDGEMENT GIVEN EMPTY CYLINDER
CHALLAN _MASTER
TRANS_MASTER
CYLINDER_MASTER
AC
KN
OW
LE
DG
E
STOCK OFFICING
CHALLAN _MASTER
CYLINDER_MASTER
RECEIVED_MASTER
ACKNOWLEDMENT
INFO. OF EMPTY CYLIN.
STOCK INFO
STOCK INFO
TRANSACTION INFO
_ _______________________________________________Page No. 34
CUSTOMER
1.1Checking
idetification
module
1.2generatin
gMaster &
Challan bill
CYLINDER_MASTER
CYLINDER_MASTER
CUSTOMER
CYLINDER INFO
NO. OF CYLINDER INFO
CUSTOMERTYPE
TRANS_MASTER
DELIEVERED CYLINDERS BILLS
ACKNOWLEDGE
REQUEST FOR CYLINDEER
1 st Level DFD of 1 st module
CYLINDER INFO
CYLINDER INFO
_ _______________________________________________Page No. 35
1 LEVEL DFD FOR SECOND MODULE
2.1CHECK
FORCYLINDER
2.2ADD NO
INFOEMPTY LIST
2.3MADE
CHALLAN
FOR THE CUSTOME
R
CYLINDER_MASTER
CYLINDER_MASTER
GIVE EMPTYCYLINDER
EMPTY CYLINDERINFORMATION
DELIVERYINFORMATION
customer
CUSTOMER
CHALLAN GIVENTO CUSTOMER
ACKNOWLEDGEMENT
CYLINDER INFO
TRANSACTION INFO
CYLINDER INFO
_ _______________________________________________Page No. 36
I LEVEL DFD FOR FOURTH MODULE
4.1CHECKING &FINDING
EMPTYCYLINDER
4.1MAKE A LIST OFEMPTY
CYLINDER
CUSTOMER
CYLINDER_MASTER
EMPTY CYLINDERINFO
REQUEST FOR FULL CYLINDER
ACKNOWLEDGEMENT
TRANS_MASTER
CYLINDER_MASTER
DELIEVERY EMPTY CYLINDER INFO
ACKNOWLEDGE
CYLINDER INFO
CYLINDER INFO
_ _______________________________________________Page No. 37
1 LEVEL DFD FOR FIFTH MODULE
5.1CHECK
FORCYLINDER
5.2ADD NO INFO FULL LIST
5.3MADE
CHALLAN
FORTHE COMPANY
CYLINDER_MASTER
CYLINDER_MASTER
GIVE FULLCYLINDER
FULL CYLINDERINFORMATION
DELIVERYINFORMATION
COMPANY
COMPANY
CHALLAN GIVENTO COMPANY
ACKNOWLEDGEMENT
_ _______________________________________________Page No. 38
_ _______________________________________________Page No. 39
_ _______________________________________________Page No. 40
_ _______________________________________________Page No. 41
_ _______________________________________________Page No. 42
_ _______________________________________________Page No. 43
_ _______________________________________________Page No. 44
_ _______________________________________________Page No. 45
_ _______________________________________________Page No. 46
_ _______________________________________________Page No. 47
_ _______________________________________________Page No. 48
_ _______________________________________________Page No. 49
_ _______________________________________________Page No. 50
_ _______________________________________________Page No. 51
_ _______________________________________________Page No. 52
_ _______________________________________________Page No. 53
_ _______________________________________________Page No. 54