Student Project GuideHere 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.
