Copy of setu project report

Document Sample
Copy of setu project report Powered By Docstoc

        We have the great pleasure In submitting this project report on
“Setu    Nagrik    Suvidha    kendra”   of   Setu    prakalp   of     Taloda,
        We are take opportunity to show our deep-set gratitude to
Director of IMRD(Institute of Management Research and Development)
Respected Mrs.Vaishali Patil for the timely kind co-operation and
providing required facilities for our project.
        Our special acknowledgement to our prof.Manoj Patel(H.O.D)
and our project guide Prof.Jaypalsingh Rajput for his timely
suggestion, help, guidance and encouragement during the project.
        We are also thankful to the Prof.Manoj Patil, Prof.Vinod Shimpi,
to give us kindly support in completion of our project. It would be
wrong on our part if we forget to mention those who had a big hand in
the successful completion of our project. I must pay our cost sincere
indebtedness towards all staff members without help, this project would
have much more difficult to complete. We also thankful to my friends.
        The biggest thanks to Mr.Rakesh Ratilal Gurav for giving us
great opportunity to develop their system as a computerized system.
                                                    Bohari Huzaifa F.
                                                    Gurav satish B.
CHAPTER                  PERTICULAR                  PAGE
  NO.                                                 NO.
   1.     AIM




          DATA DESIGN

  7.      TESTING

          UNIT TEST
          SYSTEM TEST
  9.      REQUIRED                DETERMINATION
  10.     CONCLUSION
                            INSTITUTE PROFILE
       IMRD, shirpur has started functioning in 1997 by offering an professional
M.C.A and M.B.M Postgraduate program of the N.M.U. Jalgaon. Today IMRD has
developed one of the finest management & IT education Institute in North
Maharashtra. IMRD has excellent academic & placement record, with students of
M.C.A and M.B.M program consistently appearing in the merit list of N.M.U. &
also being placed in the premier companies of the services & the industrial sector of
our country & abroad.

Tryst with dynamism:-

       Information Technology is undergoing a sea change in today‟s fast paced
world. You could see a wonderful mixture of intelligent and technical skill
development in our institute.
       We pray Goddess Sarsaswati to shower beneficiation on this Institute that it
may be a torch bearer in field of Management and Computer Application.

Our Mission is:-
       1) To impart high quality technical education through innovative and in
          interactive learning process & high quality internationally recognized
          instructional program.
       2) Preparing students from diverse background to have aptitude for
          research & spirit of professionalism.
       3) Inculcating in students a respect for fellow human beings & responsibility
          towards the society.
                                     Chapter 1.

1) AIM:-

      To develop the computerized setu nagari suvidha system for
taloda tahsil.


       The main objectives of the system are to maintain form sales ,
certificate issue and record maintenance of the setu prakalp.


     The problem with the existing manual system is the record
department of the setu prakalp finds it very difficult to give the various
customer the exact detail about the record of setu system.

      And the existing system was not fully prepared for every type of
report like the details by the form /certificate type.
                                     Chapter 2

A) Advantages of the computerization
B) Needs of computerization
C) History of organization
D) Existing system

A) Advantages of the computerization

      Most organization carry out the large and wide variety of the
daily transaction. Accurate recording and processing. Today some
degree of automation exists in all organization In recording and
processing of daily transaction.

      The clerical system designed were ideal to take care of average
loads of posting transaction as the number of transactions in a month
were hundreds it was possible to close accounts and data entry and
know the performance of business at the end of the month as at the end
of the year.when organization grew,manual system began to break
down, thus hampering management in the primary tasks of planning
contract. Thus there was a need to keep the clerical cost low and to
increase the efficiency of processing transactions.

      In modern age, in the field of science and technology and now we
entered in 21st century or in the world in computer age.

      For setu prakalp is a blessing and can serve much better and
faster the information retrieval system will be very easy.
Computer are known for their ability to store vast amount of
information , capability of computing at externally fast speed and
processing the computer to handle textual information has attracted the
attention of the setu.

       In setu-prakalp the record department has to keep records for
