AKNOWLEDGEMENT We have the great pleasure In submitting this project report on “Setu Nagrik Suvidha kendra” of Setu prakalp of Taloda, tal:taloda,dist:-Nandurbar. 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. INDEX CHAPTER PERTICULAR PAGE NO. NO. 1. AIM OBJECT SCOPE PROBLEM DEFINATION 2. NEED OF COMPUTERIZATION HISTORY OF ORGANISATION EXISTING SYSTEM ADVANTAGE OF COMPUTERISATION 3. FEASIBILITY STUDY ECONOMICAL FEASIBILITY STUDY TECHNICAL FEASIBILITY STUDY BEHAVIORAL FEASIBILITY STUDY 4. INTRODUCTION OF MS-VISUAL STUDIO 2005 INTRODUCTION OF MS-ACCESS 5. PRELIMINARY DESIGN OF THE PROPOSED SYSTEM DATA DESIGN PROCEDURAL DESIGN ARCHITECTURAL DESIGN 6. DETAIL DESIGN OF PROPOSED SYSTEM DATA DICTIONARY 7. TESTING UNIT TEST SYSTEM TEST 8. SYSTEM IMPLEMENTATION 9. REQUIRED DETERMINATION TECHNIQUES 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. 2) OBJECTIVES:- The main objectives of the system are to maintain form sales , certificate issue and record maintenance of the setu prakalp. 3) PROBLEM DEFINATION:- 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 resources. *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 system. 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 run. 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 enterprise. 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 relationship. 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. THE ADO.NET DATA ARCHITECTURE:- 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 forms. Actual this system is use for the:- What is SETU ? SETU ( “ NAGRI SUVIDHA KENDRA” )is a 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 headquarters. 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 application. 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 friendly. 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 *Testing:- 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. *SYSTEM IMPLEMENTATION:- 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. THE PHASE OF SYSTEM IMPLEMENTATION OF 1. IMPLEMENTATION PLANNING:- 2. EDUCATION AND TRAINING 3. SYSTEM TESTING 4. FILE SETUP AND CONVERSION 5. CHANGEOVER 6. AMENDMENT PROGRAM TESTING AND USER ACCEPTANCE:- 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. *SYSTEM TESTING CONSISTS OF FOLLOWING STEP‟S:- 1. Program Testing 2. String Testing 3. System Testing 4. System Documentation 5. User Acceptance Testing ACCEPTANCE PROCEDURE 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 organization. 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. POST IMPLENTATION REVIEW:- 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. REQUIRED DETERMINATION TECHNIQUES:- 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:- 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 IN DEVELOPING THE PROTOTYPIN THE FOLLOWING COMPONENTS TO BE PREPARE:- 1. Command language dialog or conversation between user and system 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. CONCLUSION:- 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.