VBS Purvanchal University
On-Line
Examination
By
xxxxxxx
Under the Guidance of
xxxxxxxxxxxx
Submitted to the School
of Computer and
System Sciences in partial
fulfillment of the requirements
For the degree of
Bachelor
Of
Computer Applications
VBS Purvanchal University
Jaunpur-221122.
Title of
the Project
On-Line Examination
System
--------------------------------------
Serial
|
Topic
|
Page
|
|||
1
|
Title of the project
|
2
|
|||
2
|
Introduction
|
7-8
|
|||
3
|
Objective
|
9
|
|||
4
|
Purpose, Scope and
Applicability
|
10-11
|
|||
5
|
Survey of technologies
|
12-14
|
|||
6
|
Front
End User
|
15
|
|||
7
|
Back
End User
|
16
|
|||
8
|
Software
and Hardware Requirements
|
17-18
|
|||
9
|
Feasibility
|
19-22
|
|||
10
|
Requirements
Specification
|
23-25
|
|||
11
|
Planning
and Scheduling
|
26-27
|
|||
12
|
E
R Diagram
|
30
|
|||
13
|
Analysis
|
31-34
|
|||
14
|
Modules
and their Description
|
35-38
|
|||
15
|
Data
Structures
|
39-42
|
|||
16
|
Table Description
|
43-45
|
|||
17
|
Data Integrity Design
|
46-47
|
|||
18
|
Process
Logic
|
48-51
|
|||
19
|
Security Mechanism
|
52-53
|
|||
17
|
Future
Scope and further Enhancement
|
54
|
|||
18
|
Bibliography
|
55
|
--------------------------------------------
Introduction :
On Line Examination itself represent the
examination through the internet. This project will help the university/ Institution
to evaluate the question have multiple option with one correct answer. This
project contains two types of question viz. subjective and objective. Students
have to write the descriptive answer for the subjective question will be
randomly generated. It would be evaluated automatically i.e. by the system.
This project helps the management to
conducting online examination and save recourse. The university/Institution can
conduct the online examination and announce the status or result in a few data.
The examination department is responsible for the marinating of question paper
and it would be completely secure.
This is the era of computer and we
are adopting fast mechanism to solve any problem. On line examination is also a
way to give result as soon as we submit our paper.
--------------------------------------------------------------------
Synopsis
-----------------------------------------------------------
INTRODUCTION
Background:-
As
the name of the project “On-Line Examination” suggests, the system/application
has to manage the examination for various department of an academy. So to keep
the information correct and fast, it will manage the status/information of that
examination of that examination so one can get the details of exam as per their
program.
Earlier
it was a very time consuming and tedious process where both students as well as
university used to perform all tasks manually be it Student Registration,
Sqtting Question Papers, Setting Schedules to finally declaring the result. It
was cumbersome since these details were now generated, managed and kept in
computers.It was still not that much simpler Later the process became a lot
easier when computer system were introduced and all for students because they
were stll expected to come in person to register, appear for exam at exam
center and for all those formalities.
Now
we are expected to develop an web application which converts all of these tasks
atomized as well as web enabled. There are applications already working in this
area like MCSE, CCNA which conducts their examination online.
We,
as a 6th sem. student of BCA are making this project by taking help from theses
already working and tested applications as well as making our own set of
improvements.
This
application is coded in .Net. This
Software project is very much helpful to students, Examination department and
Exam controller. It stores the information about Students, Exams, Report, Results, Student’s details and Fee Status
etc. As we know that this software project is coded in .Net programming
language, it is user friendly. That means this software is easy to operate.
Even a person having less knowledge of computer can easily operate is, he will
be guided throughout by the software to operate it. This Software is a best
effort of changing in paper work to electronic work. This application is
divided into many module, and each module is related to different part of code.
This integration makes the project very user friendly. Another advantage of
this software is the database that is designed very strongly, the current and
previous information is stored in this database and maintain the database very
easily.
University used
to keep all the details in files manually.
Objectives
The objective of the project “On Line
Examination” is to make evaluation and conduction of examination massive but
simple, cost effective and faster.
They are as follows :
- To provide an interface through which student can appear for examination online for objective as well as subjective type questions.
- To provide registration for students done by themselves.
- To not provide facility of copy and paste while attempting the Subjective questions on the web page.
- When the student starts the exam the timer will start automatically and show the student how much time is left.
- The questions will be display randomly from question bank.
- Objective answers will be checked automatically by the system from the database
- For subjective answer manually checking by exam department will take place.
- To provided user name and password facility and credentials should be checked properly at the time of login for student, expert, controller and Exam Dept Admin.
- To provide an interface from where controller will create new Expert and Admin for Exam Dept.
- The authority to modify the criteria is provided to the controller of examination.
- To facilitate Experts to send a collection of questions in Question Bank.
- The Exam Dept will manage the question bank sent by experts.
- To facilitate Exam Dept Admin to make schedule and declare Result.
Purpose, Scope and Applicability:-
Purpose:-
Through
this package we provide a fully customized web application. This system is an
automated system so that the functional working of it is effective and time
saving. In this modern era time is the most precious thing, so in context of
time the new system will be effective to do a group of task in easy and secure
manner.
To appear for an
exam in manual system in an university is very time consuming process. Now the
purpose of this system is to overcome the shortfall faced in the previous
systems already working in the area.
The
website will have to be secure, and properly working on WAN. It should be
speedy with good interface. The university may conduct examination in various
countries and in different languages. It should support multiple platforms at
least those used by people commonly.
Scope:-
Methodology
of the system is clear that result in the complete and proper working of the
system from the requirements achieved. it contains the working model for the
development of system. A sequential step of model is followed to develop the
system so that it will maintain various software engineering
features/parameters.
No
need to take leave, visit a different town, city or even states in some cases.
People can appear right from their laptop or home desktop.
Assumptions:
To develop this
application, we’ve taken into account some assumptions. They are:
- University will provide each student a unique student Id during enrollment time. The purpose of this is so that no one can register on behalf of any other student. and only the student himself/herself can register for the examination using this id.
- Student login name will be generated automatically by concatenating student first Name and Enrollment No.
Like : Shwati has student id ® 13P
So, Swati student login here will be ® Swati_P13
- Expert login name will be generate same as student login name but with small change.
like : Expert Login = (Expert First name +Course Name)
The courses will be fed by
hard-coding.
Limitation:-
1. In the case
of any type of problem in student
verification no functionality is defined in the system to correct it or
inter-communication among users are also not available.
2. The Fees is taken manually as there is
not any module for online payment.
3. The Total marks is get by the student
only after some time of exam, because in case of subjective paper, the exam
dept will evaluate the answer and declare the result. Student can see his
result on internet through his LoginId and PWD only after that.
A detail section for limitation is devoted at the end of documentation.
SURVEY OF TECHNOLOGIES
To develop this package different types of tools and database are used which are as follows:
1. ASP.NET 2005
2. Framwork 2.0
3. Microsoft-sql server 2007
4. Microsoft word processor
1. ASP.NET 2005:
ASP.NET 2005 is a Microsoft technology for building the web
based application and services. A ASP.NET application consists of forms
,controls,classes and procedures.
Forms are windows upon which you build your user interface
are the building blocks of the user interface. Controls also called activeX
conrols, are interface tools , such as labels ,textbox and command buttons,
that you use to display information to the user, gather information from the
user, and respond to user actions. Classes are templates from which you can
create your own objects at run time.
Procedures are small routines you write that are callable
from anywhere in your application. These routines will perform a function for
you that you write once but can call many times.
An application is made up of forms, modules and classes. A
form is made up of properties, events and controls. Controls are also made up
of properties and events
Some Features Of ASP.NET
- Language interoperability : a one language code is to interact with other language.
- EDP(Event driven programming language): it is a Event Driven Programming language(i.e. we write code on its event and drive the program).
- Rapid Application Development(RAID).
- Allows the creation of COM components such as activeX controls.
- Includes good debugging facilities.
2. Framwork 2.0
Dot net framework
is a platform that is provided by Microsoft technology in which we can develop
web based application, window based
application and console base application with C#(c sharp),VB and J#(J
sharp) and other 22 Language.
3. Microsoft-SQL
Server 2007
Microsoft SQL
Server fulfills these responsibilities :
· Reduction and redundancy :
Centralized control of the DBA avoids the unnecessary duplication of data
and effectively Reduces the total amount of data storage required. It also
eliminates the extra processing and of the inconsistencies e.g. Same format of
grade card for all student.
· Sharing data :
Any number of application program of user’s can share the same database .
For example we can access the list of study centers.
· Data integrity :
Data integrity means that the data contains in the database both accurate
and consistent.
· Data security :
In this facility the confidential data must not be accessed
by unauthorized person.
· Rapidly Accessing Data :
SQL Server provides rapid access to data by utilizing indexes and storing
frequently accessed data in memory.
· SQL Server Enterprise Manager :
The Enterprise Manager is the central console from which most SQL Server
database-management tasks can be coordinated. SQL Enterprise Manager provides a
single interface from which all servers in a company can be managed.
4. SQL Server Enterprise Manager :
The Enterprise Manager is the central console from which most
SQL Server database-management tasks can be coordinated. SQL Enterprise Manager
provides a single interface from which all servers in a company can be managed.
Front End User
The .Net Initiative
Microsoft
has introduced the .NET initiative with the intension of bridging the gap in
interoperability between application. It aims at integrating various programming.
The
.NET initiative offers a complete suite for developing and deploying
applications. This suits consists of
.NET services, and the .NET framework.
- .Net Products :- Microsoft has already introduced Visual Studio .Net, which
- Is tool for developing .Net applications by using programming languages such as Visual Basic, C# and Visual C++. To ensure interaction between different applications, all .Net products use Extensible Markup Language (XML) for describing and exchanging data between application.
- .Net Services :- .Net delivers software as web services. Therefore, User can subscribe to a web service and use it as long as they need it, regardless of the hardware and software platform. Microsoft is coming up with its own set of web services, known as my services. These services are based on the Microsoft Passport Authentication service, in addition to the web services provided easily with the .Net environment.
- The .Net Framework :- it is the foundation on which us design, develop and deploy application. Its consistent and simplified programming model makes easier to built applications.
Back
End User
This is the part of well known software package called
as the Microsoft Office. It is designed to built the various database, and to
perform other data work. SQL provides an extremely powerful, easy to use
database that will serve our needs when you required the power of fully
relational database. SQL is also helpful create a variety of database as well
as how to enter, edit and final data in existing database.
SQL :
SQL server 2007 utilities, such as backup and restore,
run much faster and have less effect on server operations. SQL Server 7.0 also
includes a variety of new features designed to support the underlying database
architecture and to provide more flexible system management. SQL Server also
include a number of new features designed to reduce database backup and
recovery times. A different backup captures only those data pages that have
changed after the last database backup. Many times differential backup can
eliminates much of the time the server spends rolling transaction forward. With
SQL Server 7.0 a portion of the database can be restored or rolled forward to
minimize recovery time in the event of media failure. Restoring a backup is
easy because the restore process automatically creates the database and all the
necessary files. SQL server 7.0 supports backup to same tape media with other
backup, such as those written by the Microsoft Windows NT backup program.
Hardware & Software
requirement specification
Software Requirements
For development, software’s used are:
Operating System :
Windows-XP Professional
Version 2002, service pack-2,
Microsoft IIS 5.0/6.0
Platform : .Net
Technology :
Asp.net
Language : C#(C
sharp)
Backend : SQL
server 2007
Editor :
Microsoft word processor 2000
For Development : visual studio .Net setup tools
For Design : HTML, Visual studio designer
For deployment, software’s used are
:
Operating system :
Windows-xp professional
Version 2002, service pack-2
Framework : .Net
2005
IIS :
Configured
Backend :
sql server 2000
Hardware Requirements
For
Development, Hardware’s used are:
1.
Pentium IV(dual core processor operating at 3.6 GHz)
2.
40GB hard disk
3.
1GB RAM
· For Deployment,
Hardware’s used are :
Minimum
1.
Pentium III or better processor
2.
10 GB hard disk
3.
256MB RAM
4.
10-100 MBPS of Network card
Recommended
1.
Pentium IV
2.
20GB hard disk
3.
1GB RAM
4.
100-512 MBPS of network card
Feasibility Study
Introduction:
The feasibility study of any
system is mainly intended to study and analyze the proposed system and to
decide whether the system under consideration will be viable or not after
implementation. That is it determines the usability of the project after
deployment. To come to result a set of query is answered keeping the efficiency
of the software and its impact on the domain for which it was developed. It
main emphasis is on the following three questions elucidated below as:
What are the user’s requirements and how does a
candidate system meet them?
What resources are available for the proposed systems?
Is it worth solving the problem?
What is the likely impact of the proposed system on
the organization? I.e. how does the proposed system fit with in the
organization?
Thus
since the feasibility study may lead to commitment of large resources, it
becomes necessary that it should be conducted competently and no fundamental
errors of judgment are made. Different types of feasibility study and the way
we performed on our project “On Line Examination” .
Technical Feasibility:
In
technical feasibility, we study all technical issues regarding the proposed
system. It is mainly concerned with the specifications of the equipments and
the software, which successfully satisfies the end-user’s requirement. The technical
needs of the system may vary accordingly but include:
- The feasibility to produce outputs in a given time.
- Response time under certain conditions.
- Ability to process a certain volume of the transaction at a particular speed.
- Facility to communicate data.
Under
this analysis process questions like (i) does the compatible platform exist
within our domain or can we procure it? (ii) Does the proposed equipment have
the technical capacity to hold the data required using the new system?.
Both
at the development site and at server where we will be hiring the space for the
website, and also the database would it be possible to upgrade the system after
it is developed and implemented, if necessary? And would the recommended
technology guarantee the reliability, accuracy and data security? This analysis
process requires more emphasis on system configuration given more importance
rather than the actual hardware specifications.
. The configuration of the existing systems is:
- Processor : Pentium III, 500 MHz (or above)
- Memory : 128 MB (or above)
- Secondary storage : 20 GB (or above)
For Software there are following alternatives:
Operating System :Window 98,2000,XP,NT
Development tools :ASP.Net ,C#
,HTML,DHTML
Database :Microsoft SQL server
7.0
Documentation tool: MS-Word
Economical Feasibility:-
Meaning : re
there sufficient benefits in creating the system to make the acceptable? Or are
the costs of not creating the system so great that it is advisable to
undertaken the project.
This will include
three major costs as described below :
- Cost of Hardware and Software
- Cost of Software to be acquired to build and run the product is a one time cost.
- Buying a back and database is the major part of hardware and Software cost. Comparison between the oracle database high cost and better features with the SQL server low cost and better support for the same vendor operating system make this decision need oriented.
Benefits in
reduced cost, error and saving will be made by reduction of present system
expenses, time saving and increased accuracy.
Cost Avoidance :
Future cost
reduction in form of reduction in the number of administrative staff needed and
manual records maintains in organization.
Rise in cost
will be avoided.
Operational Feasibility :
Meaning : The
system will be used if it is developed well then be resistance from users that
undermine the possible application benefits.
Clients Supports :
Client and user
support for present system is there, as the current procedure used takes more
time and effort than proposed system.
No major
training and new skills are required as it is based on DBMS model.
It will help in
the time saving and fast processing and dispersal of user request and
application.
New product will
provide all the benefits of present system with better performance such as
improved information, better management and collection of the reports.
User Support :
User involvement
in the building of present system is sought to keep in mind the user specific
requirement and needs.
User will have
control over own information. Important information such as Test result can be
generated at the click of a button.
REQUIREMENTS AND ANALYSIS
Problem
Definition
The problem here
is to develop a web application which completely automize the examination
process for an university.
To perform this
the complete problem has been divided into five sub-problems so that they can
be solved easily and after that can be integrated to make it an integrated
working application.
- Online Registration / Enrollment of Student
- Online Login
- Online Schedule
- Online Manage the question bank
- Online Examination
- Online Result declaration
- Online display randomly question.
- The questions will be display randomly from question bank.
At the Login
module user name and password facility
and credentials should be checked
properly at the time of login for student, expert, controller and Exam Dept
Admin.
In the schedule
Module send the exam schedule to the
student.
In question bank
module for the examination could be changed dynamically.
Automatic checking of objective answers and manual checking of descriptive answers should be facilitated, if any.
In the Objective answers module will be checked automatically by the system from the database and the subjective answer manually checking by exam department will take place.
Automatic checking of objective answers and manual checking of descriptive answers should be facilitated, if any.
In the Objective answers module will be checked automatically by the system from the database and the subjective answer manually checking by exam department will take place.
In the exam
module When the student starts the exam
the timer will start automatically and show the student how much time is left.
At result module
display the result of each student and send by the exam. Dept.
Requirement Specification
On the basis
of system study performed in an
organization about all the functions that deals with Online examination
following requirements are specified.
Functional Requirements :
The Functional Requirements of the project
are as follows:
- To provide the functionality to students to appear for the exam online.
- To provide login interface through which only authorized user can pass by.
- The timer facility should be provide once the student appears in the Exam.
- The web application provide question to the student randomly.
- The system should support WAN so that exam can given from anywhere.
- This system should handle multiple exam at the same time.
- To functionally enable Exam Controller to define criteria and create Admin and Experts.
- To functionally enable Exam Dept Admin to manage Question Bank
- To functionally enable Exam Dept Admin to declare schedule and Results.
- To functionally enable Expert to send set of Questions.
Non-Functional
Requirements
The Non-Functional
Requirements of the project are as follows:
- The system should be reliable and robust.
- The system should be User friendly.
- The system should be completely Consistent and Secure.
Interface requirements
- Interface should be easy to follow,
- Interface shouldn’t have very much graphics,
- Interface shouldn’t have hidden buttons, and
- Interface should produce relevant error message.
In a complete way, we’re expected to build a web based application
which accommodates all
functionality of an organization that deal with online examination.
Planning and Scheduling
Gantt chart :
Gantt chart are
a project control technique that can be used for several purpose including
scheduling and planning. Gantt chart is also known bar chart with each box
representing an activity.
TASKS |
Week1
|
Week
2
|
Week
3
|
Week
4
|
Week
5
|
Week
6
|
Week
7
|
Week
8
|
|||||||||||||||||||
Requirements
Gathering
|
|||||||||||||||||||||||||||
SRS
Creation
|
|||||||||||||||||||||||||||
Low
Level Design
|
|||||||||||||||||||||||||||
High
Level Design
(Interface,
Data Design)
|
|||||||||||||||||||||||||||
Procedural
Design
|
|||||||||||||||||||||||||||
Coding
|
|||||||||||||||||||||||||||
Testing(Module
and Integrated)
|
|||||||||||||||||||||||||||
Implementation
|
|||||||||||||||||||||||||||
Pert chart :
Pert stands for
program evolution and review technique. A pert chart is a network of boxes and
arrows. The boxes in the pert chart can be decorated with starting and ending
dates for activities.
 |