lifetime for all the customer because this is the legal record. So
computer can help in sharing the information and workload very
effectively , thereby relieving the professional staff for developing their
time to move productive job like collection development and for
providing variety of user services.
B) Needs of computerization

      Any organization found that they could computerize the
transaction processing track quality by using standard software. The
major advantage of such software are:-

i) Time saving/minimized delays.
ii) Exact performance/improved accuracy.
iii)Lower clerical costs.
iv) Simple for handling.
v) Easy for record maintaining.
vi) Easy for any type of search

i) Time saving/minimized delays:-

      In setu lots of transactions take place everyday. Recording of all
transactions quickly and correctly is possible with the help of computer.

ii) Exact performance/improved accuracy:-

      In manual system, accuracy was low because of computational
errors and in ability to process some transactions or errors committed
due to fatigue in repetitive clerical tasks.

iii) Lower clerical costs:-

      In the development countries where clerical manpower is costly,
computerization Is necessary. In developing countries like INDIA, the
economics of data processing Is against computerization. clerical
manpower is cheap and the hardware and software is expensive.Yet
data processing has taken roots because there is an unmistakable trend
towards increasing manpower cost and reducing hardware prices.

iv) Simple for handling:-

      With the help of computerization it became easy to handle the
data and carry from one place to another because the data is saved in a
floppy disc.
v) Easy for record maintaining:-

       By computerization of setu prakalp system searching becomes
easy. In this system searching is done through codes as well as dates.

vi) Easy for any type of search:-

      By computerization any type of record maintaining is very easy
for receptionist or operator , e.g:- how many customer are making the
transactios? How many form are sales and purchased?

Existing system:-
                                     Chapter 3
*Feasibility study:-

1) Economic feasibility
2) Technical feasibility
3) Behavioral feasible study

*Feasibility study:-

      Feasibility study is second stage in system development life cycle.
A feasibility study is a test of system proposal according top the
violability. Impact an organization to meet users and effective use of

*Feasibility study involves:-

1) Economic feasibility:-
2) Technical feasibility
3) Behavioral feasible study

1) Economic feasibility:-

      Economical feasibility is the most frequently used method for
evaluation of the effectiveness of proposed system.
      Cost benefits analysis is the most commonly used procedural for
this feasibility benefits and savings are determined from proposed
system and compare with cost.

*Different types of cost are considered:-

i). Man power
ii). Hardware cost
iii). Operating cost

i). Man power:-

      Our proposed system can be easily communicate with department
such as office department ,computer department so that less manpower
is required to maintain system.

ii). Hardware cost:-

     Organization has the computerization network system, so the
hardware cost is buying and maintains office xp/windows seven.

iii). Operating cost:-

      Commonly has sufficient manpower that can operate computer
very easily, so that operating cost of our proposed system is the training
cost of the staff for learning xp/windows seven.

2) Technical feasibility:-

      In technical feasibility a study of function performance
constraints that may affect the ability to archive an acceptable system
are considered. Technical feasibility centers around the existing
computer system and of what extent it can support the proposed

      In the proposed system, networking is required which is already
available with organization and software requirement is of SQL-Server
with Visual Basic .Net which organization has to buy.

3) Behavioral feasible study:-

      Generally people are inherently resistant to change and
computers gave been known to feasibility change. Behavioral feasibility
deals with how strong a reaction.
                                        CHAPTER 4.
