Here we shared Online Examination Table Design. As we know each and every web project contains its database. Here in this post we will focus on online examination. In this online examination table it has 8 tables. The tables are certificate, course, exam, questions, results, students, subjects, users. All the table has primary key with integer data type and auto increment.

Online Examination has certain process to implement. A Candidate gives exam after his/her identification. Same thing will happen here in this project.Admin will provide username and password for candidate so that they can login and start exam. Here “username and password” will work as admit card before examination.


Online Examination Table Design

Table structure for certificate

Column Type Null Description
certificateid int(10) Primary Key Certificate ID
examid int(11) Foreign key Exam ID
scoredmarks float(10,2) No Scored Marks
result varchar(25) No Result
date date No Date
status varchar(25) No Status

Table structure for course

Column Type Null Description
courseid int(10) Primary Key Course ID
coursename varchar(25) No Course Name
description text No Description
status varchar(25) No Status

Table structure for exam

Column Type Null Description
examid int(10) Primary Key Exam ID
regno int(10) No Register Number
subjectcode varchar(25) No Subject Code
datetime datetime No Date and Time
status varchar(10) No Status

Table structure for questions

Column Type Null Description
queid int(10) Primary Key Question ID
subjectcode varchar(15) No Subject Code
question text No Question
uploads text No Documents of the Question
option1 text No First Option
option2 text No Second Option
option3 text No Third Option
option4 text No Fourth Option
answer int(5) No Currect Answer
description text No Description
status varchar(25) No Status

Table structure for results

Column Type Null Description
resultid int(10) Primary Key Result ID
examid int(11) Foreign Key Exam ID
queid int(11) Foreign Key Question ID
answerid int(10) Foreign Key Answer ID

Table structure for students

Column Type Null Description
studid int(10) Primary Key Student ID
password varchar(25) No Student Password
courseid varchar(25) Foreign Key Course ID
name varchar(50) No Name
dob date No Date Of Birth
address text No Address
contactnumber varchar(20) No Contact Number
createdat date No Create Date
lastlogin datetime No Last Login
status varchar(25) No Status

Table structure for subjects

Column Type Null Description
subjectcode varchar(25) No Subject Code
courseid int(11) Primary Key CourseID
subjectname varchar(25) No Subject Name
rules text No Exam Rules
totalmarks int(10) No Total Marks
passmarks float(10,2) No Pass Marks
examduration int(10) No Exam Duration
status varchar(25) No Status

Table structure for users

Column Type Null Description
userid int(10) Primary Key User ID
courseid int(11) Foreign Key Course ID
name varchar(50) No Name
designation varchar(25) No Designation
usertype varchar(25) No User Type
username varchar(25) No User Name
password varchar(25) No User Password
createdat date No Create Date
lastlogin datetime No Last Login
status varchar(25) No Status

DOWNLOAD Online Examination Table Design


For Video demonstration of Online exam visit following link.

🔥13 Views

Do you have anything to Ask?

This site uses Akismet to reduce spam. Learn how your comment data is processed.