|||
 |
|||
Preliminary Product Description
The system will
facilitate online examination and documentation of results. The system can
conduct various examinations for various subjects. All one needs to do is
change the database accordingly.
project deals
with registration or enrollment of students, submission of registration forms
and issuing unique id and password to enrolled students
This application
has Login module we need the user name and password facility and credentials should be checked properly at the
time of login for student, expert, controller and Exam Dept Admin.
The application
has schedule Module send the exam schedule to the student.
The application
has question bank module for the examination could be changed dynamically.
The application will facilitate Objective answers module will be checked automatically by the system from the database and the subjective answer manually checking by exam department will take place.
The application will facilitate Objective answers module will be checked automatically by the system from the database and the subjective answer manually checking by exam department will take place.
This application
has exam module When the student starts
the exam the timer will start automatically and show the student how much time
is left.
This application
has result module display the result of each student and send by the exam.
Dept.
Evaluation and
printing of students result will be supported
Like any other software application project we need to use good software
development practices when faced with working on a web application. Otherwise,
the project would not remain in control and we would face problems with
timeliness, budgets and quality
Entity Relationship diagram for On Line Examination
DFD(DATA
FLOW DIAGRAMS)
 |
|||
|
|||
 |
|||||
 |
|||||
|
|||||
 |
|||
|
|||
 |
