A

PROJECT REPORT

ON

Online Examination

Submitted To

HEMVATI NANDAN BAHUGUNA GARHWAL UNIVERSITY

In Partial Fulfillment of the Requirement Of

BACHELOR OF COMPUTER APPLICATIONS

(Semester – VI)

By

Under The Guidance Of

 Certificate
This is to certify that the mini project entitled ‘Online Examination’
being submitted by________________________in partial fulfillment of the
requirement for the award of degree of Bachelor of Computer
Applications of the H.N.B.Garhwal University, is a record of bona fide
work carried out by him under my supervision.

Place :

Date : / /

Project Guide Project Coordinator

 Declaration

We, the undersigned hereby declare that the Project report

entitled Online Examination is designed, written and submitted by us

in partial fulfillment of the requirement for the award of the degree of

Bachelor of Computer Applications is our original work. The empirical

findings in this report are based on data collected by us through

discussion with the project guide.

We understand that, any such copying is liable to us

punishment in way the university authorities deem fit.

Place :

Date : / / Yours Faithfully,

Table of Contents

1. Introduction ......................................................................................................... 1
1.1. Project Overview .................................................................................... 1
1.2. Purpose................................................................................................... 1
1.3. Scope ...................................................................................................... 1
1.4. Definitions, Acronyms ............................................................................ 1

2. Functional or Specific Requirements .................................................................. 2

2.1. External Interface Requirements ............................................................ 4
2.1.1. Hardware Interfaces ................................................................................. 4
2.1.2. Software Interface .................................................................................... 4
2.1.3. Third Party Software Interfaces ............................................................... 4
2.1.4. Communication Protocol ......................................................................... 4
2.1.5. Assumption and Dependency .................................................................. 5
2.2. Non-Functional Requirements ................................................................. 5
2.3. Software System Attributes ..................................................................... 5
2.3.1. Browser Compatibility ............................................................................. 5
2.3.2. Security .................................................................................................... 6
2.3.3. Reliability................................................................................................. 6
2.3.4. Availability .............................................................................................. 6
2.3.5. Portability................................................................................................. 6
2.3.6. Performance ............................................................................................. 7
2.4. Database Requirements.......................................................................... 7
2.5. Technologies........................................................................................... 7
2.6. Software .................................................................................................. 7
2.7. Hardware ............................................................................................... 7
2.7.1. Server ....................................................................................................... 7
2.7.2. Client ........................................................................................................ 8

3. Analysis and Design ........................................................................................... 9

3.1. Use Case Diagram ................................................................................. 9
3.1.1. Use case Overview ................................................................................... 9
3.1.2. Add Faculty Use Case ............................................................................ 10
3.1.3. Login Use Case ...................................................................................... 10
3.1.4. Manage Student Groups Use Case ......................................................... 11
3.1.5. Student Registration Use Case ............................................................... 11
3.1.6. User Profile Edit Use Case .................................................................... 12
3.1.7. Manage Test Use Case ........................................................................... 13
3.1.8. Appear for Test Use Case ...................................................................... 14
3.1.9. Generate Result Use Case ...................................................................... 15
3.2. Activity Diagram .................................................................................. 16
3.2.1. Login Activity Diagram ......................................................................... 16
3.2.2. Manage Students Activity Diagram ....................................................... 17
3.2.3. Manage Tests Activity Diagram ............................................................ 18
3.2.4. Generate Result Activity Diagram ......................................................... 19
3.2.5. Student Registration Activity Diagram .................................................. 20
3.2.6. Answer Test Activity Diagram .............................................................. 21
3.3. Sequence Diagrams .............................................................................. 22
 3.3.1. Sequence Diagram Overview ................................................................ 22
