A PROJECT REPORT On Online Quiz System
A PROJECT REPORT On Online Quiz System
A PROJECT REPORT On Online Quiz System
PROJECT REPORT
ON
Online Quize Management System
Submitted in partial fulfillment for award of the
POST GRADUATE DIPLOMA IN COMPUTER APPLICATION(PGDCA)
OF
GAUHATI UNIVERSITY
SESSION 2023-2024
SUBMITTED BY
NAME OF THE
STUDENTS
PGDCA 4TH SEMESTER
ROLL NO OF THE STUDENTS
REGISTRATION NO-OF THE STUDENTS
Guided by-
GUIDED TEACER
ASSTT. PROFESSOR
Dept. of …….., B.N College
During the project work, he has successfully completed the study of submitted the report.
This report or a similar report on the topic have not been submitted for any other examination and does
not form part of any course undergone by the candidate.
Date: .
Place: .
Signature of the
(External Guide)
CERTIFICATE
This is to certify that the project entitled “ONLINE QUIZE MANAGEMENT SYSTEM SYSTEM” is
carried out by NAME OF THE STUDENTS students of 4th semester for Bachelor of Science of Bholanath
College, Dhubri.
This project work of NAME OF THE STUDENTS is submitted for the requirement of the degree
PGDCA in Computer Science to be awarded by Gauhati University. This work has not been presented
earlier for any other academic activity.
During the period of his project work, she has been found to be sincere and hardworking. I wish him all
success in future career and life.
Date: _________________.
Place: _________________.
This is to certify that project work entitled “ONLINE QUIZE MANAGEMENT SYSTEM”
is done by NAME OF THE STUDENTS bearing Roll No. ____________, Registration No:
_________________ for PGDCA program of B.N. College, Dhubri affiliated to Gauhati University.
He and hisproject mate have done their project under my supervision and guidance to the base of my
knowledge.
This project work has been prepared as a fulfillment of the requirement for the degree of
ONLINE QUIZE MANAGEMENT SYSTEM to be awarded by Gauhati University. His work has not
been submitted for any other academic activity.
During the period of his project work, he has been found to be sincere and hardworking. I wish his all
success in life.
Date: .
Place: .
(ASSTT.
PROFESSOR)
Asstt.Professor
Department of _____,
B.N. College,Dhubri
3
ACKNOWLEDGEMENT
We feel immense pleasure in expressing my sincere thanks and gratitude to our project guide GUIDE
NAME, Faculty of ___________ Department, B.N. College for his valuable guidance and constant
encouragement throughout the entire project work entitled “ONLINE QUIZE MANAGEMENT
SYSTEM” without which this project would neverbeen possible.
I also express my honest thanks and gratitude to Dr. Dhruba Chakrabortty, Principal of B.N. College,
Dhubri for giving me the chance to complete PGDCA degree under Gauhati University. I also thank all
the faculty members for their kind cooperation and help to success my project. Al last I also express my
thanks to all my friends those who give me the constant inspiration for fulfillment of the project.
Date: .
Place: .
4
SELF DECLARATION
We hereby declare that we name of the students , roll number and registration number
that the project entitled “ONLINE QUIZE MANAGEMENT SYSTEM” has been carried out by us and
is submitted in the partial fulfillment for the award of the degree of Bachelorof Computer Application
(BCA), 5th semester in B.N. College under the Gauhati University, Assam.
I also declare that any or all contents incorporated in the dissertation has not been submitted
anywhere for the award of any degree from institute or university.
Date: .
Place: .
5
TABLE OF CONTENTS
Sr. No Contents
1. Introduction / objectives--------------------------------------- 1
Abstract of the Project Online Result display System--------------------- 2
Main objectives ------------------------------------------------------------------ 2
Scope of the project Grocery Shop Management System-------------- 3
Reports of Grocery Shop Management System -------------------------- 4
Modules of Grocery Shop Management System-------------------------- 4
6. System design:
a. Modularization Details-------------------------------------17
b. Data integrity and constraints----------------------------17 - 18
c. Database design / procedural design / objectoriented
design.--------------------------------------------------------------18
d. User interface design---------------------------------------19
7. Coding:
User Registration----------------------------------------20 - 25
User Login-------------------------------------------------26 - 29
Product check out---------------------------------------30 - 35
8. Testing :
I. Techniques and strategies along withtest case
design and test report.-------------------------- 35 - 36
II. Debugging and improvement.------------------ 36 - 37
6
9. System Security Measure---------------------------------37
home screen---------------------------------------------39
products screen------------------------------------------39
User Registration screen------------------------------40
user login screen-----------------------------------------40
cart screen--------------------------------41
check out ----------------------------------41
My orders screen-----------------------------------------41
Admin login------------------------------------------------42
Admin dashboard-----------------------------------------42
12. Future Scope------------------------------------------------------------42 – 43
13. Bibliography ---------------- --------------------------------------------44
7
0
INTRODUCTION:
The main aim of Quiz Management System is to facilitate a user friendly environment
of e-book implementation and reduces the manual effort.
In past days quiz is conducted manually but in further resolution of the technology we are able to
generate the score and pose the queries automatically.
Secure access of confidential data, better design to give effective e-book and flexible. Service
based
architecture will be highly desirable for future extension. Issues are to reduce the
manual pressure and make
the project in effective manner.
Teacher is able to make quiz questions and take a contest both.
But students are only able to give a quiz. Their result is visible on the screen after the
successful completion
of the quiz. Both are able to ask any query from the administrator and give any
suggestion to improve the
site.
The present project elucidates the following features.
Registration of Teachers and Students
Making of Quiz
Taking of Quiz
Abstract of the Project Online Examination System:
The Purpose of Quiz Management System is to automate the existing manual system
by
the help of computerized equipment and full-fledged computer Software, Fulfilling their
Requirements, So that their valuable data/information can be stored for a longer
period with easy
accessing and manipulation of the same. The required software and hardware are
easily available and
easy to work with. Quiz Management System, as described above, can lead to error
free, secure,
reliable and fast management system. It can assist the user to concentrate on their
other activities
rather to concentrate on the record keeping. Basically the project describes how to
manage for good
performance and better services to the peoples who are taking part in the quiz. The
system will show
result after the examination is finished. A teacher has control in the question bank and
1
is supposed to
make schedule for the quiz. The system carries out the examination and auto-grading
for multiple
choice questions which is fed into the system. Administrative control of the whole
system is provided.
MAIN OBJECTIVES :
Online Quiz System also manage the Result details online for Student details, Quiz details,
Course.
Editing, adding and updating of Records is improved which results in proper resource
management of Course data.
2
Scope of the project Online Examination System:
It may help collecting perfect management in details. In a very short time, the collection will be
obvious, simple and sensible. It will help a person to know the management of passed year perfectly
and vividly. It also helps in current all works relative to Online Quiz System. It will be also reduced
the cost of collecting the management & collection procedure will go on smoothly.
Our project aims at Business process automation, i.e. we have tried to computerize various
processes of Online Quiz System.
In computer system the person has to fill the various forms & number of copies of the forms
can be easily generated at a time.
In computer system, it is not necessary to create the manifest but we can directly print it,
which saves our time.
To assist the staff in capturing the effort spent on their respective working areas.
The system generates types of information that can be used for various purposes.
Be easy to operate
Be expandable
3
Reports of Online Examination System:
You can easily export PDF for the Course, Result, Student
You can also export the report into csv format for Course, Question, QuizIt generates the
report on Course, Question, Result
You can easily export PDF for the Course, Result, Student
You can also export the report into csv format for Course, Question, Quiz
Question Management Module: Used for managing the information and details of the
Question.
4
Project Planning:
The main focus of the project “ONLINE QUIZE MANAGEMENT SYSTEM” is to provide all the
features that an Examination System must have, with the "interfaces that don't Scare it's Users!".
Project planning was done to define the scope of the project, assess risks, and estimate and
schedule project activities and thereby lay the foundation for the execution, monitoring and control
of the project.
Scheduling:
The project scheduling is a mechanism to communicate what tasks need to get done and which
organizational resources will be allocated complete those tasks in what timeframe.
A project scheduling is a document collecting all the work needed to deliver the project on time.
State Diagram:
State diagram are a familiar technique to describe the behavior of a system. They describe all the
possible states a particular object can get into and how the objects state changes as a result of
events that reach the objects. In most 00 techniques, state diagrams are drawn for a single class to
show the lifetime behavior of a single object. There are many form of state diagram, each with slightly
different semantics. The most popular one used in OO technique is based on David Hare’s state
chart.
The Software Requirements Specification is produced at the culmination of the analysis task. The
function and performance allocated to software as part of system engineering are refined by
establishing a complete information description, a detailed functional and behavioral description, an
indication of performance requirements and design constraints, appropriate validation criteria, and
other data pertinent to requirements
5
Software Requirements:
Hardware Requirements:
6
Software Engineering Paradigm Applied
Design Approach:
The Design Approach starts with the conceptual design in the baseline spiral and involves
architectural design, logical design of modules, physical product design and the final design in the
subsequent spirals.
7
Flowchart :
8
9
ER diagram:
E-R Model is a popular high level conceptual data model. This model and its variations are
frequently used for the conceptual design of database application and many database design
tools employ its concept.
A database that confirms to an E-R diagram can be represented by a collecton of tables in the
relational system. The mapping of E-R diagram to the entities are:
Attributes
Relations
Many-to-many
Many-to-one
One-to-many
One-to-one
Weak entities
Sub-type and super-type.
Model is an abstraction process that hides super details while highlighting details relation to
application at end.
A data model is a mechanism that provides this abstraction for database application.
Data modeling is used for representing entities and their relationship in the database.
Entities are the basic units used in modeling database entities can have concrete existence
or constitute ideas or concepts.
Entity type or entity set is a group of similar objects concern to an organization for which it
maintain data,Properties are characteristics of an entity also called as attributes
A key is a single attribute or combination of 2 or more attributes of an entity set is used to
identify one or more instances of the set. In relational model we represent the entity by a
relation and use tuples to represent an instance of the entity.
Relationship is used in data modeling to represent in association between an entity set.
An association between two attributes indicates that the values of the associated attributes
are independent.
10
Fig: ER diagram
11
DFD (Data flow diagram):
Data flow diagram is the starting point of the design phase that functionally decomposes the
requirements specification. A DFD consists of a series of bubbles joined by lines. The bubbles
represent data transformation and the lines represent data flows in the system. A DFD describes
what data flow rather than how they are processed, so it does not hardware, software and data
structure.
A data-flow diagram (DFD) is a graphical representation of the "flow" of data through an information
system. DFDs can also be used for the visualization of data processing (structured design). A data
flow diagram (DFD) is a significant modeling technique for analyzing and constructing information
processes. DFD literally means an illustration that explains the course or movement of information in
a process. DFD illustrates this flow of information in a process based on the inputs and outputs. A
DFD can be referred to as a Process Model.
The data flow diagram is a graphical description of a system's data and how to Process transform
the data is known as Data Flow Diagram (DFD).
Unlike details flow chart, DFDs don't supply detail descriptions of modules that graphically describea
system's data and how the data interact with the system. Data flow diagram number of symbols and
the following symbols are of by DeMarco.
Level-0 DFD :
Also known as context diagrams, are the most basic data flow diagrams. They provide a
broad view that is easily digestible but offers little detail.
12
Level-1:-
Level 1 DFDs are still a general overview, but they go into more detail than a context diagram.
In a level 1 data flow diagram, the single process node from the context diagram is broken
down into sub processes. As these processes are added, the diagram will need additional
data flows and data stores to link them together.
13
LEVE-2: DFD :-
14
System design:
In this phase, a logical system is built which fulfils the given requirements. Design phase of software
development deals with transforming the client’s requirements into a logically working system.
Normally, design is performed in the following in the following two steps:
1. Primary Design Phase: In this phase, the system is designed at block level. The blocks
are created on the basis of analysis done in the problem identification phase. Different blocks
are created for different functions emphasis is put on minimizing the information flow between
blocks. Thus, all activities which require more interaction are kept in one block.
2. Secondary Design Phase: In the secondary phase the detailed design of every block
is performed.
The general tasks involved in the design process are the following:
7. System reviews.
15
Data integrity and constraints:
In Database Management Systems, integrity constraints are pre-defined set of rules that are
applied on the table fields(columns) or relations to ensure that the overall validity, integrity,
and consistency of the data present in the database table is maintained. Evaluation of all the
conditions or rules mentioned in the integrity constraint is done every time a table insert,
update, delete, or alter operation is performed. The data can be inserted, updated, deleted,
or altered only if the result of the constraint comes out to be True. Thus, integrity constraints
are useful in preventing any accidental damage to the database by an authorized user.
16
Database design / procedural design / object oriented design:
Database design can be generally defined as a collection of tasks or processes that enhance
management system. Designing a proper database reduces the maintenance cost thereby
improving data consistency and the cost-effective measures are greatly influenced in terms
of disk storage space. Therefore, there has to be a brilliant concept of designing a database.
The designer should follow the constraints and decide how the elements correlate and what
The main objectives behind database designing are to produce physical and logical design
models of the proposed database system. To elaborate this, the logical model is primarily
concentrated on the requirements of data and the considerations must be made in terms of
monolithic considerations and hence the stored physical data must be stored independent of
the physical conditions. On the other hand, the physical database design model includes a
translation of the logical design model of the database by keep control of physical media
using hardware resources and software systems such as Database Management System
(DBMS)
17
User Interface Design:
User Interface Design is conceded with the dialogue between a user and the computer. It is
concerned with everything from starting the system or logging into the system to the
eventually presentation of desired inputs and outputs. The overall flow of screens and
messages is called a dialogue.
The following steps are various guidelines for User Interface Design:
1. The system user should always be aware of what to do next.
2. The screen should be formatted so that various types of information, instructions and
messages always appear in the same general display area.
3. Message, instructions or information should be displayed long enough to allow the system
user to read them.
5. Default values for fields and answers to be entered by the user should be specified.
7. The system user should never get an operating system message or fatal error.
18
Coding:
Index page:
<?php
include("config.php");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Online Result</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body><br />
<div align="center">
<span class="head">Online Result Display</span>
<hr class="hr" />
<br />
<br />
<span class="subhead">View Result</span>
<br />
<br />
<br />
<form method="post" action="viewResult.php">
<table border="0" cellpadding="5" cellspacing="5" class="design">
<tr><td colspan="2" align="center" class="msg"><?php echo $msg;?></td></tr>
<tr><td class="labels">Roll No.:</td><td><input type="text" required="required" name="roll"
class="fields" size="15" placeholder="Enter Roll No." /></td></tr>
<tr><td colspan="2" align="center"><input type="submit" value="SHOW" class="fields"
/></td></tr>
</table>
</form>
<br />
<br />
<a href="register.php" class="link">Student
Register</a> <a href="faculty.php" class="link">Faculty
Login</a>
<a href="registerFaculty.php" class="link">Faculty Registration</a>
</div>
</body>
</html>
19
Home:
<?php
include("config.php");
session_start();
if(!isset($_SESSION['email']))
{
header("location:index.php");
}
$email=$_SESSION['email'];
$a=mysqli_query($al,"SELECT * FROM faculty WHERE email='$email'");
$b=mysqli_fetch_array($a);
$name=$b['name'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Online Result</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body><br />
<div align="center">
<span class="head">Online Result Display</span>
<hr class="hr" />
<br />
<br />
<span class="subhead">Welcome <?php echo $name;?></span>
<br />
<br />
<br />
<div class="design" style="width:300px;padding:20px 20px;">
<a href="submitMarks.php" class="cmd">Submit Marks</a>
<br />
<br />
<br />
20
<a href="changePassword.php" class="cmd">Change Password</a>
<br />
<br />
<br />
<a href="logout.php" class="cmd">Logout</a>
</div>
<br />
<br />
</div>
</body>
</html>
21
SubmitMarks:
<?php
include("config.php");
session_start();
if(!isset($_SESSION['email']))
{
header("location:index.php");
}
$email=$_SESSION['email'];
$a=mysqli_query($al,"SELECT * FROM faculty WHERE email='$email'");
$b=mysqli_fetch_array($a);
$name=$b['name'];
$sem=$b['sem'];
if(!empty($_POST))
{
$s1=$_POST['s1'];
$s2=$_POST['s2'];
$s3=$_POST['s3'];
$s4=$_POST['s4'];
$s5=$_POST['s5'];
$roll=$_POST['roll'];
if($s1==NULL || $s2==NULL || $s3==NULL || $s4==NULL || $s5==NULL || $roll==NULL)
{
//
}
else
{
$total=$s1+$s2+$s3+$s4+$s5;
$per=($total/100)*100;
if($per<=35)
{
$result="Fair";
}elseif($per>=36 && $per<=50)
{
$result="Good";
}
elseif($per>=51 && $per<=70)
{
$result="Better";
}
else
{
$result="Best";
}
$sql=mysqli_query($al,"INSERT INTO
marks(roll,sem,s1,s2,s3,s4,s5,total,percent,result)
VALUES('$roll','$sem','$s1','$s2','$s3','$s4','$s5','$total','$per','$result')");
if($sql)
{
$msg="Successfully Saved Marks";
22
}
else
{
$msg="Marks Already Submitted to this Roll No.";
}
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Online Result</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body><br />
<div align="center">
<span class="head">Online Result Display</span>
<hr class="hr" />
<br />
<br />
<span class="subhead">Submit Marks</span>
<br />
<br />
<?php
$x=mysqli_query($al,"SELECT * FROM subjects WHERE sem='$sem'");
$y=mysqli_fetch_array($x);
$m=mysqli_query($al,"SELECT * FROM students WHERE sem='$sem'");
?>
<form method="post" action="">
<table border="0" cellpadding="5" cellspacing="5" class="design">
<tr><td colspan="2" align="center" class="msg"><?php echo $msg;?></td></tr>
<tr><td class="labels">Roll No. : </td><td>
<select name="roll" class="fields" style="background-color:#093d3d;" required>
<option value="" selected="selected" disabled="disabled">- - Select Roll - -</option>
<?php
while($n=mysqli_fetch_array($m))
{
?>
<option value="<?php echo $n['roll'];?>"><?php echo $n['roll'];?></option>
<?php } ?>
</select></td></tr>
<tr><td class="labels"><?php echo $y['s1'];?></td><td><input type="text" name="s1"
class="fields" size="5" placeholder="20" required="required" /></td></tr>
<tr><td class="labels"><?php echo $y['s2'];?></td><td><input type="text" name="s2"
class="fields" size="5" placeholder="20" required="required" /></td></tr>
<tr><td class="labels"><?php echo $y['s3'];?></td><td><input type="text" name="s3"
class="fields" size="5" placeholder="20" required="required" /></td></tr>
23
<tr><td class="labels"><?php echo $y['s4'];?></td><td><input type="text" name="s4"
class="fields" size="5" placeholder="20" required="required" /></td></tr>
<tr><td class="labels"><?php echo $y['s5'];?></td><td><input type="text" name="s5"
class="fields" size="5" placeholder="20" required="required" /></td></tr>
<tr><td colspan="2" align="center"><input type="submit" class="fields" value="Submit"
/></td></tr>
</table>
</form>
<br />
<br />
<br />
<a href="home.php" class="cmd">HOME</a>
</div>
</body>
</html>
Testing:
Testing is vital for the success of any software. no system design is ever perfect. Testing is also
carried in two phases, first phase is during the software engineering that is during the module
creation. second phase is after the completion of software. this is system testing which verifies that
the whole set of programs hanged together.
Techniques and strategies along with test case design and test report:
White Box Testing: In this technique, the close examination of the logical parts through the software
are tested by cases that exercise species sets of conditions or loops, all logical parts of the software
checked once. errors that can be corrected using this technique are typographical errors, logical
expressions which should be executed once may be getting executed more than once and error
resulting by using wrong controls and loops. When the box testing tests all the independent part
within a module a logical decisions on their true and the false side are exercised, all loops and
bounds within their operational bounds were exercised and internal data structure to ensure their
validity were exercised once.
Black Box Testing: This method enables the software engineer to device sets of input
techniques that fully exercise all functional requirements for a program, black box testing tests the
input, the output and the external data. it checks whether the input data is correct and whether we
are getting the desired output.
Unit Testing: Each module is considered independently. it focuses on each unit of software as
implemented in the source code, it is white box testing.
24
Integration Testing: Integration testing aims at constructing the program structure while at the
same constructing tests to uncover errors associated with interfacing the modules. modules are
integrated by using the top down approach.
Validation Testing: Validation testing was performed to ensure that all the functional and
performance requirements are met.
System Testing: It is executing programs to check logical changes made in it with intention of
finding errors. A system is tested for online response, volume of transaction, recovery from failure
etc. System testing is done to ensure that the system satisfies all the user requirements.
important aspect of software engineering because bugs can cause a software system to
malfunction, and can lead to poor performance or incorrect results. Debugging can be a time-
consuming and complex task, but it is essential for ensuring that a software system is functioning
correctly.
Code Inspection: This involves manually reviewing the source code of a software system to identify
25
Debugging Tools: There are various tools available for debugging such as debuggers, trace tools,
Unit Testing: This involves testing individual units or components of a software system to identify
bugs or errors.
Integration Testing: This involves testing the interactions between different components of a
System Testing: This involves testing the entire software system to identify bugs or errors.
Monitoring: This involves monitoring a software system for unusual behavior or performance issues
Logging: This involves recording events and messages related to the software system, which can
include firewalls, data encryption, passwords and biometrics. A firewall consists of software and
hardware set up between an internal computer network and the Internet to filter out unwanted
intrusions.
Cost Estimation:
Software cost comprises a small percentage of overall computer-based system cost. There are a
number of factors, which are considered, that can affect the ultimate cost of the software such as -
The main point that was considered during the cost estimation of project was its sizing. In spite of
complete software sizing, function point and approximate lines of code were also used to "size" each
26
The cost estimation done by me for Project also depend upon the baseline metrics collected from
past projects and these were used in conjunction with estimation variables to develop cost and effort
projections.
1. Effort Estimation - This refers to the total man-hours required for the development of the
project. It even includes the time required for doing documentation and user manual.
2. Hardware Required Estimation - This includes the cost of the PCs and the hardware cost
27
Screenshots /snapshots:
28
29
30
Future Scope:
In a nutshell, it can be summarized that the future scope of the project circles around
We can give more advance software for Student Result Management System including more
facilities
Create the master and slave database structure to reduce the overload of the database queries
Implement the backup mechanism for taking backup of codebase and database on regular
The above mentioned points are the enhancements which can be done to increase the applicability
and usage of this project. Here we can maintain the records of Student and Result. Also, as it can be
seen that now-a-days the players are versatile, i.e. so there is a scope for introducing a method to
maintain the Student Result Management System. Enhancements can be done to maintain all the
We have left all the options open so that if there is any other future requirement in the system by the
user for the enhancement of the system then it is possible to implement them. In the last we would
like to thanks all the persons involved in the development of the system directly or indirectly. We hope
that the project will serve its purpose for which it is develop there by underlining success of process.
31
References and Bibliography:
http://www.javaworld.com/javaworld/jw-01-1998/jw-01-Credentialreview.html
http://www.jdbc-tutorial.com/
https://www.tutorialspoint.com/java/
https://docs.oracle.com/javase/tutorial/
http://www.tutorialspoint.com/mysql/
https://www.freeprojectz.com/
httpd.apache.org/docs/2.0/misc/tutorials.html
32
33
34
35
36
37