*System Development:-
  1 Introduction to VB.NET:-

            visual basic .Net is a Microsoft‟s Visual Basic on their.Net framework.
    Visual Basic is an object oriented programming language. Any programmer
    can develop application quickly with Visual Basic .It is a very user-friendly
    language. All you have to do is arrange components using visual tools and
    then write code for the components. Most programmers of Visual Basic use
    Visual Studio fir their development needs. Moving forward, Microsoft‟s
    .NET framework is composed of preprogrammed code that users can access
    anytime. This preprogrammed code is referred to as the class library . The
    programs in the class library can be combined or modified in order to suit
    the needs of programmers. Programs in .NET run on the CLR or the
    Common Language Runtime environment. Regardless of computers, as long
    as this environment is present, programs developed in a.NET language will

  2 Purpose of VB.NET:-

            Before VB.NET, there was VB and before there was VB, there was
    BASIC. BASIC stands for Beginners All purpose Symbolic Instruction Code.
    It was developed in 1963 by computer scientist John Kemeny and Thomas
    Kurtz in Dartmouth College. It was a general purpose programming
    language that was intended for beginners. In 1975 when the MITS Altair
    8800 Microcomputer was released BASIC became Altair BASIC, developed
    by the computer heavyweights Bill Gates and Paul Allen. During the eighties
    computer language started to lose its hold on the market because more and
    more people corporation were using computer programs for complex task
    rather than simple and “basic” task. In 1991. BASIC was in used with its
    visual components and became visual basic. The new graphical user interface
    was pioneered by Alan Cooper . Visual Basic was not an instant hit at first
    due to compatibility issues but it began getting a solid following in the mid to
    late ninetees when developers started becoming familiar with it. In new
    millennium , the visual Basic.NET became the successor of the visual basic
    programming languages.

    *Advantages of visual basic .Net over vb.6.0:-

       1. Consistent Programming Model:-

                  Different programming languages have different approaches
           for doing a task. E.g, accessing data with a vb 6.o application and
   VC++ application is totally different. When using different
   programming languages to do a task, a disparity exist among the
   approach developers use to perform the task. The difference in
   techniques comes from how different languages interact with the
   underlying system that applications rely on.
2. Direct support to security:-

          Application that resides on a local machine and users local
   resources is easy. In this scenario, security isn‟t an a scenario security
   is much more important as the application is accessing data from a
   remote machine.

          With ,NET, the framework enables the developer and the
   system administrator to specify method level security; it uses
   industry-standard protocols such as TCP-IP, XML.SOAP and HTTP
   to facilitate distributed application communication , this makes
   distributed computing more secure because .NET developers
   cooperate with network security devices instead of working upon their
   security limitations.

3. Simplified Development Affords:-

          Lets take a look at this with web applications . with web
   application. With classic ASP, when a developers need‟s to present
   data from a database in a web page, he is required to write the
   application logic(code) and presentation logic(design) in the same file.
   He was required to mix the ASP code with the HTML code to get the
   desired result.

          ASP.NET and the .NET Framework simplify development by
   separating the application logic and presentation logic making it
   easier to actual code (application logic) separately eliminating the
   need to mix HTML code with ASP.NET can also handle the details of
   maintaining the state of the controls, such as contents in a textbox,
   between calls to the same ASP.NET page.

3. Easy Application Deployment And Maintenance :-

          The .NET Framework makes it easy to deploy applications. In
   the common form, to install an application, all you need to do is copy
   the application along with the components it requires into a directory
   on the target computer. The .NET Framework handles the details of
   locating and loading the components of an application needs, even if
   several versions of the same application exist on the target computer.
   The .NET Framework ensures that all the components the application
   depends on are available on the computer before the application
  begins to execute.

5. Build Robust Windows-Based Application:-

         With new windows Forms, developers using Visual Basic .NET
  can build Windows-Based applications that leverage the rich user
  interface features available in the windows operating system. All the
  rapid application development (RAD) tools that developers have come
  to expect from Microsoft are found in Visual Basic.NET, including
  drag-and-drop design and code behind forms.

  *What is database?
         A database consist of a collection of interrelated data and set of
  programs to access those data. The collection of data that is usually
  referred as the database. Contains information about one particular

          The primary goal of database is to provide an environment
  that is both convenient and efficient to use in retrieving and storing
  database information.

         Database are design to manage large bodies of information.
  The management of the data involves both the definition of structure
  for the storage of information and the provision of mechanism for the
  manipulation of information.

  *What is MS-ACCESS?

         MS-ACCESS is a default database in VB.NET even you don‟t
  want to create an object. Although it have limited capabilities that is
  deals with small scale projects only it is not suitable for large scale
  industrial projects. Still it is so easier to use, create tables, insert
  records, update records, delete records and also keeping the

          You can easily migrate from access to oracle or sql server also,
  so it sufficient for our project.

         The ACCESS program act as database management system
  and looks after all the physical data storage and retrieval for use.
  Access handles all of the details. If vb.Net is on machine then we can
  store and retrieve data from any access database that is a database
  with a .mdb extension that was created by using the access