|||
 |
|||
Modules and their
Description
Basic Modules:
In Our Project
with the help of ‘Divide and Conquer theory’ we can divide overall program in
Five Modules
These five
modules are:
- Login Module
- Student Module
- Exam. Controller Module
- Exam Dept Module
- Expert Module
Login
Module :
This
is the first module in this project a
anyone who want to enter into this project/application . he/she must have pass
through this module, in other word we can say that this is authentication
module because the user authentication with his/her. To provided user name and
password facility and credentials should be checked properly at the
time of login for student, expert, controller and Exam Dept Admin.
Student
Login Form :
This
is the form in this project a student
who want to enter into this project application. he/she must have pass through
this module, in other word we can say that this is authentication module
because the user authentication with his/her.
Registration
:
In
this module student can get his/her whole information like his name, address
fees detail, program and courses. the user can select only one course
at
the time. Our student table will register the student. University will provide
each student a unique student Id during enrollment time. The purpose of this is
so that no one can register on behalf of any other student. and only the
student himself/herself can register for the examination using this id as
password. Students only submit his/her documents and fees after the registration.
View
Schedule :
In
this schedule form student get his/her schedule according to his registration.
The schedule is managed by the exam dept.
Exam
process
When
the student starts the exam the timer
will start automatically and show the student how much time is left.
Show
Result :
In the result
form will manage the
result(Subjective and Objective questions) and Status of the student. This
table contains the student id from which we will help us in generating the
result.
ExamController
Module :
The controller
has authority to modify the criteria is provided to the controller of
examination and provide an interface from where controller will create new
Expert and Admin for Exam Dept.
Manage Admin
:
In this module
the controller will Create, Delete and
Edit admin for the exam dept with
all of there details.
A Login
name and password has been provided
through which the admin can later login to perform all of there tasks.
Manage Expert
In this module
the controller will Create, Delete and
Edit experts for they can later
send question sets for objective as well as subjective questions which will be
asked to solve to students under exam process.
Sane as Manage
Admin module, A Login name and password
has been provided here too through which the expert can later login to send
questions.
Exam Dept
Module :
In the exam
dept will manage the question bank sent
by experts. and make schedule and declare Result.
ManageSchForStu
In this form the
exam dept. managed the schedule and
sends to the student with their exam dates.
For this first
he see all the details of registered students and allot them date accordingly.
ManageQusBank
:
his form manage
the subjective and objective question in the question bank sent by the expert
module. The Manage Question Bank managed the question will be display randomly from
question bank.
CheckSubQus :
This module
checks the subjective question attempted by the student during the exam.
subjective answer manually checking by exam department will take place
Declare
result :
in this form the
exam dept. manage the result and sends to the student when they complete their exam.
Expert
Module :
In the
expert module the Experts to send a
collection of questions(objective and
subjective) in Question Bank
Subjective
Question :
SubQus table
will contain Subjective question and it’s right answer. To not provide facility
of copy and paste while attempting the Subjective questions on the web
page.Here the iSubQusId is the primary key.
Data
Structures
Table Name : Course
Column Name
|
Data Type
|
Length
|
Couid
PK
|
Int
|
4
|
Coucode
|
char
|
10
|
Couname
|
Char
|
50
|
Isemester
|
Char
|
10
|
Iproid
|
Int
|
4
|
Table Name : Objqattempted
Column Name
|
Data Type
|
Length
|
iObjQAid PK
|
Int
|
4
|
iStuId
|
Int
|
4
|
iObjQusId
|
Int
|
4
|
ChAns
|
Char
|
10
|
Table Name : ExamDept
Column Name
|
Data Type
|
Length
|
ExamDeptId PK
|
Int
|
4
|
Vloginname
|
Varchar
|
40
|
Vpassword
|
Varchar
|
40
|
Table Name : Expert
Column Name
|
Data Type
|
Length
|
iExId PK
|
Int
|
4
|
Cfname
|
Char
|
20
|
Clname
|
Char
|
20
|
Course
|
Char
|
20
|
Vloginname
|
Varchar
|
40
|
Vpassword
|
Varchar
|
40
|
Table Name : ObjQus
Column Name
|
Data Type
|
Length
|
iObjqusId PK
|
Int
|
4
|
iExId
|
Int
|
4
|
tObjQus
|
Text
|
16
|
coptionA
|
Char
|
10
|
coptionB
|
Char
|
10
|
CoptionC
|
Char
|
10
|
CoptionD
|
Char
|
10
|
cAns
|
Char
|
10
|
bStatus
|
Bit
|
1
|
Table Name : Program
Column Name
|
Data Type
|
Length
|
iProgId PK
|
Int
|
4
|
cProgname
|
Char
|
10
|
Cduration
|
Char
|
10
|
iFess
|
Int
|
4
|
Table Name : Result
Column Name
|
Data Type
|
Length
|
iresultId PK
|
Int
|
4
|
iStuId
|
Int
|
4
|
imarkofSub
|
Int
|
4
|
imarkofObj
|
Int
|
4
|
Chstatus
|
Char
|
10
|
Table Name : Criteria
Column Name
|
Data Type
|
Length
|
Icriteriaid PK
|
Int
|
4
|
Vcriterianame
|
Varchar
|
50
|
Tcriteriatext
|
Text
|
4
|
Table Name : Student
Column Name
|
Data Type
|
Length
|
iStuId PK
|
Int
|
4
|
CEno
|
char
|
10
|
CFname
|
Char
|
10
|
cLastname
|
Char
|
10
|
cProgram
|
Char
|
10
|
cCourse
|
Char
|
10
|
iStudyCenCode
|
Int
|
4
|
vLoginname
|
Varchar
|
40
|
vPassword
|
Varchar
|
40
|
Table Name : SubQus
Column Name
|
Data Type
|
Length
|
isubQusId PK
|
Int
|
4
|
iExid
|
Int
|
4
|
tQus
|
Text
|
16
|
tAns
|
Text
|
16
|
iMaxMarks
|
Int
|
4
|
bStatus
|
Bit
|
1
|
Table Description
Student :
Our student
table will register the student. University will provide each student a unique
student Id during enrollment time. The purpose of this is so that no one can
register on behalf of any other student. and only the student himself/herself
can register for the examination using this id and password. Students only submit his/her
documents and fees after the
registration. In this student table store his/her whole information like his
name, address fees detail, program and courses. the user can select only one
course at the time.
Subjective Question :
SubQus table
will contain Subjective question and it’s right answer. Here the iSubQusId is
the primary key.
Objective Question :
ObjQus table
will contain objective question and four options and right answer. Here the
question id is the primary key.
Result :
result table will contain the
result(Subjective and Objective questions) and Status of the student. This
table contains the student id from which we will help us in generating the
result.
Schedule
:
Exam Dept
managed the schedule and it to student while successfully resgistraion.This
module contains information about their exam with their date.
ExamDept :
Our ExamDept
table will register the institute or university Examination department
administrator. This Manage Admin form can access only the controller. the
controller has also controllerId and
Password & controller name.. Examdept table will maintain the id and
password of Examdept admin. controller will make admin for different center.
The Exam Dept will manage the question bank sent by experts and evaluated the
answer.
Expert :
Our Expert table
will register the institute or university Expert administrator. This Manage
Expert form can access only the controller. This module contain the information
about expert like his name & expert in which course.
Subjective Question Attempted :
In this
SubQAttempted table will have iSubQAId ,
iStuId, iSubQusId, And tAns. iStuId will be the foreign key for the table
Student.
Objective Question Attempted :
ObjQAttempted
table will have iObjQAId, iStuId, iObjQusId, And cAns. iStuId will be the
foreign key for the table Student.
Course :
In the course
table contains the information about the iCouId,cCouName, iSemester and the
iProId. Here the iCouId is the primary
key.
Program :
This program
table contains the information about the like
course iProgId, cProgName, and the iFessof the program. Here the iProgId
is the primary key.
Normalization:
Our Database “OnLEDB” is normalized up to 3
NF.
From starting
our Database has been designed while strictly keeping in mind the concept of
Normalization and their positive effect on the complete output product, so we
have kept the tables normalized from the scratch. It means our tables are
completely normalized with no unwanted redundancy. And so we need not to
normalize it further.
Data Integrity Design
Student
Primary key –
iStuId
Alternate key –
cENo, cFName, cLName, cProgram, iStudyCenCode, vLoginName,
vPasswd
Foreign key
–iCouId (for Student table)
Course
Primary key –
iCouId
Alternate key –
CouCode, CouName, iSemester
Foreign key
–iCouId(for Course table)
ExamDept
Primary key –
iUserId
Alternate key –
vLoginName, vPasswde
Expert
Primary key –
iExId
Alternate key –
cFName, cLname, cCourse, vLoginName, vPasswd
ObjQAttempted
Primary key –
iObjQAId
Alternate key –
cAns
Foreign key
–iObjQusId (for ObjQAttempted table)
ObjQus
Primary key –
iObjQusId
Alternate key –
tObjQus, cOptionA, cOptionB, cOptionC, cOptionD, cAns, CStatus
Foreign key
–iExpertId (for Expert table)
Program
Primary key –
iProgId
Alternate key –
cProgName, cDuration, iFess
Result
Primary key –
iResultId
Alternate key –
iMarkOfSub, iMarkOfObj, bStatus
Foreign
key– iStuId(for result table )
Schedule
Primary key –
iSchId
Alternate key –
dtSDate
Foreign
key– iStuId(for Schedule table)
SubQAttempted
Primary key –
iSubQAId
Alternate key
–tAns
SubQus
Primary key –
iSubQusId
Foreign key
–iSubQusId(for SubQAttempted table)
Alternate key –
tQus,tAns, iMaxMarks, cStatus
Foreign key
–iExpertId(for SubQus table)
Process Logic
Login :
 |
