This is a website built using JEE7 and JSP with MySQL as database. The application was built using Eclipse and was hosted on Apache Tomacat. This website serves the purpose of an examination registration portal where students can register themselves for an examination and also find resources required for the examination to be borrowed in an online library kind of operation. I built this web application along with a couple of my classmates as part of my final year college project during my undergraduate days.
The system used eight tables in the database:
i. Admin: This table stores all admin-related login details.
ii. Approved Centres: This table stores details about all the examination centres which are approved to conduct examinations.
iii. Books: This table stores details about the books available in the online library facility offered by the application.
iv. Exam Centre: This table stores details about examination centres which registered themselves in the application for approval.
v. Exam Registry: This table stores details about past academic records of students.
vi. Library Register: This table stores details about the daily transactions taking place in the online library.
vii. Question Papers: This table stores details about past question papers which are available in the application.
viii. Student: This table stores basic details and information about a student.
The list of columns used for the above tables are given as:
1. Admin
| Field | Type | Key | Default | Extra |
|---|---|---|---|---|
| adminid | varchar(30) | Primary | Null | |
| adminpass | varchar(30) | Null |
2. Approved Centres
| Field | Type | Key | Default | Extra |
|---|---|---|---|---|
| acid | int(11) | Primary | Null | Auto_increment |
| schoolid | int(11) | Foreign | Null | |
| locality | varchar(50) | Null | ||
| totalseats | int(11) | Null | ||
| seatsbooked | int(11) | Null |
3. Books
| Field | Type | Key | Default | Extra |
|---|---|---|---|---|
| book_id | int(7) | Primary | Null | Auto_increment |
| book_name | varchar(50) | Null | ||
| author | varchar(30) | Null | ||
| subject | varchar(30) | Null | ||
| path | varchar(200) | Null | ||
| availability | varchar(10) | Null |
4. Exam Centre
| Field | Type | Key | Default | Extra |
|---|---|---|---|---|
| schoolid | int(11) | Primary | Null | Auto_increment |
| name | varchar(50) | Null | ||
| principal | varchar(30) | Null | ||
| varchar(50) | Null | |||
| address | varchar(200) | Null | ||
| locality | varchar(20) | Null | ||
| pin | int(11) | Null | ||
| city | varchar(20) | Null | ||
| seats | int(11) | Null | ||
| details | varchar(200) | Null | ||
| password | varchar(50) | Null | ||
| status | varchar(10) | Null |
5. Exam Registry
| Field | Type | Key | Default | Extra |
|---|---|---|---|---|
| eid | int(11) | Primary | Null | Auto_increment |
| roll | int(11) | Foreign | Null | |
| tenboard | varchar(100) | Null | ||
| tenyear | int(11) | Null | ||
| tenmarks | varchar(10) | Null | ||
| twelveboard | varchar(100) | Null | ||
| twelveyear | int(11) | Null | ||
| twelvemarks | varchar(10) | Null | ||
| schoolid | int(11) | Foreign | Null |
6. Library Register
| Field | Type | Key | Default | Extra |
|---|---|---|---|---|
| rid | int(6) | Primary | Null | Auto_increment |
| roll | int(6) | Foreign | Null | |
| book_id | int(6) | Foreign | Null | |
| borrow_date | date | Null | ||
| due_date | date | Null |
7. Question Papers
| Field | Type | Key | Default | Extra |
|---|---|---|---|---|
| id | int(11) | Primary | Null | Auto_increment |
| title | varchar(30) | Null | ||
| description | varchar(200) | Null | ||
| file | mediumblob | Null | ||
| type | varchar(20) | Null |
8. Student
| Field | Type | Key | Default | Extra |
|---|---|---|---|---|
| roll | int(11) | Primary | Null | Auto_increment |
| cname | varchar(20) | Null | ||
| fname | varchar(20) | Null | ||
| mname | varchar(20) | Null | ||
| dob | date | Null | ||
| gender | varchar(10) | Null | ||
| category | varchar(10) | Null | ||
| nation | varchar(20) | Null | ||
| aif | bigint(20) | Null | ||
| caddress | varchar(200) | Null | ||
| district | varchar(20) | Null | ||
| state | varchar(20) | Null | ||
| cemail | varchar(100) | Null | ||
| cphone | bigint(20) | Null | ||
| caadhar | bigint(20) | Null | ||
| cpass | varchar(20) | Null | ||
| secqtn | varchar(100) | Null | ||
| secans | varchar(15) | Null | ||
| bookidborrowed | int(7) | Null | ||
| picture | varchar(200) | Null |