application. The reason for this is that vb.NET has facilities built in it
to allow it to communicate directly with ms-access database even
without the access programmed there to act as intermediately.
Dynamic link library is a file which is used to store prewritten and pre
tested programmed dll in our own programmed by including a
reference to it. This gives us access to the functionality of the dll
without having to physically include the code in our own program.


      ADO.NET in data access in ADO.Net relies on two components
are Data set and data provider.

1) Dataset:-
       The Dataset is a disconnected, in memory- representation of
the data. It can be considered as a local copy of the relevant portion of
the database the dataset is the persisted in memory and the data in it
can be manipulated and updated independent of database.

2) Data Provider: -

        The Data provider responsible for providing and maintaining
the connection to the database. The .Net Framework currently comes
with two data providers: The SQL Data provider which is designed
only to work with Microsoft‟s SQL Server 7.0 or later and the OleDb
Data Provider which allows us to connect to other types of databases
like access and oracle.

      Each Data Provider consist of the following component classes
The connection object which provides a connection to the database
The command object which is to execute the command
The Data Reader object which provides a forward only, read only,
connected RecordSet.

       The Data Adapter object which populates a disconnected
dataset with data and performs updates.

*Component classes that make up the Data Provider:-

1)     The Connection Object:-

     The Connection object creates the connection to the
database. Microsoft Visual Studio .NET provides two types
of Connection Classes:
    i)    SqlConnection Object
    ii)   OleDbConnection Object.

2) The Command Object:-

      The Command Object is represented by two
corresponding classes: sqlCommand and OleDbCommand
objects are used to execute commands to a database across
a data connection.

3) The DataReader Object:-

      The DataReader object provides a forward-only,
read-only, connected stream RecordSet from a database.
Unlike other components of the Data Provider, DataReader
objects cannot be directly instantiated.

4) The DataAdapter Object:-

     The DataAdapter is the class at the core of
ADO.NET‟s disconnected data access. It is essentially the
middleman facilitating all communication between the
database and a DataSet.

      Visual Basic.NET is Microsoft‟s Visual Basic on their
.NET Framework. Visual Basic is an object oriented
programming language. Any programmer can develop
application quickly with Visual Basic. It is a very user-
friendly language. All you have to do is arrange components
using visual tools and then write code for the components.
Most their development needs.

Drawbacks of The Previous Setu System:-

      This system worked very well but not in proper
manner. Means which reports management expect from
this system, it not be possible to provide the report which
management expect. The system also having with problems
like some validations not having the system and therefore it
is critical to use. Therefore we developed the setu nagari
suvidha system by using the Visual Basic .net for front-end
and Microsoft access for the back-end purpose. It was also
problematic in some calculations about the selling of the

Actual this system is use for the:-

What is SETU ?

complete Single Window System, which processes the
applications received at the facility center, verifies them and
generates the respective Certificates/Affidavits. The system
has a provision wherein the operator can punch in all the
details of the applicant whenever he receives an application
for a Certificate or an Affidavit.

       The System generates Acknowledgement Receipt for
the citizen indicating the issuance date. The application will
then be automatically forwarded to the respective authority
for verification. Once the application is verified and
accepted, the system will automatically generate the
required certificate /Affidavit. In case an application gets
rejected, the system will generate Rejection Note indicating
the reason for Rejection.

       This methodology will also facilitate kiosks in the
private       sector.       These       provide       services
of issuing various certificates (about 83 types) such as Birth
Certificate, Death Certificate , Domicile, Age, Nationality
Certificates on nominal charges.

Mission :-

     To create foundation for citizen centric E-Governance
