project_idea_how to create mock exam portal with sample report

© 2009 I-Practice-Tests Powered By || Ecologic Corporation www.ecologic.co.in: [email protected]

1

For More Project Ideas

Google this: Ecologic Corporation

+Project Ideas

[email protected]

Here is sample project report

“How to create Mock Exam

Portal!”


2

COMPANY NAME:

Logic at work


3

� ORGANIZATION OVERVIEW

Ecologic Corporation Founded in 2003, first started with innovative Agricultural

products for farmers, which till date are making successful stories in Punjab and Haryana,

has come far from what it was yesterday. Like all startups fighting with teething

problems, against all odds the company after gaining the success in Agriculture has now

diversified itself into Information Technology with strong professional team. Now the

company offers customized innovative solutions in software development, website

development and System integration .The Company has strong skill set and experience in

technologies which include in developing high end solutions in network security

integration, LAN/WAN solutions, search engine technologies and Mobile Applications

Ecologic Corporation web solutions is an India based company that provides offshore

software development, website design and e-business solutions to clients around the

globe. Our extensive experience in building innovative and creative web-based

applications allows us to provide you the best in services (Web design, web applications,

Graphic design, logo design, flash animations, application developments, e-business

solutions and search engine optimization) we provide. We have outstanding talent to set

your business on internet. We provide you complete solution under one roof. We take the

time to analysis and understand your requirement and suggest you the best possible

solution. We help you market and sell your products and services cost effectively. We

solve all your problems and present in a very effective way that a layman can easily

understand. We provide you free consultancy to estimate your budget.

We build websites and applications using the latest and in best technologies ( LAMP (

Linux , Apache , MySql , PHP ) and Microsoft .Net( ASP.NET , VB.NET , C#, ASP, MS

SQL). Our creative designers have expertise in Adobe Photoshop, Adobe In design, Corel

draw, Flash, Dreamweaver, Fireworks, etc.


4

� Why outsource with us?

Cost effectiveness, we provide you highly competitive rates. We bring together a diverse

team of experts; e-commerce technologists, system architects, graphic and user interface

designers, brand strategists, and business management consultants. Top quality services

on-time and on-budget. Option to manage your offshore development team either by you

or us.

� Specialization

We specialize in data processing programming, data processing solutions in C, Unix C/C++ ,Java Programming, Php,css, javascript, json, smarty, Oracle IBM DB2 database analysis programming, Content Management solutions, Visual C++ application development, MS SQL database, ActiveX/COM, ASP, .NET, Web Development solutions, Telephony e-commerce solutions. We have all abilities to service you to provide visualization and conceptualization in any art form: Paper, Print, Textile, Canvas and Wood also.

� Software services provide by the Ecologic Corporation Company

� Website Design

� Website Development

� Application Development

• Database Application Development

• Enterprise Application Development

� Web Hosting


5

� LOCATION

Ecologic Corporation (Registered Office) # 2138, Sector 22-C, Chandigarh - 160022

� FEASIBILITY STUDY

Much organization uses many applications and services that were built over many months or years, as new business needs were identified. As a result, these applications probably are of different ages, were written by different people using different languages and technologies, reside on different hardware platforms, use different operating systems, and provide very different functionality. In fact, many of the applications often have very little in common at all, resulting in isolated functionality and multiple instances of the same data. For same organization, these conditions can result in redundant activities, higher costs, and inefficient response to your customers. Just as employees have to work together to meet business goals, your applications need to do the same. Application integration is the secure and orchestrated sharing of processes and/or data between applications within the enterprise.

� EXISTING SYSTEM

Application integration can be broadly categorized into three types:

• Manual application integration.

• Semi-automated application integration.

• Fully automated application integration.

� Most environments involve a combination of all three types.

• Manual Application Integration.

Manual application integration requires people (employees and customers) to act as the interfaces between applications and enable the integration between them. This form of


6

application integration is very common. As an example, think of a customer service department that takes information from the public. People may enter the same information into multiple systems and read information from those systems to respond to customer requests. In other cases, a person may need to read customer information from one database, and then re-enter it into another database used for another purpose.

This form of integration requires very little technology investment. It becomes more complex, however, when your organization becomes more complex, and can lead to inaccuracies in data. As the amount and complexity of your data increases, or as the number of applications increases, you will require more and more people to maintain such an environment. An environment that relies heavily on manual integration is generally very inefficient, and does not grow as easily as environments that use more automated techniques.

• Semi-Automated Application Integration

Semi-automated application integration combines human steps with some automation. The person may be involved in an area where the corresponding automated solution is too difficult or expensive to implement, or where the business requires a person to make decisions. For example, your business may require a manager to approve all expense claims. In this case, all of the steps before and after managerial approval may be automated, but a person is required in the middle of the process. In other cases, human intervention may be needed to transform data that is required in another system. Semi-automated application integration generally requires more technology investment, but once that investment is made, you can often reduce the number of people involved in integrating your applications. Reducing human involvement in this manner usually reduces costs and increases reliability.

� PROPOSED SYSTEM

Models in enterprise integration application.

• Point-to-point model

• Integration hub model

• Point-to-Point Model


7

The point-to-point model describes a decentralized structure in which each application communicates directly with the other applications. This type of integration is most appropriate for organizations that need to integrate a few applications with a small number of services.

Figure 1.1

Figure 1.1 shows the number of connections required for point-to-point environments with three and 10 applications, respectively, when you need to ensure that all applications can communicate with each other. As the number of applications and services increases, the number of interfaces and connections that need to be maintained in a point-to-point environment rapidly increases.

The maximum number of connections required is defined as follows:

Σx (x=1 to n – 1) where n is the number of applications you need to integrate. The number of interfaces may be up to twice the number of connections (depending on whether they are one-way or two-way interfaces). This means that for the three application example (Scenario A in Figure 1.1), up to three connections and up to six interfaces are needed, whereas for the 10 application example (Scenario B), up to 45


8

connections and up to 90 interfaces are required. In a point-to-point integration environment, interfaces between the applications are usually written as business needs arise. The problem with this approach is the lack of consistency. The integration approach used generally depends on which integration approach the developer is most familiar with, what he or she knows about the individual applications, and so on. As more and more applications are developed or updated, additional interfaces must be created. The same problem pertains when new business goals are defined that require applications to communicate with one another differently. Every change makes the environment more difficult to understand, until eventually the structure is so complex that it is almost impossible to manage effectively. Such a complex structure may even hinder the company’s ability to strategically shift its business goals, due to the high IT costs surrounding the change. Defining application integration on the fly in this way can massively increase your medium-term and long-term costs for a short term gain.

• Integration Hub Model

The integration hub model provides a more centralized structure, in which an integration hub is placed between the applications, and each application communicates with the hub rather than communicating directly with other applications. Each application needs only an interface and a connection to the integration hub. To simplify matters, the integration hub can rely heavily on existing standards, which means that either the interfaces already exist or the methodologies for writing them are well-defined.

The main advantage of an integration hub environment is scalability. Figure 1.2 shows the use of an integration hub, again in environments with three and 10 applications, respectively.


9

In Figure 1.2, a single connection is required to the integration hub, with interfaces potentially required at the application and the integration hub. However, many environments require only one interface (or none if the application already uses the standards supported by the hub). This configuration leads to a maximum of three connections and six interfaces for the three application example, or 10 connections with 20 interfaces for the 10 application example. In most cases, the number of interfaces will be significantly lower. The integration hub model is significantly more scalable for integration environments with many applications. A typical large-scale organization has thousands of islands of information, involving thousands of applications. You simply cannot create individual interfaces for every point of interaction. Instead, the solution is to create an application integration environment that allows all of your applications to communicate in a logical, predefined way. This hub infrastructure enables you to modify or update elements much more easily, and to do so when the business requires, rather than when the preexisting technology dictates. It should also allow the organization to more easily change direction and to use the products and services it has to match evolving requirements. Because interfaces are within the integration hub (and are usually


10

standards-based), you do not need to rewrite them whenever new applications are introduced. However, the hub can be technically challenging to implement and may be too costly for more simple application integration environments. In addition, you may have to sacrifice some data complexity to ensure that each application conforms to the standards of the integration hub.

� INTRODUCTION OF THE PROJECT

This project www.i-practice-tests.com is basically a website designed for helping the students of each and every field. Students can practice more and more here on this website and can enhance their skills in their respective fields. They can download the practice exams and can practice whenever they want.

We are using .Net technology (Visual studio 2008) as the front end of this website and SQL Server (2005) as the back end. As .Net is the simplest and flexible platform, so it is easy to use it for this website. And we maintain our database in SQL Server. We had around 15 tables in our database for arranging the database entries. We had made the business objects for these tables. Business objects are basically objects made for accessing the functions like SAVE Entry, DELETE Entry, GET Entry, and GET All. in .NET Framework:

� Web Services

A Web service is an application component that:

• Exposes useful functionality to other Web services and applications through standard Web service protocols.

• Provides a way to describe its interfaces in detail, allowing developers to build client applications that talk to it. The description is provided in an XML document called a Web Services Description Language (WSDL) document.

• Describes its messages by using an XML schema.

Many vendors have endorsed and have started to provide Web service capabilities in their platforms. Using Web services for integration ensures that your integration is based on open standards that are language neutral and platform independent, and helps to ensure that the technology remains relevant over time. Web services rely on defined specifications to allow systems from various vendors to interoperate. Web services


11

specifications, commonly referred to as WS-* specs, are in various states of acceptance. The Web Services Interoperability Organization (http:// www.ws-i.org) was formed to provide a framework and a set of tools to ensure that different vendor’ implementations of a particular WS-* spec are compatible. Note: For more information about the current Web services standards being defined and the location of the specifications, see Web Services.SpecificationsonMSDN®(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnglobspec/html/wsspecsover.asp).

� Screen Scraping

Sometimes the business logic of an application resides in the presentation layer. In this case, you can use software packages that simulate the human user’s interactions to interface with the application. Screen scraping is a non-invasive mode of integration and does not introduce any additional channels of interface with the application.

You can implement this technology in two ways:

• Use terminal emulation software to intercept screen images after they have been formatted into the terminal data stream.

• Intercept the data before it is formatted for display purposes. This method generally provides better performance and requires less interaction than using terminal emulation software.

� Direct Data Access

Direct data access involves making native database calls to application databases or writing data directly to the target application file systems. This approach requires knowledge of the data access language of the target database as well as knowledge of the data model used in the target application. Direct updates to databases can make them vulnerable to data corruption and referential integrity violations. For this reason, many applications do not support direct data access. Instead, ordinarily you use their application programming interfaces (APIs) so that the calling programs can benefit from the business logic implemented within the applications.

� File Transfer


12

File transfer involves integration between multiple platforms through transfers of files in batch mode. Typically, you move data between systems asynchronously using batch file transfers, and the flow of data is unidirectional. Changes in one system rarely affect other systems unless the structure, format, or semantics of the data being moved changes. File transfer is a cost-effective solution for transferring batch files between a wide variety of platforms. A number of features add to the reliability and efficiency of file transfer, such as scheduling, automatic restart, guaranteed delivery, encryption/decryption, and compression/decompression.

Various organizations can upload their online exams here on this website for the students for practicing. My project is very much helpful for the students, whether he is doing MCA, MBA, B.TECH, OR IELTS, TOEFL and many more.

Our Project is based on the fact that most people are spending most of their internet time (about 80%) on one of these kind social networking applications.

The Internet application like (www.gmail.com),(www.yahoogroups.com),(www.orkut .com),(www.facebook.com),(www.Linkedin.com),(www.Myspace.com),(www.Xanga.com),(www.youtube.com) etc are the places where most of the internet traffic resides, therefore all students will automatically somehow get the chance to practice before their exams in their respective exams while spending time in these social networks and company will be able to reach lot of students from these social networks .

We need to bring target people to www.i-practice-tests.com from these social networking sites so that people from these site use our application of taking mock tests from their accounts in respective social networking site application.

Therefore, an Integration of www.i-practice-tests.com with these social networks is visualized and is to be implemented for the said project. In the first phase only one social networking site will taking as test case for taking decision further on technology investment.


13

For developing this www.i-practice-tests.com Integration Hub we will be using.

a) Service Oriented Architecture b) Web Services to Integrate with all Social Networks c) In some cases, direct call to API of these Social Networking sites.

YouTube

Xanga.com

MySpace

Facebook

LinkedIn.co

m

Gmail

Orkut

yahoogroup

s

User/Individual/

Prospective

User of

I-Practice-Test


14

COMPONENTS REQUIREMENTS

Web Server IIS 7.0

Application Server IIS 7.0

Application Standard WEB 2.0

Application Architecture N-TIER

Language VB 9.0

DataBase SQL SERVER 2005

Case Tools VISUAL STUDIO 2008

Scripting JAVASCRIPT


15

Web Services Architecture SOA

Event Driven Architecture DELEGATION MODEL

Infrastructure Components ECOLOGIC API

Enterprise Messaging Infrastructure

ASP.NET 3.5

Platform INDEPENDENT

User Interface ASP.NET 3.5

Server Technology ACTIVE SERVER PAGES

Client Technology AJAX

Remote Technology .NET REMOTING AND WEB SERVICES


16

Components Technology ACTIVE X AND .NET CONTROLS

Business Reporting CRYSTAL REPORTS

Middle Ware Technology BUSINESS OBJECTS IN .NET

� REQUIREMENTS

� HARDWARE REQUIREMENTS

Platform 32 bit version /X-64

Operating System 32/x64-based version of Windows Server 2003, Standard Edition, Enterprise Edition, or Datacenter Edition

Requirements for single server deployment

Same as the requirements for the edition of Windows Server 2003

Requirements for server farm deployment

1* 64-bit CPU

* 2 or more CPUs recommended 2 GB RAM

� SOFTWARE REQUIREMENTS

• Windows Server 2003 Editions

a) Windows Internet Information Services (IIS) 7.0, running in IIS 7.0 worker process isolation mode

b) Microsoft ASP.NET 3.0

• Database Requirements


17

SQL Server 2005 Standard Edition/Express, with the latest service pack

• Client Software Requirements

Any Windows, Macintosh, or UNIX client can use Windows features if the client runs the following software:

Windows Internet Explorer 6.0 with SP2, Windows Internet Explorer 6.0 or above for Macintosh, Netscape Navigator version 6.2, Mozilla 5.0, or Firefox 5.0

� FRONT END TOOL

� OVERVIEW OF VB 9.0

“Visual Basic Orcas” (VB 9.0 ) introduces several language extensions that build on “Visual Basic Whidbey” (VB 8.0) to support data-intensive programming – creating, updating, and querying relational databases, XML documents, and object graphs – in a unified way. In addition, VB 9.0 introduces several new language features to enhance Visual Basic’s unique facility for static typing where possible, and dynamic typing where necessary.

These new features are:

• Implicitly typed local variables

• Query comprehensions

• Object initializes

• Anonymous types

• Full integration with the Linq framework

• Deep XML support

• Relaxed delegates

• Nullable types

• Dynamic interfaces


18

• Dynamic identifiers

This document is an informal overview of these new features. More information, including updates to the Visual Basic language definition and compiler previews, is available on the Visual Basic Developer Center (http://msdn.microsoft.com/vbasic/default.aspx).

� Getting Started With VB 9.0 To see the power of these language features at work, let’s start with a real world example –the CIA World Factbook database. The database contains a variety of geographic, economic, social, and political information about the world’s countries. For the sake of our example, we begin with a schema for the name of each country and its capital, total area, and population. We represent this schema in VB 9.0 using the following class:

Class Country Public Property Name As String Public Property Area As Float Public Property Population As Integer End Class

� What is .NET?

.NET is the latest platform from Microsoft and it provides Multilanguage environment that enables you to develop, deploy and run web based applications and services. It provides a new level of interoperability that enables you to reuse components created in other languages.NET is used for web applications but not excluding desktop applications.

Microsoft .NET initiative is broad based and very ambitious. Its two most important parts are:

� .NET framework:

It includes the languages and execution platform, plus extensive class libraries providing rich built in functionality.

� Components of .NET framework:

.NET framework is composed of classes and services that form a layer between applications and operating system. Its two main components are:

1. CLR Common Language Runtime


19

2. .NET framework class library

� CLR services:

• Exception Handling

• Security

• Debugging to language that are CLR compatible

• Garbage collection

• During execution of program, it controls the interaction of code with the

operating system.

� ASP.NET: ASP.NET is a technology that allows us to build and control dynamic Web pages easily. It also provides many enhancements to take advantage of the new technology as we can interact with databases, personalize Web pages for visitors, display pages on mobile devices (such as cell phones), and even build an entire e-commerce site from scratch.

Previously, internet worked on request/response model that is an integral part of client/server model. Although it is a marvelous way of communicating and distributing information, it's rather simple and static. When the process is over, once client receives the requesting page from the server the server has no idea what the client is doing unless it makes another request.

There is another model for communicating between server and clients, known as event-driven model. ASP.NET works on this model, it detects action and responds to them i.e. the server waits around for something to happen on the client. Once it does, the server takes action and performs some piece of functionality. Of course, a Web server can not know what you are thinking, but it can respond to your actions. If you type some text on Web page, the server responds to it. If you click an image, the server responds.

� Following are some of the significant new features of ASP.NET:

• ASP.NET uses compiled code written in Common Language Runtime languages such as Visual Basic and C#. Unlike previous versions of Active Server Pages, this version does not use interpreted scripting languages such as VBScript.


20

• ASP.NET pages are built out of server-side controls. Web server controls enable you to represent and program against Hypertext Markup Language (HTML) elements using an intuitive object model.

• ASP.NET includes a new technology called Web Services. You can use Web Services to access methods and properties and transfer database data across the Internet.

• ASP.NET is part of Microsoft's .NET Framework. You can access thousands of .NET classes in your code that enable you to perform such wondrously diverse tasks as generating images on-the-fly and saving an array to a file.

• ASP.NET includes page and data caching mechanisms that enable you to easily and dramatically improve the performance of your Web site.

� INTRODUCTION TO VISUAL STUDIO.NET

Visual Studio .NET is a complete set of development tools for building ASP Web applications, XML Web services, desktop applications, and mobile applications. Visual Basic .NET, Visual C++ .NET, and Visual C# .NET all use the same integrated development environment (IDE), which allows them to share tools and facilitates in the creation of mixed-language solutions. In addition, these languages leverage the functionality of the .NET Framework, which provides access to key technologies that simplify the development of ASP Web applications and XML Web services

For front end we are using Vb.net (Visual Basic.net) all the forms i.e. interfaces are developed using Vb.net as it is very convenient , efficient and user friendly language and has the capability for multiple language integration and provides us with the feature of disconnected data architecture

� Features of VB.net

1. Object oriented – Supports polymorphism, inheritance, encapsulation, data binding and other related features related to objects.

2. Error Handling – Supports both structured and unstructured error handling. 3. Multithreading – Supports concept of dividing a process into sub processes and

running them simultaneously to increase efficiency. 4. Deployment of project – Vb.net provides a well specified wizard for proper

deployment of project. 5. Supports global assembly catch.


21

�� .NET FRAMEWORK ARCHITECTURE

� N-TIER ARCHITECTURE


22

� BACK END TOOL

� INTRODUCTION TO SQL SERVER 20005


23

• HISTORY

The history of SQL and relational databases traces back to E.F. Codd, an IBM researcher who first published an article on the relational database idea in June 1970. Codd's article started a flurry of research, including a major project at IBM. Part of this project was a database query language named SEQUEL, an acronym for Structured English Query Language. The name was later changed to SQL for legal reasons, but many people still pronounce it SEQUEL to this day. IBM published many articles in technical journals about its SQL database language, and in the late 70's two other companies were started to develop similar products, which became Oracle and Ingres. By 1985 Oracle claimed to have over 1000 installations. In the late 80's and early 90's SQL products multiplied and became virtually the standard for database management in medium to large organizations, especially on UNIX and mainframes.

• THE SQL LANGUAGE

The SQL "language" allows anyone with a computer terminal to access and use relational databases. SQL uses about 30 simple "english like" commands like Open, Close, Select, and Update to operate the database. For example, the SQL command shown below could be use to select all database records in the "Western" region.

SELECT * WHERE Region="Western"

Although SQL can be used directly by simply typing in commands like this, the SQL language is tricky for non-programmers to learn. Panorama allows you to access your database using a standard Macintosh graphical interface. Panorama then translates your mouse clicks and keyboard taps into the SQL language and passes them on to the SQL server.

One of the major benefits of SQL is that it provides a more or less standard way to access and use database systems from a variety of vendors. For example, the SELECT statement listed in the previous section would work exactly the same on Butler, Oracle, Sybase, DB2, or any other SQL based database on any host machine.


24

� TABLES DESCRIPTION

There are 15 tables used for this project. And following is the list of tables.

TABLE NAME DESCRIPTION

Answer Table It stores the answer description that whether it is correct or not and what type of it is.

Categories Table It stores the categories names of different categories. And their description.

City Table It stores the city name to which user belongs.

Contact Table It stores the contact details of each and every user.

Country Table It stores the country name to which user belongs.

Guidelines Table It provides the guidelines for helping the users.

Level Table It stores the level types.


25

Question Bank Table It is bank for storing the questions of different categories.

Question Paper Table It saves the question papers uploaded by users

Results Table It saves and displays the results of tests to users.

Roles Table It defines the different roles assigned to users.

State Table It stores the state name to which user belongs.

Test Detail Table It gives the proper detail of the test.

Topic Table It is the warehouse for different types of topics.

Users Table It stores the full detail of the users for using the site.


26

� DATA TYPES:

TABLE NAME: ANSWER

Column Name DATA TYPE LENGTH CONSTRAINTS

AnswerID BigInt 8 Primary Key

AnswerSubject VarChar 250 _

AnswerCorrect VarChar 250 _

AnswerDescription VarChar 250 _

ANSWER TABLE DESCRIPTION

Column Name DESCRIPTION

AnswerID This is the primary key of the Answer table.


27

AnswerSubject It tells about the subject of the question.

AnswerCorrect It gives the information whether the answer is correct or not.

AnswerDescription It describes the answer and gives information about the answer.

TABLE NAME: CATEGORIES


CategoryID BigInt 8 Primary Key

CategoryName VarChar 50 _

PageName LongVarChar 16 _

LastUpdate DBTimeStamp 4 _

RecentHits BigInt 8 _

Hits BigInt 8 _

CATEGORIES TABLE DESCRIPTION


28


CategoryID This is the primary key of the Category table.

CategoryName It tells about the name of the Category.

PageName It gives the description of the page.

LastUpdate It gives the information of the last updation.

RecentHits It gives the information about the recent hits.

Hits It gives the statistics of the popularity of the fields.

TABLE NAME: CITY


CityID BigInt 8 Primary Key


29

CityName VarChar 50 _

CITY TABLE DESCRIPTION


CityID It is the primary key of the City table.

CityName It gives the name of the city.

TABLE NAME: CONTACT


Name VarChar 50 _

EmailID VarChar 50 _

Subject VarChar 50 _

Message LongVarChar 16 _


30

ContactID BigInt 8 Primary Key

CONTACT TABLE DESCRIPTION


Name It gives the name of the user.

EmailID It gives the EmailID of the user.

Subject It gives the subject of the message given by the user.

Message It explains the description of the message.

ContactID It is a primary key; It gives the contactID of the user.

TABLE NAME: COUNTRY


CountryID BigInt 8 Primary Key

CountryName VarChar 50 _


31

StateID BigInt 8 Foreign Key

COUNTRY TABLE DESCRIPTION


CountryID It is the primary key of the Country table.

CountryName It gives the name of the Country to which user belongs.

StateID It is foreign key of the country table which refers to state table.

\TABLE NAME: GUIDELINES



32

GuidelinesID BigInt 8 Primary Key

GuidelinesDescription VarChar 250 _

GuidelinesHelp LongVarChar 16 _

GUIDELINES TABLE DESCRIPTION


GuidelinesID It is the primary key of the Guidelines table.

GuidelinesDescription It gives the description about the guidelines.

GuidelinesHelp It gives help to user about the guidelines by explaining them.

TABLE NAME: LEVEL


33


LevelID BigInt 8 Primary Key

LevelDescription VarChar 250 _

LevelType VarChar 50 _

LEVEL TABLE DESCRIPTION


LevelID It is the primary key of the Level table.

LevelDescription It gives the description about the level.

LevelType It tells about the type of the table.


34

TABLE NAME: QUESTION BANK


QuestionID BigInt 8 _

QuestionCategory VarChar 50 _

QuestionBankID BigInt 8 Primary Key

RoleName VarChar 50 _

UserID BigInt 8 _

QUESTION BANK TABLE DESCRIPTION


QuestionID It is the ID given to each and every question.

QuestionCategory It gives the categories under which question lies.

QuestionBankID It is the primary key of the question


35

bank table

RoleName It describes the role of the users.

UserID It is a foreign key of question bank table. And its refers to the users is the user table.

TABLE NAME: QUESTION PAPER


QuestionpaperID BigInt 8 Primary Key

QuestionPaperType VarChar 50 _

QuestionPaperText LongVarChar 16 _

QuestionPaperSubject VarChar 50 _

QuestionPaperAnswerID VarChar 50 _

QuestionPaperCategory VarChar 50 _

QuestionPaperTiming Binary 8

QUESTION PAPER TABLE DESCRIPTION


36


QuestionpaperID This is the primary key of the Question paper table.

QuestionPaperType It tells about the type of the Question paper.

QuestionPaperText It stores the text about the questions.

QuestionPaperSubject It gives the information about the subject of the question paper.

QuestionPaperAnswerID ID provided to the question paper answer.

QuestionPaperCategory It gives the information about the categories of the question papers.

QuestionPaperTiming It stores the timing information for the tests.

TABLE NAME: RESULTS


UserID BigInt 8 Primary Key


37

UserEmail VarChar 50 _

AnswerSheetNumber VarChar 50 _

UserRegNumber VarChar 50 _

Result VarChar 50 _

Feedback VarChar 50 _

RESULTS TABLE DESCRIPTION


UserID This is the primary key of the Results table.

UserEmail It gives the email of the user.

AnswerSheetNumber It gives the information about the Answer sheet number.

UserRegNumber It stores the users Registration number.

Result It stores the Results of the exam.


38

Feedback It stores the feedback given by the users.

TABLE NAME: ROLES


RoleID BigInt 8 Primary Key

Role VarChar 50 _

ROLES TABLE DESCRIPTION


RoleID It is the primary key of the Role table.

Role It stores the roles assign to the users.

TABLE NAME: STATE



39

StateID BigInt 8 Primary Key

StateName VarChar 50 _

STATE TABLE DESCRIPTION


StateID It is the primary key of the State table.

StateName It stores the name of the different states.

TABLE NAME: TEST DETAIL


TestID BigInt 8 Primary Key

TestName VarChar 50 _

Objective Text 16 _

MaxTime TimeStamp 8 _

Downloadable Int 4 _


40

Online Int 4 _

ByWhom VarChar 50 _

CategoryID BigInt 8 Foreign Key

TEST DETAIL TABLE DESCRIPTION


TestID This is the primary key of the Test Detail table.

TestName It stores the name of the test.

Objective It stores the aim or use of the test.

MaxTime It provides the maximum time allotted for the tests.

Downloadable It tells whether the test is downloadable or not.

Online It tells whether the test is online or not.

ByWhom It provides the information by whom the test is created.


41

CategoryID It is foreign of this table, and referring to the category table.

TABLE NAME: TOPIC


TopicID VarChar 10 Primary Key

TopicSub VarChar 15 _

TopicCategory VarChar 20 _

TopicLevel VarChar 20 _

TopicType VarChar

20 _

TopicText VarChar

20 _

TOPIC TABLE DESCRIPTION


TopicID This is the primary key of the Topic


42

table.

TopicSub It provides the information about the subject of the topic.

TopicCategory It tells about the category type of the topic.

TopicLevel It assigns and displays the level of the topic.

TopicType It stores the type of the topic.

TopicText It stores the text information regarding topic chosen.

TABLE NAME: USERS


UserID BigInt 8 Primary Key

UserName VarChar 20 _

EmailID VarChar 50 _

UserAddress VarChar 299 _


43

UserBirthDate DateTime

16 _

UserQualifications VarChar

50 _

DateOfRegistration DateTime

16 _

Roles VarChar

255 _

RecentActivityOn DateTime

16 _

Password VarChar

50 _

Locked Bit

1 _

OpenID VarChar

299 _

USERS TABLE DESCRIPTION


UserID This is the primary key of the Users table.


44

UserName It stores the username assigned to different users.

EmailID It stores the email id of the users.

UserAddress It stores the address of the users.

UserBirthDate It stores the birth date of the users.

UserQualifications It stores the qualifications of the users.

DateOfRegistration It stores the date of registration of users.

Roles It stores the different roles assigned to users.

RecentActivityOn It is the timestamp for storing the recent activities done by the users.

Password It assigns and stores the password assigned to the users regarding to their usernames.

Locked It checks whether the account is locked or not.

OpenID It stores the open id of the user if any.


45

� DATA FLOW DIAGRAM(DFD)

It is a way of expressing system requirement in a graphical form; this leads to a modular design. It is also known as bubble chart, has the purpose of clarifying system requirements and identifying major transformations that will become program in system design. So it is the starting point of the design phase that functionally decomposes the requirement specifications down to the lowest level of details. A DFD consist of a series


46

of bubbles joined by lines. The bubbles represent data transformation and the lines represent data flows in the system.

� DFD SYMBOLS:

= Source or Destination of data

= Data flow

= Process that transform data flow

= Store Data

� INTRODUCTION :

This section describes the symbols used in the DFD. The following below illustration

1.1 shows the symbols as they appear in the diagram control panel.


47

Figure 1.1

� Data Process:

A data process transforms data values.

You can make a distinction between the following types of processes:

Process Type Indicates

High-level Process containing nonfunctional components such as data stores or external objects that cause side effects

Low-level Pure function without side effects, such as the sum of two numbers

The name of a process is usually a description of the transformation it performs.

� There are Three Sorts of Transformation:

• Transformation of the structure, for example, reformatting

• Transformation of information contained in data


48

• Generation of new information

If we open a process, we can either create a new DFD or open an existing DFD in which

the process is specified. The data flows of the opened process are connected in the new

diagram to the process with the name of the opened process. Vertices, and the flows and

objects connected to them, are transferred with the flows that are connected to the

decomposed process. If a data process has decomposition at a lower level, an asterisk is

placed inside the ellipse.

� Data Store:

A data store stores data passively for later access. A data store responds to requests to

store and access data. It does not generate any operations. A data store allows values to

be accessed in an order different from the order in which they were generated.

Input flows indicate information or operations that modify the stored data such as adding

or deleting elements or changing values. Output flows indicate information retrieved

from the store; this information can be an entire value or a component of a value.

Actor:

An actor produces and consumes data, driving the DFD. Actors lie on the boundary of the

diagram; they terminate the flow of data as sources and sinks of data. They are also

known as terminators. Data flows between an actor and a diagram are inputs to and

outputs of the diagram. The system interacts with people through the actor.


49

� Anchor:

A DFD anchor provides a start or end point. In decomposition diagrams, anchors

represent the nodes connected to the decomposed process in the higher level diagram.

� Data Flow:

A data flow moves data between processes or between processes and data stores. As

such, it represents a data value at some point within a computation and an intermediate

value within a computation if the flow is internal to the diagram. This value is not

changed.

The names of input and output flows can indicate their roles in the computation or the

type of the value they move. Data names are preferably nouns. The name of a typical

piece of data, the data aspect, is written alongside the arrow.

� Result Flow:

A result flow is a data flow that generates an object used as the target of another

operation. The value of the flow is subsequently treated as an object, usually a data store.


50

� Control Flow:

A control flow is a signal that carries out a command or indicates that something has occurred. A control flow occurs at a discrete point in time. The arrow indicates the direction of the control flow. The name of the event is written beside the arrow. Control flows can correspond to messages in CCDs or events in STDs; however, because they duplicate information in the DFD, use them sparingly.

� Update Flow:

Update (or bidirectional) flows are used to indicate an update of a data store, that is, a read, change, and store operation on a data flow.


51

� REGISTRATION DFD

Is Member

Login

Is

Candidate

Register As

Candidate

or

Registration

Form

Administrato

r Checks

Registration

Form

Login as

Examiner

Login as

Candidate

Inbox of

Candidate or

Activation

Message

YES

NO

IF

IF

Send E-mail

Click on Link

to Activate

Data Store

Data entry


52

� CREATING AND MODIFYING QUESTION BANK DFD

Examiner

Administrator

If their exist

any

Question

Modify

Question bank

Create

Question bank

Select

Question

Bank

YES

NO

Data Store


53

� INVITE USERS THOSE ARE REGISTERED DFD

Examiner

Administrator

Stored Data

Check for

Registered

Candidates


54

� MOCK TESTS DFD

�

User Login

Select Test

Category,

Level and

User selects to perform

test


55

� PREPARING RESULTS DFD

Examiner

Administrator

Get the Test

Examiner

Administrator

Get the Test

Examiner

Administrator

Get the Test

Examiner

Administrator

Get the Test


56

� RESULT AND FEEDBACK DFD

Examiner

Administrator


57

� ENTITY RELATIONSHIP DIAGRAM

Entity relationship diagrams are a way to represent the structure and layout of a

database. It is used frequently to describe the database schema. ER diagrams are


58

very useful as the provide a good conceptual view of any database, regardless of the

underlying hardware and software.

An ERD is a model that identifies the concepts or entities that exist in a system and

the relationships between those entities. An ERD is often used as a way to visualize

a relational database: each entity represents a database table, and the relationship

lines represent the keys in one table that point to specific records in related tables.

ERDs may also be more abstract, not necessarily capturing every table needed

within a database, but serving to diagram the major concepts and relationships. This

ERD is of the latter type, intended to present an abstract, theoretical view of the

major entities and relationships needed for management of electronic resources. It

may assist the database design process for an e-resource management system, but

does not identify every table that would be necessary for an electronic resource

management database.

� OBJECTS:

There are three main objects on an ER Diagram: entities, relations and attributes.

These are joined together with lines.

� ENTITIES :

An entity is a concept or object in the database. Entities are concepts within the data

model. Each entity is represented by a box within the ERD. Entities are abstract

concepts, each representing one or more instances of the concept in question. An

entity might be considered a container that holds all of the instances of a particular

thing in a system. Entities are equivalent to database tables in a relational database,

with each row of the table representing an instance of that entity.


59

� ATTRIBUTES:

The Supplier Name, the Supplier Address, Telephone Number, and etcetera. A

given attribute belonging to a given entity occurrence can only have one value.

Therefore, if a supplier could have more than one address or telephone number then

this should be determined before defining the attributes of thatentitytype.

In this example the defined entity may require two or three address and/or

telephone number attributes. It is the maximum practical instances of a given

attribute that should be catered for in the entity type definition.

� RELATIONSHIPS :

Relations are the connections between two or more entities. Relationship lines

indicate that each instance of an entity may have a relationship with instances of the

connected entity, and vice versa. Each entity type can always be described in terms

of attributes, and these attributes will apply to all occurrences of that given entity

type. In the camera shop example, all occurrences of the entity 'supplier' could be

described by an identifiable set of attributes, including:

� CARDINALITY:

The cardinality of a relation is how many instances there can be of each entity that

connects to the relation. For example, Then for each subject there are L students,

and M staff teach N subjects, as each member of staff may teach several courses. In

general, there are 3 different cardinalities:

• One to One: Where each entity is related to at most one of the other types of

entity. E.g. each husband has at most one current wife, and each wife has at

most one current husband.


60

• One to Many: Where each instance of an entity on one side is related to

numerous instances of the other type of entity. E.g. a footballer is related to

only one club, but that club may have many footballers.

• Many to Many: A teacher may teach several subjects at different times, and

a subject may have several teachers for different days.

� CONSTRAINTS: For each attribute there may be several constraints placed upon

what values it can take:

• Domain of the value

• Format of values (dd/mm/yyyy)

• Range of values (e.g. 1 to 10)

• Allow nulls? Does the attribute have to contain a value for each instance of the

entity?

S C H O O L

S T U D E N TE a ch scho o l e n ro lls

a t le ast ze ro

a nd a t m o st m an y

stu de n ts

E a ch s tud en t a ttend s

a t le ast one

an d a t m os t on e

sch oo l


61

USER Belong

State

City

Country

Roles Has

QuestionPaper

Results

Topic Answers

Belong

Belong Has

Create Prepare

Has

Have

Level

role

roleID

userID

Username

emailID password

role

userqualification

q.p timing

q.p subject

countryID

countryname

stateID

stateID statename

cityname city

levelID leveld

useremail

feedback

Result

UserregnoAnswersheetno.

q.pID


62

WEB FORMS

In below, screens show the homepage of (i-practice-tests.com) website

� HOME PAGE FORM

leveltype

Topicsub

topiclevel

anssubject anscorrect

ansID


63

This form is basically used for candidate registration form, the candidate click on the register, and then shows the register form. And fill it.

� REGISTER FORM


64

� FEEDBACK FORM:


65

� SCHOLARSHIP FORM


66

Then the user wants to register then he/she click on APPLY FORM


67

� ABOUT US FORM


68

� ABOUT US FORM IN SERVICES


69

� Select the test category……

In this project the candidate, search any category. Using above search box.

� Using these alphabets

The users click on any alphabet, then shows the category according to the user choice.

In below figure, show the candidate click ALL button.the candidate seen all the topics.


70

� CHOOSE CATEGORY ACC. TO USER CHOICE……


71

� ADVERTISE WITH US FORM


72

� ADMIN CONTROL PANEL


73

The administrator clicks the edit button then opens below window, then administrator change/ modify the name/ emailID

EDIT:

DELETE:


74

ROLES:


75

EDIT THE ROLE NAME:


76

QUESTION BANK FORM

ENTER THE DATA


77

QUESTION PAPER FORM


78

ENTER THE DATA

CATEGORY FORM


79

ENTER THE DATA


80

What are the various steps and then How to join the I-practice-tests community?


81

INTEGRATED SITES


82


83

Join in google site


84


85


86


87

If u have already a member of this site than please sign in.


88


89


90

INVITE THE USERS


91

INVITE THE USERS


92

JOIN IN YAHOO SITE


93


94


95

XANGA mail integrated with i-practice-tests.com

INVITE UR FRNDS

>> main entry


96

My space.com integrated with i-practice-tests.com


97

Facebook integrated with i-practice-tests.com


98


99

� CODING

BUSINESS OBJECTS

Business objects are basically objects made for accessing the functions like SAVE Entry, DELETE Entry, GET Entry, and GET All

(Code Listing)

• BO: USER

Imports Microsoft.VisualBasic Imports System.Data.SqlClient Imports System.Data Imports EcologicCorporationLibrary Public Class clsUsers Inherits EcologicCorporationLibrary.InLineBaseServices Dim mRoles As String Dim mLastError As String Public Property Roles() As String Get Return mRoles End Get Set(ByVal value As String) mRoles = value End Set End Property


100

Public Property LastError() As String Get Return mLastError End Get Set(ByVal value As String) mLastError = value End Set End Property Public Function IsValidUser(ByVal UserName As String, ByVal Password As String) As Boolean Try Dim Sql As String Sql = "Select * From Users Where EmailId=@UserName And Password=@PassWord" Dim cmd As New SqlCommand cmd.CommandText = Sql cmd.Parameters.Add("@UserName", Data.SqlDbType.VarChar).Value = UserName cmd.Parameters.Add("@Password", Data.SqlDbType.VarChar).Value = FormsAuthentication.HashPasswordForStoringInConfigFile(Password, "md5") Dim dt As DataTable dt = GetDataSet(cmd).Tables(0) If dt.Rows.Count > 0 Then Roles = GetString(dt.Rows(0)("Roles")) Dim dr As DataRow dr = dt.Rows(0) dr.BeginEdit() dr("RecentActivityOn") = GetSQLServerDate() dr.EndEdit() UpdateDataTable(dt, "Users") IsValidUser = True Else IsValidUser = False LastError = "Invalid UserName/Password!" End If dt.Dispose() dt = Nothing Catch ex As Exception Throw ex


101

End Try End Function Public Overrides Function DeleteEntry() As Boolean Try ' Please make sure if this record can be deleted, confirmly. Dim Sql As String Sql = "Delete From Users Where UserId=" & KeyValue DeleteEntry = (ExecuteNonQuery(Sql) > 0) Catch ex As Exception Throw ex End Try End Function Public Overrides Function GetEntry() As Boolean Try Dim Sql As String Sql = "Select * From Users Where UserId=" & KeyValue DataSet.Tables.Clear() DataSet.Tables.Add(GetDataTable(Sql, "Users")) Catch ex As Exception Throw ex End Try End Function Public Overrides Function SaveEntry(ByRef dr As DataRow) As Boolean Try ' Validate the Entry. ClearErrors() CheckRequiredField(GetString(dr("EmailId")), "Email Id", 50) CheckForDuplication("Users", "EmailId", "UserId", GetString(dr("EmailId")), KeyValue, "Email Id") CheckRequiredField(GetString(dr("Roles")), "Roles", 256) If IsValid Then SaveRow(dr) UpdateDataTable(DataSet.Tables(0).GetChanges, "Users") Else Return False End If Return True Catch ex As Exception


102

Throw ex End Try End Function Public Function GetTotalUsers() As Int16 Try Dim sql As String = "Select count(*) from users " GetTotalUsers = ExecuteScalar(sql) Catch ex As Exception Throw ex End Try End Function Public Overrides Function GetAll(ByVal mts As Short, ByVal cacheflag As Boolean) As System.Data.DataTable ' Return "" End Function End Class

• BO: QUESTION PAPER

Imports Microsoft.VisualBasic Imports System.Data.SqlClient Imports System.Data Imports EcologicCorporationLibrary Class clsQuestionPaper Inherits EcologicCorporationLibrary.BaseServices Public Overrides Function DeleteEntry() As Boolean Try Dim Sql As String Sql = "Delete From QuestionPaper Where QuestionPaperID =" & KeyValue DeleteEntry = (ExecuteNonQuery(Sql) > 0) Catch ex As Exception Throw ex End Try End Function


103

Public Overrides Function GetEntry() As Boolean Try Dim Sql As String Sql = "Select * From QuestionPaper Where QuestionPaperID =" & KeyValue DataSet.Tables.Clear() DataSet.Tables.Add(GetDataTable(Sql, "QuestionPaper")) Catch ex As Exception Throw ex End Try End Function Public Overrides Function SaveEntry(ByRef dr As System.Data.DataRow) As Boolean Try ClearErrors() '''CheckRequiredField(GetString(dr('QuestionPaperID')) CheckForDuplication("QuestionPaper", "QuestionPaperText", "QuestionPaperID", GetString(dr("QuestionPaperText")), KeyValue, "QuestionPaperText") If IsValid Then SaveRow(dr) UpdateDataTable(DataSet.Tables(0).GetChanges, "QuestionPaper") Else Return False End If Return True Catch ex As Exception Throw ex End Try End Function Public Overrides Function GetAll(ByVal mts As Short, ByVal cacheflag As Boolean) As System.Data.DataTable ' Return "" End Function End Class

• BO: RESULTS

Imports Microsoft.VisualBasic


104

Imports System.Data.SqlClient Imports System.Data Imports EcologicCorporationLibrary Class clsResults Inherits EcologicCorporationLibrary.BaseServices Public Overrides Function DeleteEntry() As Boolean Try Dim Sql As String Sql = " Delete From Results Where ResultsID = " & KeyValue DeleteEntry = (ExecuteNonQuery(Sql) > 0) Catch ex As Exception Throw ex End Try End Function Public Overrides Function GetEntry() As Boolean Try Dim Sql As String Sql = " Select * From Results Where ResultsID = " & KeyValue DataSet.Tables.Clear() DataSet.Tables.Add(GetDataTable(Sql, "Results ")) Catch ex As Exception Throw ex End Try End Function 'CopyRight @Ecologic Corporation , Chandigarh : Tel:9872856485 Public Overrides Function SaveEntry(ByRef dr As System.Data.DataRow) As Boolean Try ClearErrors() '''CheckRequiredField(GetString(dr('ResultsID')) '''CheckForDuplication('City', 'CityName', 'CityID', GetString(dr('CityName')), KeyValue, 'City Name') If IsValid Then SaveRow(dr) UpdateDataTable(DataSet.Tables(0).GetChanges, "Results") Else Return False


105

End If Return True Catch ex As Exception Throw ex End Try End Function Public Overrides Function GetAll(ByVal mts As Short, ByVal cacheflag As Boolean) As System.Data.DataTable ' Return "" End Function End Class

WEB SERVICES

A Web service is an application component that exposes useful functionality to other Web services and applications through standard Web service protocols. Provides a way to describe its interfaces in detail, allowing developers to build client applications that talk to it. The description is provided in an XML document called a Web Services Description Language (WSDL) document. Describes its messages by using an XML schema.

(Code Listing)

• WS: QUESTIONPAPER

Imports System.Web

Imports System.Web.Services

Imports System.Web.Services.Protocols

Imports EcologicCorporationLibrary


106

<WebService(Namespace:="http://tempuri.org/")> _

<WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _

<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _

Public Class ExamCategory

Inherits System.Web.Services.WebService

<WebMethod()> _

Public Function GetQuestionPaper(ByVal prefixText As String, ByVal count As Int16) As String()

Dim S() As String

Dim Sql As String

Sql = "Select QuestionPaperType From QuestionPaper Where QuestionPaperType Like '" & prefixText & "%' Order By QuestionPaperType"

Dim dt As Data.DataTable = GetDataTable(Sql)

Dim Knt As Long

If dt.Rows.Count > count Then

Knt = count - 1

Else

Knt = dt.Rows.Count - 1

End If

ReDim S(Knt)

Dim I As Integer

For I = 0 To Knt

S(I) = dt.Rows(I)("QuestionPaperType")

Next


107

Return S

End Function

<WebMethod()> _

Public Function GetQuestionPaperSubject(ByVal prefixText As String, ByVal count As Int16) As String()

Dim S() As String

Dim Sql As String

Sql = "Select QuestionPaperSubject From QuestionPaper Where QuestionPaperType Like '" & prefixText & "%' Order By QuestionPaperSubject"


Dim Knt As Long


Knt = count - 1

Else


End If

ReDim S(Knt)

Dim I As Integer

For I = 0 To Knt

S(I) = dt.Rows(I)("QuestionPaperSubject")

Next

Return S

End Function

<WebMethod()> _


108

Public Function GetCountryName(ByVal prefixText As String, ByVal count As Int16) As String()

Dim S() As String

Dim Sql As String

Sql = "Select CountryName From QuestionPaper Where Country Like '" & prefixText & "%' Order By CountryName"


Dim Knt As Long


Knt = count - 1

Else


End If

ReDim S(Knt)

Dim I As Integer

For I = 0 To Knt

S(I) = dt.Rows(I)("CountryName")

Next

Return S

End Function

End Class


109

� PROJECT TESTING

� What is testing?

Testing is finding out how well something works. In terms of human beings, testing tells what level of knowledge or skill has been acquired. In computer hardware and software development, testing is used at key checkpoints in the overall process to determine whether objectives are being met. For example, in software development, product objectives are sometimes tested by product user representatives. When the design is complete, coding follows and the finished code is then tested at the unit or module level


110

by each programmer; at the component level by the group of programmers involved; and at the system level when all components are combined together.

� Testing types

�Black box testing

It takes an external perspective of the test object to derive test cases. These tests can be functional or non-functional, though usually functional. The test designer selects valid and invalid inputs and determines the correct output. There is no knowledge of the test object's internal structure.

This method of test design is applicable to all levels of software testing: unit, integration, functional testing, system and acceptance. The higher the level, and hence the bigger and more complex the box, the more one is forced to use black box testing to simplify. While this method can uncover unimplemented parts of the specification, one cannot be sure that all existent paths are tested.

� White box testing

An internal perspective of the system to design test cases based on internal structure. It requires programming skills to identify all paths through the software. The tester chooses test case inputs to exercise paths through the code and determines the appropriate outputs. In electrical hardware testing, every node in a circuit may be probed and measured; an example is in-circuit testing (ICT).

Since the tests are based on the actual implementation, if the implementation changes, the tests probably will need to change, too. For example ICT needs updates if component values change, and needs modified/new fixture if the circuit changes. This adds financial resistance to the change process, thus buggy products may stay buggy. Automated optical inspection (AOI) offers similar component level correctness checking without the cost of ICT fixtures; however changes still require test updates.


111

While white box testing is applicable at the unit, integration and system levels of paths within a unit, it can also test paths between units during integration, and between subsystems during a system level test. Though this method of test design can uncover an overwhelming number of test cases, it might not detect unimplemented parts of the specification or missing requirements, but one can be sure that all paths through the test object are executed.

� Software Testing

Software Testing is an empirical investigation conducted to provide stakeholders with information about the quality of the product or service under test, with respect to the context in which it is intended to operate. Software Testing also provides an objective, independent view of the software to allow the business to appreciate and understand the risks at implementation of the software. Test techniques include, but are not limited to, the process of executing a program or application with the intent of finding software bugs. It can also be stated as the process of validating and verifying that a software program/application/product meets the business and technical requirements that guided its design and development, so that it works as expected and can be implemented with the same characteristics.

Software Testing, depending on the testing method employed, can be implemented at any time in the development process, however the most test effort is employed after the requirements have been defined and coding process has been completed.

� Unit Testing

In computer programming, unit testing is a software verification and validation method where the programmer gains confidence that individual units of source code are fit for use. A unit is the smallest testable part of an application. In procedural programming a unit may be an individual program, function, procedure, etc., while in object-oriented programming, the smallest unit is a method, which may belong to a base/super class, abstract class or derived/child class.

Unit testing can be done by something as simple as stepping through code in a debugger; modern applications include the use of a test framework such as xUnit.

Ideally, each test case is independent from the others: substitutes like method stubs, mock objects], fakes and test harnesses can be used to assist testing a module in isolation. Unit tests are typically written and run by software developers to ensure that code meets its requirements and behaves as intended. Its implementation can vary from being very manual (pencil and paper) to being formalized as part of build automation.


112

� Integration Testing

'Integration testing' (sometimes called Integration and Testing, abbreviated I&T ) is the activity of software testing in which individual software modules are combined and tested as a group. It occurs after unit testing and before system testing.

Integration testing takes as its input modules that have been unit tested, groups them in larger aggregates, applies tests defined in an integration test plan to those aggregates, and delivers as its output the integrated system ready for system testing.

� System testing or Functional testing

System testing of software or hardware is testing conducted on a complete, integrated system to evaluate the system's compliance with its specified requirements. System testing falls within the scope of black box testing, and as such, should require no knowledge of the inner design of the code or logic.

As a rule, system testing takes, as its input, all of the "integrated" software components that have successfully passed integration testing and also the software system itself integrated with any applicable hardware system. The purpose of integration testing is to detect any inconsistencies between the software units that are integrated together (called assemblages) or between any of the assemblages and the hardware. System testing is a more limiting type of testing; it seeks to detect defects both within the "inter-assemblages" and also within the system as a whole.

� Acceptance Testing

In engineering and its various sub disciplines, acceptance testing is black-box testing performed on a system (e.g. software, lots of manufactured mechanical parts, or batches of chemical products) prior to its delivery. It is also known as functional testing, black-box testing, release acceptance, QA testing, application testing, confidence testing, final testing, validation testing, or factory acceptance testing.

In software development, acceptance testing by the system provider is often distinguished from acceptance testing by the customer (the user or client) prior to accepting transfer of ownership. In such environments, acceptance testing performed by the customer is known as user acceptance testing (UAT). This is also known as end-user testing, site (acceptance) testing, or field (acceptance) testing.


113

www.i-practice-tests.com is tested with step by step into different cases.

cases Test condition Test description Expected results Testing type

1. Open the project 1. Open the project in

internet explorer (IE).

The login page should get loaded

properly.

Unit testing

2. Check the image clarity in

IE.

3. Check the image size.

Image should not change.

Unit testing

2. Open the project and check the resolution

setting and monitor size

1. Check changing the

resolution of the monitor and monitor size.

2. Check for the copyright

message on each page.

1. The page should not same should look the

same.

2. Copyright message should be present on the homepage and all

other pages.

Unit testing

3. Open the project and check the flow of the

registration

1. Check the GUI of the page in IE.

2.check the GUI of the page in

Mozilla Fire fox or Netscape or

other

1. The GUI of the page should be

proper.

2. The GUI of the page should be

proper.

Functional testing


114

3.Open the project let the page get load

4.click on the Sign up option

5.Check fro search something

by putting the keyword in the

search box

3.The page will get loaded properly

4. the page will redirect to the Registration form page

5. The search option doesn’t

work.

4. Open the project and check the functionality of

the login page with, without, wrong and

correct data

1.Open the project

2. Click on the "sign in" button with out entering

any data

3.Enter usercode and click on the

login button

4. Enter just password not usercode and

click login button

5. Enter correct usercode (sahil) and enter wrong

password (sahil1) and click

1. The page will get loaded

2. error message should get displayed

3. error message about the

password should get displayed

4. error message about the user

should get displayed

5. Login failed: Please check your usercode

and/or password error message

should get

System testing


115

login button

6. Enter wrong usercode (sahil1)

and correct password (sahil) and click login

button

7. Check the tab order for this

login part.

displayed

6. Login failed: Please check your usercode and/or password error message should get displayed

7. It should go to user code

password login and then change password and

forgot password and sign up

button.

5. Start the project and enter the usercode and

password and sign in and check the third option i.e.

send invitation option

1. Click on the select send

invitation option.

2.Check the GUI of the page and

the spelling mistakes on the

page

3.Without entering anything click on submit

button

4. Enter the name and the click on

1. Should display the referral form.

2. There should be proper

alignment of the page and no

spelling mistakes on the page.

3. It should prompt for

entering the valid usercode.

4. It should prompt a

Integration testing


116

submit button.

5.Enter the phone number in characters format

6.Enter valid name

qualification year of passing, phone

number and email id,

interested field and technical skills and then click on submit

button.

message to enter the remaining

details.

5. It should not take it.

6. Should get a message of successfully

added referral and a button to

add another referral.


117

� FUTURE SCOPE

www.i-practice-tests.com is a website for doing online testing of various students based on 400 categories of exams.

I- practice-test is also a platform for the trainers to create tests/exams/mock test/quizzes for the students, who want to exam preparation before the exams.

� Internationalization

Internationalization means globalization. It is aimed at developers and team leaders wanting to create applications which run in more than one language and/or region (country).

� Multilingual

Multilingual means the application support different languages. It is localization. So it can be very helpful for those candidates, they does not understand the English language.

� Video based online tests

Video-based online tests may offer several advantages. First, we have noticed that students attend to video clips during class much more when they know that they will see clips during an examination.


118

� New categories are added for very much helpful for all the candidates.

� This is very secure website.

� Adequate validation checks for data entry

� Smooth flow of data without any hurdles.

� Facility to update data from time to time.

� LIMITATION OF THE PROJECT

� The first limitation is the basic limitation of every online project i.e. without internet the website does not open.

� It needs the high speed connection of the internet.

� All the candidates do not give the test without registration.

� Only English medium people gave the test, not in Hindi or Punjabi.

� It does not follow any accredited authority or standard in testing.

� It maintains is own quality standard.


119

� REFERENCES

� BIBLIOGRAPHY

� VB.NET Black Book

� ASP.Net 3.5 Robert Foster

� WEBSITES

• www.asp.net

• www.logicatwork.info

• Online MSDN


120

project_idea_how to create mock exam portal with sample report

Documents