3.3.2. Login Sequence Diagram ....................................................................... 23
3.3.3. Manage Student Groups Sequence Diagram ......................................... 24
3.3.4. Student Registration Sequence Diagram ............................................... 25
3.3.5. Manage Test Sequence Diagram ........................................................... 26
3.3.6. Appear for Test Sequence Diagram ....................................................... 27
3.4. Class Diagram...................................................................................... 28
3.5. Database Design .................................................................................. 29
3.5.1. Table: Student ........................................................................................ 30
3.5.2. Table: Question ...................................................................................... 30
3.5.3. Table: StudentQuestions ........................................................................ 30
3.5.4. Table: StudentTest ................................................................................. 31
3.5.5. Table: subject ......................................................................................... 31
3.5.6. Table: AdminLogin ................................................................................ 31
3.5.7. Table: Test ............................................................................................. 31
3.5.8. Table: Test Conductor............................................................................ 32

4. User Interfaces .................................................................................................. 33

4.1. Home Page ........................................................................................... 33
4.2. Registration .......................................................................................... 34
4.3. Login Interface ..................................................................................... 35
4.4. Create Questions Interface................................................................... 36

1. Scope for Enhancement .................................................................................... 39

3. References ......................................................................................................... 40
 Online Examination

1. Introduction
1.1.Project Overview
This project assesses students by conducting online objective tests. The tests would be
highly customizable. This project will enable educational institutes to conduct test and
have automated checking of answers based on the response by the candidates.

The project allows faculties to create their own tests. It would enable educational
institutes to perform tests, quiz and create feedback forms. It asks faculty to create
his/her set of questions. Faculty then creates groups and adds related students into the
groups. Further the tests are associated with specific groups so that only associated
students can appear for the test. The result of the response would be available to the
faculty of the question set. Further the result would also be mailed to the student. This
project would be helpful for creating practice tests, say for educational institutes and
as a feedback form.

1.2.Purpose
 Responses by the candidates will be checked automatically and instantly.

 Online examination will reduce the hectic job of assessing the answers given by
the candidates.

 Being an integrated Online Examination System it will reduce paper work.

 Can generate various reports almost instantly when and where required.

1.3.Scope
This project would be very useful for educational institutes where regular
evaluation of students’ is required. Further it can also be useful for anyone who
requires feedback based on objective type responses.

1.4.Definitions, Acronyms
The sub-section provides the definitions of all terms, acronyms, and
abbreviations used in this document to understand the SRS properly.

Sr.
Terms/Acronyms Description
No.
1.
Student User mostly a student who will appear for the examination
2. Another user mostly faculty member, lecturer or examiner who posts
Faculty
set of questions, the available options and correct answers.
3.
Administrator Super user, adds faculty and manages system.

Page 1 of 40
 Online Examination

2. Functional or Specific Requirements