at district headquarters & subsequently at taluka
             History :-

                    The Government of Maharashtra issues a large
             number of Certificates and Affidavits required by its
             citizens. For this purpose, it has various Citizen Facility
             Centers established at District as well as The Taluka level
             all over Maharashtra .

                   The citizen applies for the Certificate/Affidavit as
             required by him at such a Facility Center by filling up the
             relevant application forms. The respective authorities issue
             the Certificates or Affidavits after verification of the

             AIMS To Achieve :-

         - Transparency
             - Public Accountability
             - Responsiveness
             - Speed in Decision Making
             - Openness
             - Fast working

             Limitations of the Existing System :-

                   Most of the work is manual and hence the entire
                   process is time consuming.

                   No centralization of data and hence redundant data
             may          exist         in        the         database.
             Important data regarding the applicant may not be
             captured from the various documents that are attached
             along       with         the       application       form.
             No                   structured                 workflow.
             Current status of any application cannot be tracked easily.

             Objectives :-
       Single window clearance of 83 important certificates
(such as renewal of leases ,permits and licenses) Quick
redresser of public grievances, Common registry of letters ,
Petitions for all selections of the office , on line pendency
monitoring of all the above to provide services after office
hours and on holidays also in order to save time & money of
the public.

Software Specifications:-

- Operating System :-WindowsXP.
- Front-End :-Microsoft Visual Basic.Net
- Back-End:-Microsoft Office Access 2003
                          chapter 6

  *Preliminary design of system:-

      Preliminary design related with transformation of
requirement into data. Data design define the data structure.
Architecture design gives the relationship among the major
structural element of the program. Procedural design transforms
structural element into procedural description of the software.

1) Data Design:-

     It is the first activity during the software development. The
  activity during the data design is to select logical
  representation of data structure analysis, it consist of
     A. Input Design :-

              Input design is important for data design phase. It
        consist of Data Entry Screen which can be the operated

     B. Output Design:-

             Output Design of our proposed system in report
        forms, which can find conclusion.

     C. Logical Database Design:-

             Logical Database Design is any system is better if
        system is well studied. The objectives are the well
        defined an appropriate program tools are chosen.

2) Procedural Design:-
         Procedural Design occurs after data program structure
  is in English.
         Procedural design requires defining algorithmic details
  of the procedural, which can be represented in natural
  language like /English.

        Graphical tools such as flowchart or block diagram
  which provides excellent patterns back readily defines
  procedural design. Flowchart is most particular graphical
  representation of procedural design.

3) Architectural Design:-

        Architectural design is to develop a modular program
  structure and represents the control relationships between
  modules Architectural design is to develop a modular
  program structure and defines interface-enabling data to flow
  throughout the program.
                            Chapter 7


         Ensuring the availability and completeness of all work,
   items needed for acceptance test data unit test data.

         It is developed during actual phase design and purpose use
   to describe how system criteria established during analysis phase.

1) Objective Of Testing:-

   a) Testing is done, by executing system and find out errors occurs
   in it.
   b) A successful test is that if any mistake or error occurs it gives
   the message what you to do. Testing is done, by executing system
   and find out error occurs in it.

 2) Testing Is Done By:-

   a. Unit Test
   b. System Test

A) Unit Test:-

   This is phase of testing it includes modules in which each module
   is tested separately. By giving the test input and categorized of the
   programmer will typically perform on program.

      1) Functional Test:- Case involved the exercising the code with
         nominal input values for which expected result is not.

      2) Performance Test:-Determine the amount of execution time
         spent in various part of input.
     3) Stress Test:- Stress Test is those test design to intentionally
        break the units. A great deal can be learned about the
        strength and limitation of the programmer by examining
        the manner in which unit breaks.

     4) Structure Test:- Are connecting with the exercising internal
        logic of program. The major activity in structure test are
        deciding which path to exercising , determine test data to
        exercising those path determining test coverage be achieve
        when test cases are exercise.

