railway employee union system
Post on 11-Mar-2015
204 Views
Preview:
TRANSCRIPT
SOFTWARE PROJECT
RAILWAY EMPLOYEE MANAGEMENT
Signed by: Submitted by:Ms. Neha Gupta (Internal Guide)
Railway Employee ManagementSoftware Project 2009
Submitted for the partial fulfillment of the requirement
for the award ofBACHELOR OF BUSINESS ADMINISTRATIONBACHELOR OF BUSINESS ADMINISTRATION
(CAM)(CAM)
Submitted By:
UNDER THE GUIDANCE OFMs. NEHA GUPTA
CERTIFICATE
This is to certify that the project titled RAILWAY EMPLOYEE
MANAGEMENT is a bona fide work carried out by and in the
partial fulfillment of the requirement for the award of the degree of
BBA(CAM) from I.P. University, Delhi.
This project or any similar project on this topic has not been
submitted for any other examination and does not form part of any
other course undergone by the candidate.
Signature of Project Guide
Ms. Neha Gupta
CONTENTS
1. PROJECT OVERVIEW
2. OBJECTIVE/PURPOSE
3. PROBLEM DEFINITION
4. FEASIBILITY STUDY
o ECONOMIC FEASIBILITY
o TECHNICAL FEASIBILITY
o OPERATIONAL FEASIBILITY
5. SOFTWARE REQUIREMENT SPECIFICATION (SRS)
6. IMPLEMENTATION OF THE SYSTEM
7. TESTING
8. HARDWARE/SOFTWARE REQUIREMENTS
9. SNAPSHOTS
10. CODINGS
5. CONCLUSION
Acknowledgement
We would like to take this opportunity to express our gratitude towards all the people who have in various ways, helped in the successful completion of our project.
We must convey our gratitude to Ms. Neha Gupta for giving us the constant source of inspiration and help in preparing the project, personally correcting our work and providing encouragement throughout the project.
We also thank all our faculty members for steering us through the tough as well as easy phases of the project in a result oriented manner with concern attention.
Project Overview
Indian Railways abbreviated as IR is the state-owned railway company of India, which owns and operates most of the country's rail transport. It is overseen by the Ministry of Railways of the Government of India.
Indian Railways has one of the largest and busiest rail networks in the world, transporting over 18 million passengers and more than 2 million tonnes of freight daily. It is the world's largest commercial or utility employer, with more than 1.4 million employees. The railways traverse the length and breadth of the country, covering 6,909 stations over a total route length of more than 63,327 kilometres (39,350 mi). IR owns over 200,000 wagons, 50,000 coaches and 8,000 locomotives of rolling stock.
Railways were first introduced to India in 1853. By 1947, the year of India's independence, there were forty-two rail Managements. In 1951 the Managements were nationalised as one unit, becoming one of the largest networks in the world. IR operates both long distance and suburban rail Managements on a multi-gauge network of broad, metre and narrow gauges. It also owns locomotive and coach production facilities.
Objective/Purpose
The aims and objectives of the Union are,
1)To organise the employees of the South Central Railway and to regulate their relations with their employers.
2)To promote,protect,improve and safeguard the rights,interests,status and privileges of the South Central Railway employees by all recognised Trade Union methods.
3)To promote economic social cultural and political interests of the employees in alliance with the rest of the working class. To promote friendly feeling and foster a spirit of brotherhood,solidarity and cooperation amongst the railwaymen.
4)To improve efficiency of the railway services.
5)To maintain a Library and make propaganda for the better understanding of rights and obligations of Railwaymen.
6)To cooperate federate affiliate with orbeaffiliated to any Federation, Association, Union, Confederation or Society in India and abroad having kindred aims and objectives and All India Railway Men's Federation, Hind Mazdoor Sabha, and International Transport Worker's Federation.
7)To take part in any democratic and socialist movement for the general advancement of the working class.
PROJECT-CATEGORY
RDBMS (Relational database management system)
USER INTERFACE
GUI (Graphical User Interface) of the Software will be
implemented through Visual Basic.
TOOLS / ENVIRONMENT
Language : Visual basic
Back end : Oracle8
VISUAL BASIC
Visual basic covers every aspect of programming, from
educational applications to databases, and from financial
applications to Internet components. Visual basic has two-
database access technology.
To design desktop we can use VB-script, which is a subset of
visual basic, and object oriented technology. Visual basic have
several tools for automating the development of WebPages like
HTML & DHTML and development of web application.
Visual basic provides IDE (Integrated Development
Environment) and the basic principles of developing
applications with visual tools and event programming. A
project in visual basic is the central mechanism used to verify
and coordinate the elements of a visual basic application.
Creating project is usually the first step in the process of
developing a visual basic application. Project keeps track of the
locations of the components used within the project and access
related libraries of the program that are stored in a common
directory and used by many applications. An exe file is
generated in order to run the project. When an EXE is
generated from a project all the elements of the project are
gathered and run according to the action performed. ADOB is
V.B database technology used to access the data from the
databases.
ORACLE DATABASE DRIVER
Oracle database connectivity is used to connect V.B and oracle.
MDSQL is a set of API used for executing SQL statements.
ADOB consists of a set of classes and record set objects and
interfaces to enable programmer to make connections and to
write SQL statements.
CONNECTION
Connection between the database and the front-end
application is very important. Without a proper
connection errors may occur while saving the data in the
table. In my project I have used ODBC to connect my
front-end application with Oracle. For connection to
work properly I have to first create a service name using
Oracle Net Assistant. After creating the service we have
to create ODBC driver, with the help of which I will
connect to Oracle. While creating driver we have to
keep an account of the DSN (Data Source Name)
because while connecting to the Oracle we have to pass
DSN for connection.
PROBLEM DEFINITION
The definition of our problem lies in manual Management and a fully automated Management.
Manual Management : The Management is very time consuming and lazy. This Management is more prone to errors and sometimes the approach to various problems is unstructured.
Technical Management : With the advent of latest technology if we do not update our Management then our business result in losses gradually with time. The technical Managements contains the tools of latest trend i.e. computers printers, fax, Internet etc. The Managements with this technology are very fast, accurate, user-friendly and reliable.
.
Need of Railways ManagementA few factors that directs us to develop a new Management are given below -:1) Faster Management2) Accuracy3) Reliability4) Informative5) Employee s and cancellations from any where to any place
TECHNICAL MANAGEMENT
FEASIBILITY STUDY
Feasibility study is to check the viability of the project under consideration. Theoretically various types of feasibilities are conducted, but we have conducted three type of feasibilities explained as under.
ECONOMIC FEASIBILITYWith the manual Management the operating cost of the Management is about 60 Lacks P.A.. This cost comprises salary of 25 people, stationary, building rent, electricity, water, telephone etc. But with the new Management this reoccurring cost comes out
Railway Management
Promotion Employee Employee
TTTTIONTTTTION
RetiremenRetirementt
to be about 20 Lacks P.A. Hence the new Management is economically feasible.
TECHNICAL FEASIBILITYThe new Management requires only 6 trained person to work with the Management and in overall 10 people per office are sufficient. So we will identify 6 best people from existing Management and train them.
As our existing Management is purely manual, so we need a one time investment of Rs 4 Laks for the purchase of 7 computers, 5 Ticket printers, a laser printer, AC and networking etc. It requires 20 Lacks PA as a operating cost.
With the above details our Management is technically feasible as after investing 24 Lacks in a year, the company is still saving Rs 25 Lacks PA.
OPERATIONAL FEASIBILITY
The new solution is feasible in all sense but operationally it is not. The new Management demands the expulsion of at least 15 people from the company. It creates an environment of joblessness and fear among the employees. It can lead to an indefinite strike in the company also. So the management must take corrective actions prior in advance in order to start the further proceedings.
SOFTWARE REQUIREMENT
SPECIFICATION
System Analysis
System Analysis refers to the process of examining a
situation with the intent of improving it through better process and
methods. System analysis is, therefore, the process of gathering
and interpreting facts, diagnosing problem and using the
information to recommend information in system or in other
words, it means a detailed explanation or description. Before
computerizing a system under consideration, it has to be analyzed.
We need to study how it function currently, what are problems and
what are requirements that proposed should meet.
The main components of making software are :
1. System and software requirements analysis.
2. Design and implementation of software.
3. Ensuring verifying and maintaining software integrity.
Information Gathering The team paid a visit to a union meeting to have a smell of
existing system. All relevant personnel were consulted and no
information was over-looked. The strategy consisted of:
1. Identify information sources.
2. Revolving a method of obtaining information from identified
source.
3. Using information from module of organization.
Information SourcesThe main sources of information were:
1. Users of the system
2. Presentations an documents using organization
3. Prospectus, manuals and the rulebooks, which specify how
various activities are carried out in the organization.
4. Computer Presentation of existing system.
UNDERSTANDING THE EXISTING SYSTEMExisting system here is manual i.e. all the transaction or
information is recorded in the registers and as simple text files on
the computers. The person needy of particular information has to
go through the registers and the text files and then prepare the
information needed by him manually. Besides this, there are many
other drawbacks with the existing system which are listed as under:
Flexibility in generation of information : The generation of
information in the proposed system takes long time and they
are manually prepared.
Long time taken to draw conclusions : As individual files are
maintained for each information, it is very difficult to compile
information, measure performance over a period and draw
conclusions from the information stored in two different files.
User Friendliness : The system is not easy to learn and
understand. A native user cannot use the system effectively.
User Satisfaction : The system is such that it does not stand
up to the user expectations like easy and faster retrieval of
information.
Response Time : Being manually driven, the response of all the
operations is very slow.
Error Handling : In case there arise some error in recovering
or computation of information, it is very cumbersome to trace
it.
Safety and Robustness : The informative media is accessible
by everyone. As information being the most crucial for the
organization, there are no safety measures for the security of
information. Furthermore, information is lying in the
organization in an unorganized manner and does not resemble
the real world model.
Lack of Accuracy : Information being prepared manually
cannot be said as accurate which is the first and the foremost
condition for taking a crucial decision by the management.
More Time Consuming : Work carried out by the staff at
various stages is highly time consuming.
Error Prone Resources : Resources being used by the
informative media were provided by the organization long ago.
Due to wear and tear with the resources, they are highly error
prone.
PROPOSED SYSTEMAfter a detailed study of the existing system, it is evident that is
does not fulfill the objectives of the organization. To make the
objective possible for the organization, it is required to have a
computerized information system with the help of which all tasks
can be processed more accurately and quickly. To achieve this, it is
necessary to design and develop a new system which will have the
following benefits over existing system :
Flexibility in generation of information : The generation of
reports in the proposed system will take minimal time and they
are electronically prepared. As a result, it is highly accurate.
Less time is taken to draw conclusions : It will be easy for the
user(s) of the system to compile information at a very high
pace, measure the performance over a period and draw
conclusion form the information retrieved by using the
proposed system.
Ease in maintaining information : As new information are
being added to and released from their respective courses every
year, it will be highly user friendly to track and maintain the
presentation of all the students.
User satisfaction : The system is much that is stands up to the
user expectations like easy and faster retrieval of information.
Safety and Robustness : The system will be accessible by only
the authorized users. As information being the most crucial for
the organization, there are safety measures for the security of
information.
Furthermore, data is stored by the system in an organized
manner and resembles the real world model.
Highly accurate : Information being prepared electronically,
can be said as accurate which is the first and the foremost
condition for taking a crucial decision by the management.
Less time consuming : Work carried out by the staff at various
stages will be less time consuming.
Error free resources : Resources being used by the system will
be compatible with the latest technologies available in the
market. As proposed system uses highly technically compatible
resources, there will be very-very less wear and tear. So the
resources are error free.
Besides this, the proposed system will have the following
capabilities :-
Multiple viewer facility : Proposed system is being designed in
such a way that many users can have a view with the system
simultaneously. It makes effective and perfect utilization of
man power and resources.
User-friendly interfacing : Since main interaction of the
system will be with the user, the user interface will be
interactive and meaningful.
Formatted output : The information generated by the
proposed system us highly formatted and help the users to
reach the conclusion quickly.
Better organization of information : Proposed system has the
capability to express the information in a better and more
meaningful way. Proposed system uses modern techniques for
storage and retrieval of information.
Accurate round the clock : Proposed system is capable of
giving accurate information round the clock.
Exception Handling : To ensure that the system does not halt
in case undesired situation or events, the system capable
enough to handle these unpleasing circumstances. Proposed
system will be capable of taking necessary decisions so that
there is no loss information.
Minimum efforts : Proposed system ensures that very less
efforts will be required to start the presentation.
Capable of adapting to the changes in the outside
environment : The system will have scope to foresee
modification and enhancement i.e. it is able to cope up with the
business changes in-order to be compatible with the latest
changes in the industry. Any enhancement to the information
can be done without much effort and is available instantly.
IMPLEMENTATION OF THE SYSTEM
The overall software of Railway Employee Management
System is implemented using Visual Basic and Oracle-8. The
Visual Basic provides a perfect graphical user interface to
implement the employee union system into the forms to make
the system user friendly and interactive. The system is
implemented in forms, which are connected to oracle database,
which in its turn is used to held data or records for the further
details. Railway Employee Management System is
implemented into Visual Basic forms used to take input i.e.
details required for the system. Detail manipulation and
calculations are also performed via the forms and the
correspondent data is sent to the tables of the oracle database.
TESTING
System testing is vital to the success of the system. This phase
of the system development life cycle is immediately after the
coding phase. System testing takes a logical assumption that if
all parts of the system are correct, the goals will be
automatically achieved. Inadequate testing or non-testing leads
to errors that may not appear until months later. Another
reason for testing is its utility as user – oriented vehicle before
implementation since even best program is worthless if it does
not meet user requirements.
Testing which are performed on the system. They are as
follows:
UNIT TESTING
Data was separately prepared and tested for sub-modules of
database management system, under all relevant conditions.
This process helps in finding out the bugs if any. In the
software thereby requiring the rectification in the modules
again. Unit testing is for the program is done in parallel with
the construction of the programs. E.g. here in RAILWAY
EMPLOYEE MANAGEMENT SYSTEM all the modules are
tested separately. All interface testing, control flow testing is
done.
INTEGRATED TESTING
After the completion of errors at levels of unit testing for all
the programs in a module, the module is tested for integration
with other modules in the system. The goal of this testing is to
detect design errors, while focusing on testing the
interconnection between modules.
E.g. Here In this project all modules are integrated and then
tested as one.
SYSTEM TESTING
System testing tests the entire flow of data of data through the
entire system. Data flows from the tables were checked. This
also includes the preparation of test data, checking the entire
system with this data to see if all the requirements are met and
the system performs as specified by the requirements.
ACCEPTANCE TESTING
After the system testing is performed, finally acceptance
testing is performed to demonstrate to the client the operation
of the system on the real life data of the client.
e.g. here in RAILWAY EMPLOYEE MANAGEMENT
SYSTEM ,the programmer visited and explained about project
in detail. And showed all functionalities a working of the
project, then acceptance is taken from the client.
SYSTEM SECURITY MEASURES
AN EVALUATION OF RISK
The objectives, functions and performance of the system are
evaluated after analyzing the assumptions and dependencies of
the proposed system. The considerations made are
development risk, resource availability and technology. The
possible risks associated with the system are:
Unavailability of the skilled personnel to develop the project
on the web related technologies.
Unavailability of the hardware and software required to
develops the project.
Frequent leaves taken by the project team members
resulting in the delay of the project.
Unavailability of the technology to support the features
estimated of the project.
HARDWARE SOFTWAREPentium II to IV Windows-9x, 2000, 2000 ServerAttempt 200 MHz MS AccessRAM-32 MB MS ExcelH.D.Space: 4x GB MS Word
F.D.DCD ROM DRIVE-52x
Hardware/Software Requirements
SNAPSHOTS
FORM 1
FORM 2
FORM 3
FORM 4
FORM 5
FORM 6
CODING
FORM 1
Private Sub LAF_Click()
End SubPrivate Sub MLF_Click()
End Sub
Private Sub
End Sub
Private Sub
End Sub
Private Sub exit_Click()EndEnd Sub
Private Sub Image3_Click()
End Sub
Private Sub Form_Load()
End Sub
Private Sub leavea_Click()Me.Hideleave_app.ShowEnd Sub
Private Sub n_employee_Click()
Me.Hideemployee.ShowEnd Sub
Private Sub ret_form_Click()
End Sub
Private Sub Objectives_Click()Form1.Show
End Sub
Private Sub pf_Click()Me.Hidepromotion.ShowEnd Sub
Private Sub Sub_Click()Me.Hidesubscription.ShowEnd Sub
FORM 2
Public Function SFIND(N As Double)
End FunctionPublic Sub ADD()
End Sub
Public Sub assigntext()
End SubPublic Sub EDIT()
End Sub
Public Function RSFIND(N As Double)
End FunctionPublic Function FINDS(SS As String)
End Function
Public Function RMFIND(N As Double)
End Function
Private Sub CommandButton1_Click()Adodc1.Recordset.AddNewEnd Sub
Private Sub CommandButton2_Click()Adodc1.Recordset.UpdateMsgBox ("Recordset Saved")End Sub
Private Sub CommandButton3_Click()Adodc1.Recordset.CancelUpdate
End Sub
Private Sub CommandButton5_Click()Adodc1.Recordset.DeleteAdodc1.Recordset.MoveNext
End Sub
Private Sub CommandButton7_Click()Me.Hidemain.ShowEnd Sub
FORM 3
Private Sub CommandButton1_Click()Adodc1.Recordset.AddNew
End Sub
Private Sub CommandButton2_Click()
End Sub
Private Sub CommandButton3_Click()Adodc1.Recordset.UpdateMsgBox ("Your Subscription has been Updated")End Sub
Private Sub CommandButton4_Click()Adodc1.Recordset.CancelUpdate
End Sub
Private Sub CommandButton5_Click()
End Sub
Private Sub CommandButton6_Click()Me.Hide
main.Show
End Sub
Private Sub Form_Load()
End Sub
FORM 4
Private Sub Command1_Click()Me.Hidemain.ShowEnd Sub
Private Sub Form_Load()
End Sub
FORM 5
Private Sub CommandButton1_Click()Adodc1.Recordset.Update
End Sub
Private Sub CommandButton2_Click()Me.Hidemain.ShowEnd Sub
Private Sub Form_Load()
End Sub
FORM 6
Private Sub Text5_KeyUp(KeyCode As Integer, Shift As Integer)
End SubPrivate Sub Text6_KeyUp(KeyCode As Integer, Shift As Integer)
End Sub
Private Sub Text7_GotFocus()
End Sub
Private Sub Text7_LostFocus()
End SubPublic Function RSFIND(N As Double)
End Function
Public Function RMFIND(N As Double)
End FunctionPublic Sub assigntext()
End Sub
Private Sub Command1_Click()Me.Hidemain.Show
End Sub
Private Sub Command2_Click()Adodc1.Recordset.AddNewEnd Sub
Private Sub Command3_Click()Adodc1.Recordset.UpdateMsgBox ("Recordset Saved")End Sub
Private Sub Form_Load()
End Sub
TABLE STRUCTURE
EMPLOYEE
Name TYPE
Emp id Number
Emp Name VARCHAR2(30)
Community VARCHAR2(30)
Designation VARCHAR2(10)
Department VARCHAR2(10)
Ticket No. Number
PROMOTION
Name TYPE
Emp id Number
Emp Name VARCHAR2(30)
Community VARCHAR2(30)
Designation VARCHAR2(10)
Department VARCHAR2(10)
Comments VARCHAR2(50)
SUBSCRIPTION
Name TYPE
Emp id Number
Emp Name VARCHAR2(30)
Recipient
No.
VARCHAR2(30)
Fees Number
Designation VARCHAR2(10)
LEAVE
Name TYPE
Emp id Number
Emp Name VARCHAR2(30)
Designation VARCHAR2(10)
Department VARCHAR2(10)
No. of Days Number
Reason VARCHAR2(50)
CONCLUSION
A package can be only developed successfully if the project team has a widespread understanding about the nature of problems faced by the employees and members of the union. Obviously, the project team members try to tackle each and every problem regarding the coding in the project. It is evident most of the time; it is not possible to make such package that can solve all the problems: some bugs are always there.
Railway Employee Management System is completely user’s friendly system which can be access by a person having not much knowledge of computers. The railway employee management system looks for the requirement related to the members & employees and also provide some of the security features. It will be unjustified if it is claimed that this project is complete in all respects. Therefore this project has certain limitations and persuades us to provide perfection to this system.
*******
top related