Required software is for conducting on-line `objective’ type examination and
providing immediate results. The system should satisfy the following
requirements:

 Administrator Aspect

1. Taking backup of the database

2. Editing/Deleting/Creating the database.

3. Adding or expelling faculty

4. Changing the super password.

 Faculty Aspect

1. Logging into the system.

2. Sending invitations to specific student by mail

3. Accepting registrations of candidates

4. Adding the candidate to a group

5. Create/Edit/Delete candidate groups

6. Creating a test

7. Posting questions in the above test

8. Posting multiple options to respective question

9. Marking correct answer within the given options

10. Specifying to allow user defined answer

11. Time limit of the test if any.

12. Whether to randomize the questions

13. Whether to randomize the options displayed

14. To allow the test to be taken in practice mode where the correct
answer is shown immediately after the candidate selects an
option.

15. Set negative marks for wrong responses

 Student Aspect:

Page 2 of 40
 Online Examination

1. Requesting registration

2. Logging into the system.

3. Edit user information.

4. Selecting the test.

5. Selecting whether the test to be taken in practice mode where the

correct answer is shown immediately after the candidate selects
an option.

6. Appearing for the examination.

7. Printing the result at the end of the examination.

8. Reviewing the given responses.

9. Changing password.

10. Resetting of forgotten password

 Analysis

1. Authenticating users based on username and password

2. Keeping session track of user activity

3. Recording candidates’ responses to every question

4. Checking whether the given response is correct or not

5. Keeping history of test reports of all users

 Mailing

1. The reports are required to be mailed to the candidates on the

registered mail address.

2. Temporary password will be mailed to the user incase the user

forgets the password.

3. Invitations for the appearance for the new test will be mailed.

Page 3 of 40
 Online Examination

2.1.External Interface Requirements

2.1.1. Hardware Interfaces

Server side hardware

 Hardware recommended by all the software needed.

 Communication hardware to serve client requests

Client side hardware

 Hardware recommended by respective client’s operating system and web

browser.

 Communication hardware to communicate the server.

2.1.2. Software Interface

Server side software

 Web server software, Apache Tomcat

 Server side scripting tools: PHP

 Database tools: Sedna native XML DBMS.

 Compatible operating system: Linux

Client side software

 Web browser supporting JavaScript, refer Browser Compatibility 2.3.1

2.1.3. Third Party Software Interfaces

None

2.1.4. Communication Protocol

Following protocols are required to be permitted on the server side

 HTTP incoming request

 HTTPS incoming request if secure gateway is implemented

Following protocols are required to be permitted on the client side

 HTTP outgoing request

 HTTPS outgoing request if secure gateway is implemented

Page 4 of 40
 Online Examination

2.1.5. Assumption and Dependency

1. Username are valid email addresses of respective user

2. Administrator has the authority to add/delete faculty level accounts.

3. Faculty have the authority to approve/expel student

4. Faculty have the authority to change student’s group

2.2. Non-Functional Requirements

 System should be able handle multiple users

 Database updating should follow transaction processing to avoid data

inconsistency.

2.3.Software System Attributes

2.3.1. Browser Compatibility

The project being web based required compatibility with at least the popular web
browsers. Microsoft Windows XP and above, Linux and Macintosh being the current
popular operating system and Microsoft Internet Explorer, Mozilla Firefox, Opera,
Safari and Google Chrome being the currently popular web browsers.
Operating System

Win 2000 WinXP WinXPSP2 Win Vista Win 7 Mac OS Linux

Browsers

Modern Browsers

IE 8.0 N/A SUPP SUPP SUPP SUPP N/A N/A

IE 7.0 N/A N/A N/A N/A N/A

IE 6.0 N/A N/A N/A N/A N/A

Firefox 3.5 N/A SUPP N/A N/A N/A

Opera 9.23 N/A SUPP N/A N/A N/A

Safari 9.27 N/A SUPP N/A N/A SUPP

“Legacy” Old Browsers

IE5.5 N/A N/A N/A N/A N/A

Netscape N/A N/A N/A N/A N/A

Page 5 of 40
 Online Examination

2.3.2. Security

 Administrator has the highest authority to edit/delete/create database

 Faculty have the authority to add/expel students

 Students can only view their test records.

 Faculty can view all the test records of every student.

 Critical information like passwords should be transferred in encrypted form

 Passwords should be stored in encrypted form

 Password will not be mailed to the user in case user forgets password, instead
either temporary password or a password reset link will be sent.

2.3.3. Reliability

Data validation and verification needs to be done at every stage of activity.

 Validating user input

 Use of locking mechanism while updating database like transaction

processing

 Recovering the transaction using rollback.

2.3.4. Availability

The examination system being an online system should be available anytime.

Constraints:

Though the system should be available 24x7 some features may be restricted.

 Quiz creator may allow the specific test to be available only at certain time like
scheduled examination.

 The test may be time limited so the candidates appearing will have limited time to
answer the test.

2.3.5. Portability

 The web application will be built using PHP which has support to run on any platform
provided the required compilers are available.

 For database either XML or MySQL would be used, that too has extensive support
over many popular architectures and operating systems.

Page 6 of 40
 Online Examination

Constraints:

Portability would be limited to the support provided by the respective application vendor on
various architectures and operating environments.

2.3.6. Performance

The system would be used by multiple users at a time and may grow as time passes;
the system would need to implement multithreading to achieve acceptable
performance. Further a database connection pool may also be required for assigning
faster database connection.

2.4.Database Requirements
Database fields for questions and respective options must be in Unicode format to
handle non English characters

2.5.Technologies
This section lists all the technologies for the web based system.

 PHP scripting for server side scripting as it has a very strong support for XML and
MySQL.

 XML as database format: The database’ performance requirements are not very high
and the ability to have custom fields in case the quiz creator needs to add more than
expected answer options. This is limited in any other database management system
where we have to first specify the maximum number of fields.

 Apache as web server has a tight integration with PHP and is also available for
various popular platforms.

2.6.Software
Sublime text 3 for PHP and HTML and CSS coding.

Apache Tomcat as Web server

2.7.Hardware
The recommended hardware specified by the respective software would suffice the
needs. The memory and processing power needed would increase as the number of
users increase. The estimated hardware requirements are as specified.

2.7.1. Server

The minimum hardware as recommended by all of the software required on server

side say web server, operating system and development software

Page 7 of 40
 Online Examination

 Processing speed of 1.6 GHz

 1 GB of RAM

 Network interface

2.7.2. Client

The minimum hardware as recommended by all of the software required on client side
say web browser, operating system

 Minimum hardware depending on the operating system used

 True color visual display unit

 User peripherals for better interaction

Page 8 of 40
 Online Examination

3. Analysis and Design

3.1.Use Case Diagram
3.1.1. Use case Overview

Page 9 of 40
 Online Examination

3.1.2. Add Faculty Use Case

3.1.3. Login Use Case

Page 10 of 40
 Online Examination

3.1.4. Manage Student Groups Use Case

3.1.5. Student Registration Use Case

Page 11 of 40
 Online Examination

3.1.6. User Profile Edit Use Case

Page 12 of 40
 Online Examination

3.1.7. Manage Test Use Case

Page 13 of 40
 Online Examination

3.1.8. Appear for Test Use Case

Page 14 of 40
 Online Examination

3.1.9. Generate Result Use Case

Page 15 of 40
 Online Examination

3.2.Activity Diagram

3.2.1. Login Activity Diagram

Page 16 of 40
 Online Examination

3.2.2. Manage Students Activity Diagram

Page 17 of 40
 Online Examination

3.2.3. Manage Tests Activity Diagram

Page 18 of 40
 Online Examination

3.2.4. Generate Result Activity Diagram

Page 19 of 40
 Online Examination

3.2.5. Student Registration Activity Diagram

Page 20 of 40
 Online Examination

3.2.6. Answer Test Activity Diagram

Page 21 of 40
 Online Examination

3.3.Sequence Diagrams

3.3.1. Sequence Diagram Overview

Page 22 of 40
 Online Examination

3.3.2. Login-Sequence-Diagram

Page 23 of 40
 Online Examination

3.3.3. Manage Student Groups Sequence Diagram

Page 24 of 40
 Online Examination

3.3.4. Student Registration Sequence Diagram

Page 25 of 40
 Online Examination

3.3.5. Manage Test Sequence Diagram

Page 26 of 40
 Online Examination

3.3.6. Appear for Test Sequence Diagram

Page 27 of 40
 Online Examination

3.4.Class Diagram

Page 28 of 40
 Online Examination

3.5.Database Design

Page 29 of 40
 Online Examination

3.5.1. Table: Student

Field Name Data Type Constraints/Description
stdid Bigint(20) NOT NULL
stdname Varchar(40) DEFAULT NULL
stdpassword Varchar(40) DEFAULT NULL
emailid Varchar(40) DEFAULT NULL
Contact No Varchar(20) DEFAULT NULL
address Varchar(40) DEFAULT NULL
city Varchar(40) DEFAULT NULL
pincode Varchar(20) DEFAULT NULL

3.5.2. Table: Question

Field Name Data Type Description
Testid Bigint(20) NOT NULL DEFAULT
qnid Int(11) NOT NULL DEFAULT
Question Varchar(500) DEFAULT NULL
Option a Varchar(100) DEFAULT NULL
Option b Varchar(100) DEFAULT NULL
Option c Varchar(100) DEFAULT NULL
Option d Varchar(100) DEFAULT NULL
Correctanswer Enum(optiona,optionb,optionc,optiond) DEFAULT NULL
marks Int(11) DEFAULT NULL

3.5.3. Table: Student Questions

Field Name Data Type Description
Stdid Bigint(20) NOT NULL DEFAULT
TestID Bigint(20) NOT NULL DEFAULT
Qnid Int(11) NOT NULL DEFAULT
answered Enum(answered,unan DEFAULT NULL
swered,review)
stdanswer Enum(optiona,optio DEFAULT NULL
nb,optionc,optiond)

Page 30 of 40
 Online Examination

3.5.4. Table: StudentTest

Field Name Data Type Description
stdid Bigint(20) NOT NULL DEFAULT
testid Bigint(20) NOT NULL DEFAULT
starttime Timestamp NOT NULL DEFAULT

CURRENT_TIMESTAMP
endtime Timestamp NOT NULL DEFAULT

“0000-00-00 00:00:00”
correctlyanswered Int(11) DEFAULT NULL
status Enum(over,inprogre DEFAULT NULL
ss)

3.5.5. Table: Subject

Field Name Data Type Description
subid Int(11) NOT NULL
subname Varchar(40) DEFAULT NULL
subdesc Varchar(100) DEFAULT NULL
tcid Bigint(20) DEFAULT NULL

3.5.6. Table: AdminLogin

Field Name Data Type Description
admname Varchar(32) NOT NULL
admpassword Varchar(32) DEFAULT NULL

3.5.7. Table: Test

Field Name Data Type Description
testid Bigint(20) NOT NULL
testname Varchar(30) NOT NULL
testdesc Varchar(100) DEFAULT NULL
Testdate Date DEFAULT NULL
testtime Time DEFAULT NULL
subid Int(11) DEFAULT NULL
testfrom Timestamp NOTNULLDEFAULTcurrent_timestamp
testto Timestamp NOT NULL DEFAULT
duration Int(11) DEFAULT NULL
totalquestions Int(11) DEFAULT NULL
Attemptedstudent Bigint(20) DEFAULT NULL
Test code Varchar(40) NOT NULL
tcid Bigint(20) DEFAULT NULL

Page 31 of 40
 Online Examination

3.5.8. Table: TestConductor

Field Name Data Type Description
tcid Bigint(20) NOT NULL
tcname Varchar(40) DEFAULT NULL
tcpassword Varchar(40) DEFAULT NULL
emailid Varchar(40) DEFAULT NULL
Contact no Varchar(20) DEFAULT NULL
address Varchar(40) DEFAULT NULL
city Varchar(40) DEFAULT NULL
pincode Varchar(20) DEFAULT NULL

Page 32 of 40
 Online Examination

4. User Interfaces
The interfaces of this system are as below
4.1. Home Page

Page 33 of 40
 Online Examination

4.2. Registration

Page 34 of 40
 Online Examination

4.3.Login Interface

Page 35 of 40
 Online Examination

4.4.Create Questions Interface

Page 36 of 40
 Online Examination

4.5.CreateResultInterface

Page 37 of 40
 Online Examination

CONCLUSION

WORK DONE:

 The project was successfully designed and is tested for accuracy and
quality.

 During this project I have accomplished all the objectives and

 this project meets the needs of the organization . The developed

 will be used in searching , retrieving and generating information

 for the concerned requests.

GOALS

o Reduced entry work.

o Easy retrieval of information

o Reduced errors due to human intervention

o Portable and flexible for further enhancement

o Web enabled.

 Fast finding of information requested

Page 38 of 40
 Online Examination

5. Scope for Enhancement

Present system carries certain drawbacks and limitations as listed below

1. Current system provides only multiple choices but single correct answer selection.
Faculty may wish to provide multiple choices multiple selection responses.

2. Incase questions and/or answers need to be in graphics, current system has no

provision.

3. Unregistered users cannot answer test, they must belong to some group. This is a
drawback incase the faculty wants anyone even anonymous users to answer the test.

4. Top score could be displayed on the home page; but this could be easily
implemented while programming the home page.

5. Security logs though not implemented in this system would be well available through
the respective database management system and web server software.

Page 39 of 40
 Online Examination

1. References
 Sedna native XML http://modis.ispras.ru

 Apache Tomcat http://tomcat.apache.org

 MySQL http://www.mysql.com

 UML official website http://www.uml.org/

 StarUML - The Open Source UML/MDA Platform http://staruml.sourceforge.net/

Page 40 of 40