PANEL MANAGEMENT SYSTEM Master of Computer Applications
P.G. Department of Computer Science,
P.G. Department of Computer Science
S.NO 1 TOPIC PAGE NO
1.1 Organization Profile
2.1 Problem Identification 2.2 Existing System 2.3 Proposed System 2.4 Features of Proposed System
3.1 Hardware Specification 3.2 Software Specification 3.3 About Software
SYSTEM ANALYSIS AND DESIGN
4.1 Feasibility Analysis 4.2 E-R Diagram 4.3 Data Flow Diagram 4.4 Module Description 5.5 Database Design 5.6 Input Design 5.7 Output Design
SYSTEM TESTING SYSTEM IMPLEMENTATION CONCLUSION & FUTURE ENHANCEMENT
7 8 9
Screen Prototypes & Reports
1.1 Organization Profile
Inspired by such dynamism and strength, Kaar Soft expertly extends Consultancy services that define your Enterprise Resource Planner. By deploying the largest Business Application and ERP software provider, SAP, we harness those multiplying verticals under one platform leaving you with total control and co-ordination of your business. We are also one of the few highly experienced service providers of SAP Net Weaver in the world. Promoted by highly qualified professionals with global expertise, Kaar serves its customers and partners in Europe, USA, Middle East and India. Professionalism, quality and timely deliverance are the lynchpins that run this organization steadfast with success. Ultimately Kaar positions itself as a holistic horizontal service provider that serves varied verticals by offering best practices as we rise high, „In Pursuit of Excellence‟.
Kaar Specializes in the following domains
Offshore SAP Services SAP Net Weaver Services SAP Implementation Defining Kaar The word “Kaar”, in Tamil means “Thick darkened clouds which gives a big hope for a heavy rain”. The name Kaar has been derived out of an inspiration from one of the couplet verses of a world-renowned Tamil literary work “Thirukkural” authored by a sage “Thiruvalluvar”. Thirukkural is a compilation of 1330 Tamil couplets split into 133 chapters. The Thirukkural scripted by the sage in the chapter “Vaan Sirappu” which put in plain words means Rain that enables to produce a bountiful agricultural harvest, which ultimately brings in joy and promise to the entire humankind. India being a tropical nation, the importance of Rain has high significance and is decisive to the country‟s economy.
Similarly, in this competitive world, Information Technology plays a crucial and inevitable role in any organization, without which the ultimate objective of the business cannot be achieved. We as an IT service providing company want to remain as the backbone and be instrumental for the success of ever demanding business organizations. Like the rain that ensures bliss of the humanity, “Kaar Technologies” which is promoted by individuals with commitment and deep rooted values will be the key to endeavor the accomplishment of business objectives in an organization.
Vision To develop and deploy high quality value added services in SAP domain by offering end to end solutions and support. To be seen and perceived as an able player in specialty areas by building chosen industry vertical products for SAP. To lead the market by developing path breaking and innovative offerings in niche segments of Enterprise Solutions. Mission To remain a socially responsible corporate entity, which will instill a sense of pride, joy and accomplishment, in every facet of its interaction, to everyone associated, be it the employees, customers, vendors or stakeholders. Values To exceed the expectations of every customer every time. To exhibit Energy and dynamism with a consistent high quality delivery of all services. To nurture structured Innovation, continuous learning and lateral thinking. To promote responsible leadership and foster entrepreneurial spirit. To develop a culture of mutual respect, diversity, plurality of people and thoughts.
1.2. About the project The main aim of the project is to provide the establishment of the product over the world through panel management system. The feedbacks of the customers are collected through the project and information regarding the new arrival of the product and the salient features are being disclosed to the user through mail. The feedback system provides the panel management system to get information about the users through which the user gets the information about the product that will be newly introduced in the market. The project provides the user to make utilization of time and to be obtaining the product from their home place. The panel management system handles all types of questionnaires from simple comment cards to the most sophisticated product. It takes through all aspects of the survey process from designing and printing a questionnaire through producing professional quality tables. User can easily enter and edit the data, spell check the text, and calculate complex statistics and necessary sample sizes. It offers the product sample management and multi-user network support. The panel management system is an extremely versatile collection of software packages. The Basic Edition of the panel management system is designed to appeal to all users those who are outside the traditional market research departments can easily create a simple survey, while market research professionals will appreciate the analytical tools available from an add-on statistical module
2. SYSTEM STUDY
2.1 PROBLEM IDENTIFICATION The company “Kaar Soft Private Limited” aims at maintaining the service request for the product and client information manually. So they found difficulties in maintaining the details of the above. The company needs a computerization of manual system.
Problems with the Existing Manual System: Standard functions are limited such as worksheets were used. Since the method is conventional, there is a secured means of data storage and retrieval. Searching of information was time-consuming. Data verification, comparison and validation are done manual. Generating final output requires more manual work.
2.2 EXISTING SYSTEM The existing system is conventional type, in which the user at present records the service request manually. In the existing system the products are assigned by a user and it is sequentially increased. Then product maturity days are updated daily for each user manually. Then the type of call, problems reported and remarks are manually entered in the specific column.
The existing system is a manual one, which consumes lot of time as well as manpower. It takes more time to search for records. The customer stores their information manually and producing the output. These duties were manually operated by day to day. Management of a large organization is very tedious and time-consuming task. There is no way to acknowledge the information. The panel management system is the most complete system available for working with survey questionnaires.
2.3 PROPOSED SYSTEM The proposed system to propose the each and every user survey’s (feedback) are getting through the online and also it provides various firm information’s are getting in the single mail. This system also has many good features that reduces more conventional work, which is easy to manage, and has high data security, etc. Features available in the proposed system are as follows.
2.4 FEATURES OF THE PROPOSED SYSTEM Foremost advantage is storage of products request in a standardized and secured database. Front end designed with GUI based tools. Lodging of service requests are comparatively increased in number than conventional system. Data updation and modification are very easy and adding of new products request is also made much better than the conventional system. The other vital thing about this proposed system is the generation of reports as per the requirements intended by the high level management.
3. SYSTEM SPECIFICATION
3.1 Hardware Specification
Intel Pentium Dual core 3.00 GHZ
512 MB RAM
CRT Color Monitor (14/15 inch)
3.2 Software Specification
Operating System Front End Data base server Web Browser Web Server : : : : : Microsoft Windows XP ASP.Net 2005 SQL Server 2005 Internet Explorer 7.0 IIS 5.0
3.3ABOUT THE SOFTWARE
WHAT IS ASP.NET? ASP.NET is a programming framework built on the common language runtime that can be used on a server to build powerful Web applications. ENHANCED PERFORMANCE: ASP.NET is compiled common language runtime code running on the server. Unlike its interpreted predecessors, ASP.NET can take advantage of early binding, just-in-time compilation, native optimization, and caching services right out of the box. This amounts to dramatically better performance before you ever write a line of code.
TOOL SUPPORT: The ASP.NET framework is complemented
by a rich toolbox and designer in the Visual Studio integrated development environment. WYSIWYG editing, drag-and-drop server controls, and automatic deployment are just a few of the features this powerful tool provides.
AND FLEXIBILITY: ASP.NET is based on the common language
runtime, the power and flexibility of that entire platform is available to Web application developers. The .NET Framework class library, Messaging, and Data Access solutions are all seamlessly accessible from the Web. ASP.NET is also language-independent, so you can choose the language that best applies to your application or partition your application across many languages. Further, common language runtime interoperability guarantees that your existing investment in COM-based development is preserved when migrating to ASP.NET.
ASP.NET makes it easy to perform common tasks, from simple
form submission and client authentication to deployment and site configuration.
ASP.NET employs a text-based, hierarchical configuration
system, which simplifies applying settings to your server environment and Web applications. Because configuration information is stored as plain text, new settings may be applied without the aid of local administration tools. This "zero local administration" philosophy extends to deploying ASP.NET Framework applications as well
AND AVAILABILITY: ASP.NET has been designed with
scalability in mind, with features specifically tailored to improve performance in clustered and multiprocessor environments. Further, processes are closely monitored and managed by the ASP.NET runtime, so that if one misbehaves (leaks, deadlocks), a new process can be created in its place, which helps keep your application constantly available to handle requests.
AND EXTENSIBILITY: ASP.NET delivers a well-
factored architecture that allows developers to "plug-in" their code at the appropriate level. In fact, it is possible to extend or replace any subcomponent of the ASP.NET runtime with your own custom-written component. Implementing custom authentication or state services has never been easier. SECURITY: With built in Windows authentication and per-application configuration, you can be assured that your applications are secure
OVERVIEW OF THE .NET FRAMEWORK: The .NET Framework is a new computing platform that simplifies application development in the highly distributed environment of the Internet. The .NET Framework is designed to fulfill the following objectives:
To provide a consistent object-oriented programming environment whether object code is stored and executed locally, executed locally but Internet-distributed, or executed remotely.
To provide a code-execution environment that minimizes software deployment and versioning conflicts.
To provide a code-execution environment that guarantees safe execution of code, including code created by an unknown or semi-trusted third party.
To provide a code-execution environment that eliminates the performance problems of scripted or interpreted environments.
To make the developer experience consistent across widely varying types of applications, such as Windows-based applications and Web-based applications.
To build all communication on industry standards to ensure that code based on the .NET Framework can integrate with any other code. The .NET Framework has two main components: the common language
runtime and the .NET Framework class library. The common language runtime is the foundation of the .NET Framework. You can think of the runtime as an agent that manages code at execution time, providing core services such as memory management, thread management, and remoting, while also enforcing strict type safety and other forms of code accuracy that ensure security and robustness. In fact, the concept of code management is a fundamental principle of the runtime. Code that targets the runtime is known as managed code, while code that does not target the runtime is known as unmanaged code. The class library, the other main component of the .NET Framework, is a comprehensive, object-oriented collection of reusable types
That can use to develop applications ranging from traditional command-line or graphical user interface (GUI) applications to applications based on the latest innovations provided by ASP.NET, such as Web Forms and XML Web services. The .NET Framework can be hosted by unmanaged components that load the common language runtime into their processes and initiate the execution of managed code, thereby creating a software environment that can exploit both managed and unmanaged features. The .NET Framework not only provides several runtime hosts, but also supports the development of third-party runtime hosts. Internet Explorer is an example of an unmanaged application that hosts the runtime (in the form of a MIME type extension). Using Internet Explorer to host the runtime enables you to embed managed components or Windows Forms controls in HTML documents. Hosting the runtime in this way makes managed mobile code (similar to Microsoft® ActiveX® controls) possible, but with significant improvements that only managed code can offer, such as semi-trusted execution and secure isolated file storage. .NET Framework to develop the following types of applications and services:
Console applications. Scripted or hosted applications. Windows GUI applications (Windows Forms). ASP.NET applications. XML Web services. Windows services.
CLIENT APPLICATION DEVELOPMENT Client applications are the closest to a traditional style of application in Windows-based programming. These are the types of applications that display windows or forms on the desktop, enabling a user to perform a task. Client applications include applications such as word processors and spreadsheets, as well as custom business applications such as data-entry tools, reporting tools, and so on. Client applications usually employ windows, menus, buttons, and other GUI elements, and they likely access local resources such as the file system and peripherals such as printers. Another kind of client application is the traditional ActiveX control (now replaced by the managed Windows Forms control) deployed over the Internet as a Web page. This application is much like other client applications: it is executed natively, has access to local resources, and includes graphical elements. In the past, developers created such applications using C/C++ in conjunction with the Microsoft Foundation Classes (MFC) or with a rapid application development (RAD) environment such as Microsoft® Visual Basic®. The .NET Framework incorporates aspects of these existing products into a single, consistent development environment that drastically simplifies the development of client applications. The Windows Forms classes contained in the .NET Framework are designed to be used for GUI development. You can easily create command windows, buttons, menus, toolbars, and other screen elements with the flexibility necessary to accommodate shifting business needs.
SERVER APPLICATION DEVELOPMENT Server-side applications in the managed world are implemented through runtime hosts. Unmanaged applications host the common language runtime, which allows your custom managed code to control the behavior of the server. This model provides you with all the features of the common language runtime and class library while gaining the performance and scalability of the host server. Servers such as IIS and SQL Server can perform standard operations while your application logic executes through the managed code. INTERNET INFORMATION SERVER (IIS) WHAT IS IIS? Internet Information Server is a web server developed by Microsoft that runs on Windows NT/Windows 2000 platform. Internet Information Server 5.0(IIS) is fully integrated at the operating system level , Windows 2000 server lets organizations add internet capabilities that weave directly into the rest of their computing infrastructure.
APPLICATION PROTECTION: Internet Information Server 5.0 offers improved protection and increased reliability for web applications. By default, IIS runs all applications in a common or a pooled process that is separate from core IIS processes. In addition, administrator can still isolate mission-critical applications and that should be run outside of both core IIS and pooled processes.
INTEGRATED SETUP AND UPGRADE: Internet Information Server 5.0 installs as a networking service of Windows 2000 server. Customer with any existing version of Windows NT server 3.5 or 4.0 will automatically be upgraded to the new features and services of Windows 2000 server and IIS. REMOTE ADMINISTRATION: Internet Information Server 5.0 has web-based administration tools that allow remote management of a server from almost any browser on any platform with IIS 5.0, administrators can set up administration accounts called privileges on web sites, to help distribute administrative tasks.
CERTIFICATE STORAGE: IIS certificate storage is now integrated with the Windows crypto API storage. The Windows certificate Manager provides a single point of entry that lets administrator store, back up and configure server certificates. PROTOCOL COMPLIANCE: IIS is fully integrated with the Kerberos v5 authentication protocol implemented in Microsoft Windows 2000.This means administrators can pass authentication credentials among connected computers running windows.
SQL SERVER SQL Server is the enterprise-class data management solution provided by Microsoft. It provides Performance, Scalability and reliability of data management to organizations. SQL server enables enterprise to effectively manage its data in a fast-changing environment, at a low implementation and maintenance costs. SQL Server 2005 provides the fastest route to Web application development. Microsoft SQL server is a relational database management and analysis system for e-commerce, line-of-business and data warehousing solutions. SQL Server 2005, the latest version, includes support for XML and HTTP, performance and availability features to partition load and ensure uptime and advanced management and tuning functionality to automate routine tasks and lower total cost of ownership. Features of SQL Server 2005 Microsoft SQL server 2005 features include: Internet Integration Scalability and availability Enterprise-level Database Features Ease of installation, deployment and use Data warehousing Database Architecture Microsoft SQL Server 2005 data is stored in databases. The data in a database is organized into the logical components visible to users. A database is also physically implemented as two or more files on disk.
Each instance of SQL server has four system database (master, model, tempdb and msdb) and one or more user databases. Some organizations have only one user database, containing all the data for its organization. Some organizations have different databases for each group in their organization and sometimes a database used by a single application. For example, an organization could have one database for sales, one for payroll, one for a document management application, and so on. It is not necessary to run multiple copies of the SQL server database engine to allow multiple users to access the databases on a server. When connecting to an instance of SQL server, your connection is associated with a particular database on the server. This database is called the current database. You are usually connected to a database defined as your default database by the system administrator, although you can use connection options in the database APIs to specify another database. You can switch from one database to another using either the Transact-SQL USE database-name statement, or an API function that changes your current database context. SQL Server 2005 allows you to detach databases from an instance of SQL server, then reattach them to another instance. Or even attach the database back to the same instance. If you have a SQL server database file, you can tell SQL server when you connect to attach that database file with a specific database name.
4. SYSTEM ANALYSIS AND DESIGN 4.1 FEASIBILITY ANALYSIS
Having established a system, one has to determine whether an alternative system is feasible compared to existing system. Feasibility study is conducted in two-step; first a project team formed. The team develop system flowchart that identify the characteristics of the existing system, evaluate the performance of the system and cost data and select the best system for the job
Feasibility study is conducted to analyze whether a new system would be more feasible than the existing one. To perform a feasibility study, we need to consider the economical, technical and behavioral factor in a system. ECONOMICAL FEASIBILITY It is most frequently used method for evaluating the effectiveness of a system, which is commonly known as cost/benefit analysis. The existing system is operated in manual which increases the workload, so an alternative system is developed that minimizes the workload by making use of automated processing. The cost required for automation is compared against the benefits drawn out of it, and since the benefits exceeds cost we go for automation of the system. TECHNICAL FEASIBILITY This is designed to fit the available software and hardware chosen. The data storage requirements are available. Already existing resource can meet the expenses of the existing system in future. The system is technically feasible, since it is developed only in existing set of rules.
BEHAVIORAL FEASIBILITY It involves performing an estimate, how strong a reaction the user staff is likely to have towards the development of a computerized system. The introduction of a new system requires special effort to educate and train the user to perform the operation automatically.
The necessity tasks required by the operator are satisfied by the developed system. The proposed system is operationally feasible since the system not only avoid the difficulties of the existing system but also to promote the speed accuracy, new features, prompt is also found economically feasible. The main emphasis is to conducting feasibility study to provide service to the user in easy and better way. SOCIAL FEASIBILITY The assessment of social feasibility will be done along with technical feasibility. The study is developed in such a manner that a user can use it flexibly. Large volumes of data can be processed and the results are produced at a faster rate. OPERATIONAL FEASIBILITY The proposed system has to offer user friendliness combined with greater processing speed. The organization has expert workers to operate the system effectively and efficiently. The product developed is to user friendly and then the operation of the system becomes much easier. So it is operationally feasible also.
4.2 E-R DIAGRAM
4.3 DATA FLOW DIAGRAM
4.4 MODULE DESCRIPTION:
The Project “Panel Management System” contains five Modules in it. They are described below USER ACCOUNT INFORMATION MODULE. The user account information system contains the details of three sub modules. They are Login Forget password The forget password has some the questions in it by answering that it will be stored in the database. By creating the account it will be send to the mail id. And by clicking the link the user can access his account
UPDATING THE PROFILE MODULE The profile has three sections in it they are About You Your net usage Your household
By finishing the 100% profile only we can enter into the survey. And once we create a profile we can also deactivate it whenever by the user like.
CREATING THE SURVEY The creating survey module has some of the questions about the product and the services that are mentioned by the consumer in his profile. By answering the questions it will be stored in the database and it can collect by the company and it analyses the result. The survey has been creating for marketing decision making. 22
REFER A FRIEND. The referring a friend module tells that we can also refer a friend to this survey. To refer a friend we are collecting the user mail id and password the password of the user will be confidential.
POLLING’S DAILY. The polling‟s daily module tells that it contains voting part in it. It has some of the questions in it and by answering that it generates some of the voting to that by getting the answers we are storing it into the database.
4.5 DATABASE DESIGN
4.6 INPUT DESIGN
4.7 OUTPUT DESIGN
5. SYSTEM TESTING