B) System Test:-

        System Testing involve two activities:-

     a. Integration Testing
     b. Acceptance Testing
                       Chapter 8.


            Once the physical system has been designed in detail, next
     step is to turn the design into a working system and then to
     monitor the operation of the system to ensure that it continuous to
     work efficiently the implementation step of a project is often very
     complex and time consuming because the more people are involve
     them in the earlier stage. Thus part examine the issue involved.


     5.   CHANGEOVER
     6.   AMENDMENT


         System testing is the stage of implementation, which is aimed
  at ensure that the system works accurately and efficiently and
  effectively before the live operation commences.

         A new design system has all the system working order but in
  reality, each peace work independently. Now is the time to put all the
  pieces into one system and test it to determined whether it meets the
  user requirement this is the last choice to detect and correct error
  before the system is install for user acceptance testing. The purpose
  of system testing is to consider all likely variation to which it
  subjected and then the system to its limits. System testing makes a
  logical assumption that if all the part of thesystem are correct, the
  goal will be successfully achieved.

1.   Program Testing
2.   String Testing
3.   System Testing
4.   System Documentation
5.   User Acceptance Testing


   The system is completely tested and the training to the user staff is
given. The system runs parallel with current manual system. The
result of the computer system and the manual system are compared.
The analysis of comparison is made by users. The result of
comparison is satisfactory and thus the system is accepted by the

   After the acceptance of the system by the organization system
related documents are given to them. The information regarding the
system password is given respective person.

    After the system is implemented and conversion is complete a
review should be concluded to determined whether the system is
meeting exception and where improvement are needed system
quality, user confidence and operating static are accessed through
each technique. As event logging impact evaluation and attitude
survey. The data collection methods used during analysis are equally
effective during the post implementation review. The review not only
accessed how well to current system is design and implantation, but
also is a valuable source of information that can be applied to the
next system project
   Since, the computerized system is at present in the
implementation report stage in figure of proper car‟s will be taken
for satisfactory maintenance of the system and periodic review
system enhancement and user satisfaction.
                            Chapter 9.


       Requirement determine involves studying the current business
system to find out how it work and where improvement should be
added system studies results in evaluation of how current methods
are working and where adjustment are necessary or possible. These
study consider both manual and computer methods as requirement
is a feature that must be included in a new system. It may include a
way of „computing and processing data, producing information
control in business activities or supporting to management. The
determination of requirement thus entails studying the existing
system collection the details about it to find out what these
requirements are any system has its own techniques through which
the process follow without whose the complexities arises in handling
system. Hence some require determination technique may follow.

1.   Handling of Software
2.   Hardware Knowledge
3.   System Environment
4.   Feasibility Techniques of System
5.   Interacting With The System


   Prototyping recognize problem of cognitive and uses advance
computer technology. It advocating building a simple through trial
error and refining it through and interactive process. It includes:-

1. Identify the user information and operating requirements
2. Developed a working prototype that on only the main important
   functions, using a basic database.
3. Allow the use a prototype, discuss require changes and make the
   most important changes.

     Repeat the text versions of the prototype, with future changes
     incorporated until the system fully meets and users requirement,
     prototype and advantages system developed have been
successfully in wise accurate user requirements and greater user
participant and support character of prototype:-

1. Prototyping is Live working applications is a test out
   assumption made be analysis and user about requirement
   system features.
2. The proposed of prototyping is to test out assumption made be
   analyst and user about require system features.
3. Prototypes are created an interactive process
4. Prototype involve through an interactive process
5. Prototypes are relatively inexpensive to build


1. Command language dialog or conversation between user and
2. Input screen and formats
3. Essential processing modules
4. System output

       Within the developed computerized sales service system. I
have been generate the screens and screen related formats for the
data entry and develop the reports required for the organization
as per their demands. I have also satisfying the coding procedure
within the computerized i.e we follow all the prototype functions
at the time of developing computerized system.
                  Chapter 10.


      System depends on the result of system phase in system
development the result of each integrated quality reliability.

     The quality include the modularity, the maintainability,
good documentation user friendliness etc.

      Since visual Basic. Net provide the facility of system
security unothorized person cannot handle our system so less
changes of failure in data which indicates reliability. Our system
is developed in Visual Basic .Net. which GUI indicates attractive
and user friendly.

      System is split into different modules, each module specific
task. We tried to give appropriate message to user, so that user
can operate it very well and less change of mistakes.

Shared By: