Online Examination

CERTIFICATE

This is to certify that this report embodies the original work done by
Sanjeev kumar, Rajnish kumar, Ravi kant verma during thisproject
submission as a partial fulfillment of the requirement for the System
Design Project of Bachular of Computer Application IV Semester, of the
Punjab College Of Technical Education.

ACKNOWLADGEMENT:-

The satisfaction that accompanies that the successful completion of any

task would be incomplete without the mention of people whose
ceaseless cooperation made it possible, whose constant guidance and
encouragement crown all efforts with success. We are grateful to our
project guide Mr.Harmeet singh gill for the guidance, inspiration and
constructive suggestions that helpful us in the preparation of this project.
We also thank our colleagues who have helped in successful completion
of the project.

Sanjeev kumar
Ralnish kumar
Ravi kant Verma
3.OVERVIEW OF PROJECT:-
3.1. Purpose:-
 This Web Application provides facility to conduct online
examination world wide.
 It saves time as it allows number of students to give the exam at a
time and displays the results as the test gets over, so no need to
wait for the result. It is automatically generated by the server.
 Administrator has a privilege to create, modify and delete the test
papers and its particular questions.
 User can register, login and give the test with his specific id, and
can see the results as well.
4.NTRODUCTION TO PROJECT:-
4.1.Purpose:-
 This Web Application provides facility to conduct online
examination world wide.
 It saves time as it allows number of students to give the exam at a
time and displays the results as the test gets over, so no need to
wait for the result. It is automatically generated by the server.
 Administrator has a privilege to create, modify and delete the test
papers and its particular questions.
 User can register, login and give the test with his specific id, and
can see the results as well.

4.2.Technologies used:-
This project is a web application that is developed in ASP.NET
having DB2 as back end.
1. Database Design (DB2)
2. Input Design (ASP.NET)
3. Coding (VB.NET)
4.3. Hardware Interface:-
Client Side:
Internet Explorer: 6.0
Processor : Pentium IV 2.0 and above.
RAM : 256 MB
Server Side:
Processor : Pentium IV 2.0 and above.
RAM : 1 GB
Disk space : 4GB

4. Software
4.4. Software Interface:-
Client Side: .NET Framework, Web Browser, Windows XP/2000/Vista
Web Server: .NET Framework, Windows XP/2000/Vista
Data Base Server: DB2
4.5. Constraints:-
 User interface is only in English i.e. no other language option is
available.
 User can login only with his assigned username and password i.e. no
guest facility is available.
 Limited to HTTP/HTTPS.
5. DATABASE INTITIAL STUDY
A. ANALYZE THE COMPANY SITUATION
1. OPERATING ENVIRONMENT:-

2. ORGANIZATIONAL STRUCTURE
A. DEFINE PROBLOMS AND CONSTRAINTS:-
The first problem is that there are loads of hard copied documents being
generated. This brings us to the age-old discussion of keeping information in the
form databases versus keeping the same on sheets of paper. Keeping the
information in the form of hard-copied documents leads to the following problems:

 Lack of space:-
It becomes a problem in itself to find space to keep the
sheets of paper being generated as a result of the ongoing discussion. The
documents being generated are too important to be ill-treated.
 Filing poses a problem:-
Filing the documents categorically is a timeconsuming
and tedious exercise.
 Filtering is not easy :-
It becomes hard to filter relevant documents for the
irrelevant ones if the count of the same crosses a certain manageable number.
 Reviewing becomes time-consuming:-
All the process done manually at the
centers and all the records are maintainedon the papers. So the maintenance of
the record is very difficult in thedepartments and as well as it’s very difficult for
the workers to check therecord. The Existing system is paper based, time
consuming, monotonous, lessflexible and provides a very hectic working
schedule. The chance of loss ofrecords is high and also record searching is
difficult. Maintenance of thesystem is also very difficult and takes lot of time.
 Result Processing is slow due to paper work and requirement of staff.

 Constraints, Assumptions, Dependencies

Constraints:-
As this system is based on client server technology, so for normal
operation minimum of 64 MB RAM will be required on all clients.

Assumptions:-
In general it has been assumed that the user has complete
knowledge of the system that means user is not a naïve user. Any data entered by
him/her will be valid. To make the software as user friendly as possible but at the
same time keeping in minds user requirements.
 Server OS should be Windows NT/2000/XP.
 Client PC should be Windows 9X/NT/WorkStation or Windows 2000
with latest service pack.

 Dependencies:-
It depends that the one should follow the international
standards for the generating the User ID & should fill the related information in the
proper format.

B. DEFINE OBJECTIVES:-
  Aims and Objective:-
The main purpose behind the proposed system
is to provide a comprehensive computerized system, which can capture, collate and
analyze the data from these wards and evaluate the impact of the program.
C. DEFINE SCOPE AND BOUNDARIES:-
Scope and boundaries of
the online examination system is very broad in terms of to other
manullally taking exams.
Few of them are:-
 This can used in educational institutions as well as in corporate
world.
 Can be used anywhere my time as it is a web based
application(user location doesn’t matter).
 No restriction that examiner has to be present when the candidate
takes the test.

6. DATABASE DESIGN- MAKES SURE FINAL PRODUCT

MEETS REQUIREMENTS. FOCUS ON DATA REUIREMENTS:-
A-CREATE THE CONCEPTUAL DESIGN
i- DATA ANALYSIS AND REUIREMENTS

1- FOCUS ON :
 INFOEMATION NEEDS:-
INFORMATION USRES:- The end user of
the software can be divided into two categories
 Administrator: Access to master forms for the purpose of data entry and
generation of reports.
 Operator:Access to his corresponding records and giving examination only.
C. INFORMATION SOURCES:-
 D. INFORMATION CONSTITUTION:-

2. DATA SOURSES:-

A. DEVELOPING AND GATHERING END USER DATA

VIEWS:-

 User needs a web-based system, which will remove all the above-
mentioned
 Problems that, the user is facing. The user wants a web-based system,
which
 will reduce the bulk of paperwork, provide ease of work, flexibility, fast
 record finding, modifying, adding, removing and generating the reports.
 How can the problem be redefined?
 We proposed our perception of the system, in accordance with the
problems
 of existing system by making a full layout of the system on paper. We
tallied
 the problems and needs by existing system and requirements. We were
further
 updating in the layout in the basis of redefined the problems. In
feasibility
 study phase we had undergone through various steps, which are
described as
 under:
 How feasible is the system proposed? This was analyzed by comparing
the
 following
 factors with both the existing system and proposed system.
 Cost
 The cost required in the proposed system is comparatively less to the
existing
 system.
 Effort
 Compared to the existing system the proposed system will provide a
better
 working environment in which their will be ease of work and the effort
 required will be comparatively less than the existing system.
 Time
 Also the time required generating a report or for doing any other work
will be
 comparatively very less than in the existing system. Record finding and
 updating will take less time than the existing system.
 Labor
 In the existing system the number of staff required for completing the
work is
 more
 while the new system will require quite less number of staff
B. DIRECT OBSERVATION OF CURRENT SYSTEM
C. INERFACING WITH SYSTEM DESIGN GROUP
2- BUSINESS RULES

Data Tables
1. cLanguage
2. cppLanguage

3. Operating System

4. DBMS
5. Users

6. Results

7. PassResult

8. MeritResult

9. FailResult
 E-R Diagram

User_name Password

Recieve USER REGISTER

Exaim_id
 User_name

Password

EXAM_RESULT REGISTRATION

User_id

Password

Result EXAMINATION Perform

C C++ OS DBMS

Figure: E-R Diagram

User_DB
Registration
User

Login
Registration

Results