User
name
|
Password |
|||
 |
|||
Type
 |
|||
 |
|||
If
valid
 |
Exam Dept :-
 |
ExamDePId
Vloginname
Vpassword
Board
 |
ExamDept
Course
 |
couid
coucode
counameiSemester
iPeriod |
Course
ObjQattempted :
 |
iObjQAId
IstuId
IObjQusId
ChAns
 |
ObjQuatempted
ObjQus :-
iObjQusId
iExId
tObjQus
CoptionA
CoptionB
CoptionC
CoptionD
CAns
bStatus
ObjQus
Program
iProgId
iStuId
iMarksofSub
iMarksofObjchstaus
Program
Result :
 |
iresultIdIstuIdImarkOfSub
imarkOfObj
chStatus
Result
Student :-
iStuIdcEnoCFnameCLnameCProgramCCourse
iStudyCenCode
VLoginName
VPassword Student
SubQus :
isuQusId
iExId
tQus
tAns
iMaxMarks
bStatus
SubQus
Criteria:
 |
iCriteriaId
VcriteriaNametcriteriaText |
Criteria
Security Issues
Security
is an important issue for modern IT system. System administrator and security
administrator are responsible for safeguard’s organization data and computing
infrastructure.
Password Encryption: Whatever security
measures taken, in any case if anyone with destructive or malicious mind gets
access to the database he can temper
the critical data. To restrict it we’ve used encrypting algorithm facilitated
to us by Microsoft ASP.Net .
Two algorithms’
are there
- SHA1- It takes the password and encrypt it in a string of 40 characters
- MD5- It takes the password and encrypt it in a string of 32characters
The beauty of
these Algos are that whatever be the length of password the length of converted
string remains same.
However a question
arise here that if this thing is that good then why didn’t we used it for
storing each and every data????
The answer lies
in the fact that not all data are needed to be encrypted as long as we keep the
critical data(like password encrypted and safe). It will only increase the load
on server and network with no additional advantage. So we’ve not used this encryption Algo on all data
blindly.
We have implemented different
approach related to security issue for our project “Online Examination” :
Authorization:
Super
Admin has authorized to give permission to admin for the registration of the
students.
Authentication:
Only registered students can appear
for the examination. Every registered student has different and unique UserId.
Information Integrity:
Only
Super admin has right in the modification of the information. There is no
possibility by the end user or unauthorized user of hacking the information.
Detection:
Super
Admin will have a bank up of the project. Also there is a complex and alphanumeric
password for admin and student. Super admin itself has a complex and
alphanumeric password. There is a option for changing the password by all the
admin and itself after every month.
Future Scope of the Project
The
development of this project surely prompts many new areas of investigation.
This project has wide scope to implement it in any University/Institution
having multiple paper there. This project covers all functionalities related to
On-Line Examination Hall Hence it can be implemented any-where else after
minute organization level customization
Moreover
some parts of the project have remained uncompleted due to some reasons. First
of all limitations of our project, which has been discussed in previous topic
make place for future enhancements. Though that was not the part of objective
of our project but it would have great to implement that provided we’d enough
time.
Some of them are all those which are
enumerated in the limitation section like:
·
Online Payment
·
A module from where entities can communicate
·
And a faster process for subjective paper
evaluation
- “ASP.NET Black Book”
- ”A Programmer’s Guide to ADO.NET in C#” by Mahesh Chand.
- ”Microsoft ASP.Net 2.0 Step by Step” by George shepherd.
·
Microsoft SQL Server 2000-Rebecca Riordan,Andrew J Brust.
·
Software Engineering, A Practitioner’s Approach
– Roger S. Pressman