Testing is a process of executing a program with the intention of finding an error.A successful test is in that uncovers an undiscovered error.If testing is conducted successfully according to the objectives stated above, it will uncover errors in the software. Also, testing demonstrates that software functions appear to the working according to specification, that performance requirements appear to have been met.
SYSTEM TESTING
System testing is a critical aspect of Software Quality Assurance and represents the ultimate review of specification, design and coding. Testing is a process of executing a program with the intent of finding an error. A good test is one that has a probability of finding an as yet undiscovered error. The purpose of testing is to identify and correct bugs in the developed system. Nothing is complete without testing. Testing is the vital to the success of the system.
TYPE OF TESTING
Unit Testing.
Module Testing.
Integration Testing.
System Testing.
Unit Testing
Unit testing focuses first on the modules in the proposed system to locate errors. This enables to detect errors in the coding and logic that are contained within that module alone. Those resulting from the interaction between modules are initially avoided. In unit testing step each module has to be checked separately.
Module Testing
Module testing is a process of testing the system module by module,what are all the input given and what are all the output produced & whether they are required.By testing in this method it would be very clear of the bugs occurred. In this system there are six modules namely Administration,Survey Authoring and Design,User management,Survey, and SMS Survey .By going through these modules bugs were identified.
Integration Testing
The strategies for integrating software component into a functioning product include the bottom-up strategy, the top-down strategy and send which strategy careful planning and scheduling are required. To ensure that modules will be available for integration into the evolving software product when needed.The integration strategy dictates the order in which the modules must be available and thus exterts a strong influence on the order in which the modules are written,debugged and unit tested.
System Testing
System testing does not test the software as a whole, but rather than integration of each module in the system. The primary concern is the compatibility of individual modules. One has to find areas where modules have been designed with different specifications of data lengths, type and data element name.
SYSTEM IMPLEMENTATION
Implementation is the stage of the project where the theoretical design is turned into a working system. If the implementation stage is not carefully planned and controlled, it can cause chaos. The implementation involves careful planning, investigation of the current system, and its constraints on implementation etc.
Coding is done in a modular fashion giving much importance even to the minute details so,when hardware and storage procedures are changed or new data is added,rewriting of application program is not necessary.
Implementation involves all those activities that take place to convert from the old system to new system. The old system used much resources and it was time consuming. The proposed system is different from the existing system. A proper implementation is essential to provide reliable system to meet the requirement of the organizations. An improper installation may affect the success of the new system.
The proposed system is implemented as an intranet application system in which the employees can access the application with the link provided to him.Authorization is required to enter into the system for attending and analyzing available surveys.
.
CONCLUSION AND SCOPE FOR FUTURE ENHANCEMENT
CONCLUSION
The project “Intelligent Web Surveyor” being developed is intended as a tool that will help the HR Management of the company in Conducting and Analyzing Employee Satisfaction Surveys. This intranet application system reduced the workload of the HR department drastically.Errors that occurred during manual operation have been eliminated and hence Accuracy and Reliability in conduction and Analyzation of surveys increased.
SCOPE FOR FUTURE ENHANCEMENT
The system developed can be further enhanced. With new ideas, the system can explore technologies that seem promising for survey data collection: speech dialogue systems, video mediated communication, animated agents. The data can be captured directly in electronic format, making analysis faster and cheaper. This again allows more data to be collected than with conventional mailed questionnaires.
The overall objective in the development of database technology has been to treat data as an organizational resource and as an integrated whole. DBMS allow data to be protected and organized separately from other resources. Database is an integrated collection of data. The most significant form of data as seen by the programmers is data as stored on the direct access storage devices. This is the difference between logical and physical data.
NORMALIZATION
Normalization is a technique of separating redundant fields and braking up a large table in to a smaller one. It is also used to avoid insertion, deletion and updating anomalies. All the tables have been normalized up to the third normal form. In short the rules for each of the three normal forms are as below.
First Normal Form
A relation is said to be in 1NF if all the underlying domain of attributes contain simple individual values.
Second Normal Form
The 2NF is based on the concept of full functional dependency. A relation said to be in 2NF if and only if it is in 1NF and every non-key attribute is fully functionally dependent on candidate key of the table.
Third Normal Form
The 3NF is based on the concept of transitive dependency. A relation in 2NF is said to be in 3NF if every non-key attribute is non-transitively.
The project entitled “INTELLIGENT WEB SURVEYOR” is an intranet application that enables us to create and deliver online surveys. The program also collects the responses, and provides summary statistics and graphs. Web Surveyor supports many different question types, and it can create multi-page and branched surveys. Most users find Web Surveyor to be easy to learn, and no knowledge of web forms is necessary. While users can export the data and import into a full-featured statistical or spreadsheet program, many users will find the built-in analysis tools sufficient.
This system can be used for conducting and analyzing employee satisfaction surveys. The system has three type of users namely Administrator, Surveyor and Employees of the company. Administrator will have overall control over the system and he decides the Surveyor. Surveyor uploads questionnaire content to the application. Rapid updating of questionnaire content and question ordering according to user responses is also possible. Surveyor creates groups of employees department wise, designation wise etc. and allocates survey to them. For each survey there will be a certain time period to complete. After this time period Surveyor analyses the survey and creates graphs and charts.
Some of the employees of the company are outsourced to other branches. In case of these employees they cannot participate in the surveys conducted by the HR department. For them SMS Surveys are conducted with this application. For this purpose a GSM (Global System for Mobile Communication)Modem is attached to send questions via SMS to the employee’s mobile. This SMS contains a number to send their answers. These answers are analysed by the Surveyor. All the information is managed tactfully for interpretation and analysis of the data to provide actionable information.
1.INTRODUCTION
1.1. ABOUT THE ORGANIZATION
Praxiss Technologies is run by a Group of well experienced professionals who have a vast expertise in the field of Information Technology. Managed by professionals, Praxiss provides specialized IT Solutions including the execution of projects .Providing Technologies for a dynamic environment where business and technology strategies converge has been our forte.
Core Values
·Adaptability ,Innovation and Reliability
·Professionalism and integrity
IT Solutions
Our experienced professionals are striving to achieve and solve the client’s requirements at all levels in providing software and hardware solutions.
Our Vertical Expertise
·Insurance and Finance
·Hardware and Networking.
·Transportation
·Retail and Manufacturing
·Website Building
1.2 SYSTEM CONFIGURATION
1.2.1 HARDWARE CONFIGURATION
SERVER CONFIGURATION
PCs: Intel Pentium IV.
512 KB of Cache Memory.
512 MB of RAM for Intel.
Logitech Optical Mouse.
CRT High resolution monitor.
80 GB Hard Disk Drive.
104 keys Multimedia Keyboard.
CLIENT CONFIGURATION
PCs: Intel Pentium IV.
256 KB of Cache Memory.
256 MB of RAM for Intel.
Logitech Optical Mouse.
CRT High resolution monitor.
40 GB Hard Disk Drive.
104 keys Multimedia Keyboard.
1.2.2 SOFTWARE SPECIFICATION
Operating System : Windows XP
Tool used : Visual Studio 2005
Language : .Net Technologies ASP.NET(C#)
RDBMS : SQL Server 2005
2.SYSTEM STUDY
INTRODUCTION
It is a great idea to use web surveys in business because it is a great way to find out valuable information that pertains to business and hence can develop a survey that focus on either customers or employees or both. The results are to keep and use however surveyor like. A web survey is a fast and easy way to learn all the information that might want to know.
One of the reasons we should consider using a web survey is because we can learn so much information from our customers or employees. Knowing what drives a customer is helpful no matter what type of business we run; what gets them into a store and what keeps them coming back. A web survey is a quick and easy way for them to contribute their opinion and they can feel like their contribution can make business better. It is good to use a web survey because the consumer can do it from the comfort and privacy of their own. Another reason why we should use a web survey is because it is a great way to find out how employees are doing. They are more likely to stay on when they are happy and they feel like their opinions matter. When employees have issues to consider like health care benefits, pay rates and other things they can put in their thoughts as comments with this web survey and we can then make changes if we choose to because the results belong to us. We can do whatever we want to with the results from a web survey. By following some of the more common answers or suggestions in the results we can put them to use in an effective manner. The choice is ours what we decide to do with the results. A web survey is a helpful tool in gaining information to help our business and if we are able to implement one in our business we should seriously consider it.
2.1 EXISTING SYSTEM
In the existing system in the surveys are conducted manually. A preprinted format which contain various type of questions is circulated among employees .This forms are duly filled and returned to the HR people and they verify the result. Using this result they create graphs and reports. This is a tedious work and may cause errors .
Multiple surveys for different respondent groups or departments will be more complicated in the existing system.Outsourced employees of the company cannot participate in surveys in the existing system.
2.1.1 Drawbacks
Complexity of preparing printed format of questions and its maintenance.
Lack of accuracy in preparing charts.
Time consumption is high.
Outsourced employees of the company cannot participate in surveys.
2.2 PROPOSED SYSTEM
The proposed system, which overcomes the problem that is present in the existing system.The system being developed is intended as a tool that will help the HR Management of the company in Conducting and Analyzing Employee Satisfaction Surveys. It is a fast and easy way to learn all the information that we might want to know surveys for different respondent groups or departments can be conducted simultaneously with our proposed system and the proposed system is more accurate and reliable in creating charts.Proposed system has the advantage of SMS Survey in which outsourced employees of the company can participate in the survey via SMS.Questions will be sent to the employees mobile number and this message contains a number for sending his reply.These are analyzed by the surveyor.
Whenever the Administrator or the Surveyor want to analyze a particular survey he just select the survey that he want to analyze.He can view the number of hits for each option of a question and can view the pie chart which shows the percentage of each option selected by all employees.Ranking type of questions can be separately analyzed according to the rate given for each option by all employees and can view pie charts for each ranking question.By this we can determine which option has the highest rating.
2.2.2 Features
Surveys can be conducted online and can be efficiently analyzed by the surveyor.
No need of preprinted format of questions as all information is stored as soft copies.
Allows rapid updating of questionnaire content and question ordering according to user responses.
More accuracy in preparing charts.
SMS surveys can be conducted for outsourced employees
It is a fast and easy way to learn all the information that the surveyor wants to know.
2.3 SOFTWARE SPECIFICATION
WINDOWS XP
Windows XPis a line of proprietary operating systems developed by Microsoft for use on general-purpose computer systems, including home and business desktops, notebook computers, and media centers. The letters “XP” stand for eXPerience.Windows XP marks the biggest change to the windows OS since the advent of Windows 95. It combines the stability of the NT/2000 operating system with the user-friendliness and hardware support of the consumer.
Windows XP is known for its improved stability and efficiency over previous versions of Microsoft Windows. It presents a significantly redesigned graphical user interface, a change Microsoft promoted as more user-friendly than previous versions of
windows. New software management capabilities were introduced to avoid the "DLL hell" that plagued older consumer-oriented versions of Windows. It is also the first version of Windows to use product activation to combat software piracy, a restriction that did not sit well with some users and privacy advocates. Windows XP has also been criticized by some users for security vulnerabilities, tight integration of applications such as Internet Explorer 6 and Windows Media Player, and for aspects of its default user.
Windows XP has been criticized for its susceptibility to malware, viruses, trojan horses, and worms. Security issues are compounded by the fact that users of the Home edition, by default, receive an administrator account that provides unrestricted access to the underpinnings of the system.
Windows, with its large market share, has historically been a tempting target for virus creators. Security holes are often invisible until they are exploited, making preemptive action difficult. Microsoft has stated that the release of patches to fix security holes is often what causes the spread of exploits against those very same holes, as crackers figured out what problems the patches fixed, and then launch attacks against unpatched systems.
Microsoft recommends that all systems have automatic updates turned on to prevent a system from being attacked by an unpatched bug, but some business IT departments need to test updates before deployment across systems to predict compatibility issues with custom software and infrastructure. This deployment turn-around time also lengthens the time that systems are left unsecure in the event of a released software exploit.
The windows XP file system is based on folders.Folders hold files and other folders, so the system is hierarchical, or “tree structured “.The benefits are better organisation of our files and information.Windows XP Explorer utility provides a different way to locate and work with folders and files.We can copy, move and delete files, just like we can while workings on the deskstop, but the techniques are different.
The .NET Framework
The .NET Framework is a multi-language environment for building, deploying, and running XML Web services and applications.
Common Language Runtime-Despite its name, the runtime actually has a role in both a component's runtime and development time experiences. While the component is running, the runtime is responsible for managing memory allocation, starting up and stopping threads and processes, and enforcing security policy, as well as satisfying any dependencies that the component might have on other components. At development time, the runtime's role changes slightly; because it automates so much (for example, memory management), the runtime makes the developer's experience very simple, especially when compared to COM as it is today. In particular, features such as reflection dramatically reduce the amount of code a developer must write in order to turn business logic into a reusable component.
ASP.NET - ASP.NET builds on the programming classes of the .NET Framework, providing a Web application model with a set of controls and infrastructure that make it simple to build ASP Web applications. ASP.NET includes a set of controls that encapsulate common HTML user interface elements, such as text boxes and drop-down menus. These controls run on the Web server, however, and push their user interface as HTML to the browser. On the server, the controls expose an object-oriented programming model that brings the richness of object-oriented programming to the Web developer. ASP.NET also provides infrastructure services, such as session state management and process recycling that further reduce the amount of code a developer must write and increase application reliability. In addition, ASP.NET uses these same concepts to enable developers to deliver software as a service. Using XML Web services features, ASP.NET developers can write their business logic and use the ASP.NET infrastructure to deliver that service via SOAP.
SQL SERVER 2005
Microsoft SQL SERVER is a set of components that work together to meet the data storage and analysis needs of the largest websites and enterprise data processing system.SQL SERVER 2005 extends the performance, reliability, quality.SQL SERVER 2005 includes several new features that make it an excellent database platform for large-scale online transactional processing (OLTP), data warehousing and e-commerce applications.
Internet Integration:
The SQL SERVER 2005 database engine includes integrated XML support. It also has the scalability, availability and security features required to operate as the data storage component of the largest websites.
Scalability and Availability:
The same database engine can be used across platforms ranging from laptop computers running windows 98 through large, multiprocessor servers running windows 2000 data centre Edition.
SQL Server supports features such as indexed views and large memory support that allows it to scale to the performance level required by the largest organization. It supports wide range of user’s access it at the same time.
The SQL SERVER 2005 relational database engine supports the features required to support demanding data processing environments. The database engine protects data integrity while minimizing the overhead of managing thousands of users concurrently modifying the database. Replication allows you to also maintain multiple copies of data, while ensuring that the sequence copies remain synchronized.
3.SYSTEM DESIGN & DEVELOPMENT
INTRODUCTION
Web surveys are gaining prime importance in our increasingly mobile and highly IT enabled world. A web survey is a fast and easy way to learn all the information that we might want to know. One of the reasons we should consider using a web survey is because we can learn so much information from our customers or employees.
Knowing what drives a customer is helpful no matter what type of business run; what gets them into a store and what keeps them coming back. A web survey is a quick and easy way for them to contribute their opinion and they can feel like their contribution can make business better.
Questionnaire design is considered to be one of the main part of web surveys. Web surveys allows rapid updating of questionnaire content and question ordering according to user responses. Different respondent groups can be created and surveys are allocated to them by the surveyor. For each survey there is certain time period. After this both SMS Surveys and normal surveys are analyzed by the Surveyor and view the chart. All the information is managed tactfully for interpretation and analysis of the data to provide actionable information
Unit Testing.
