Project On Online Admission System
Project On Online Admission System
Project On Online Admission System
Report
On
Online Admission
System
1
Introductio
n
TITLE OF THE PROJECT:
Online Admission System
The purpose of the project is to provide online facility to Institutes to conduct online
exams and to Students to give online exams. Institutes can enter and edit the questions
along with the students list. Also they can view the result. Students can login and give
their respective exams and view their score then and there. Others can view sample
papers to get look and feel of the online examination system.
EXISTING SYSTEM
Currently, the system is totally manual.
The manual system is slow then the computerized system.
It is very time consuming.
It is very complex system.
It is required more clerical work and use more man power.
The current system is not user friendly.
It takes too much cost to perform procedure.
In this, Paper losing or burning paper is possible.
It is difficult to store the data.
OBJECTIVES:
2
PROJECT CATEGORY:
Web Designing with Relational Database Management System.
TOOLS/ENVIRONMENT:
3
Tools: Visual Basic. Platform: Windows (OS).
DBMS:MS SQL server 2019.
Programming Language: HTML, Vb code, SQL, CSS,
Minimum Hardware Requirements: Pentium or AMD Processor with 1.8 GHz or
above, 1 GB RAM.
1)Introduction:
1.1 Purpose: The purpose of the project is to provide online facility and to Students to
apply registration through online. Institutes can enter and edit the details of students
list. Also they can view the application form. Students can login and give their
respective login id and view their data and enquiry about the college..
1.2 Scope: The website to conduct online Admission for a College is “Online
Admission System”. This website provides facility to institutes to conduct online
Admissions by providing a unique id to each Student. The institute provides online
registration of the student. Institute also enters the list of eligible students. All the
information entered can be later edited by the institute.
In turn student can login with their id, name and Programmed to give the forms and
can view their Admission status then and there. Institutes can also change the status of
admission of their students (if needed).
Benefits: This website reduces the manual work, maintaining accuracy, increasing
efficiency and saving time. Also institutes need not go to develop new software each
time; instead they just register and admit the students online. For students, it saves time
of going too far away admission centers and also they can view their Admission status
then and there.
iii) Abbreviations:
Pages
4
HTTP stands for Hypertext Transfer
Protocol
iv) References:
IEEE Recommended Practice for Software Requirements Specification- IEEE STD 830-
1993.
i.) Product
Perspective:
The application will have a user friendly and menu based interface.
(ii) There is a screen for displaying information regarding filling of Admission form
details by institutes.
(iii) There is a screen for displaying information regarding entering student list for
the particular program.
(iv) There is a screen for displaying information menu regarding what options the
5
institutes will select while filling entries in the form.
(v) There is a screen for displaying course details to the students when they are
selecting program for admission.
(vii) There is a screen for displaying of results of students after taking time for
registrar for selecting and rejecting students in the selected list and rejected list.
(i) Support for printer for printing results then and there will available soon.
(ii) Screen resolution of at least 800X600 is required for proper and complete
viewing of screens. Higher resolution will be accepted.
* Memory Constraints At least 512 MB RAM and 5 MB space on hard disk will
be required for running the application.
ii.) Product Functions: The website will allow access only to authorised users with
specific roles (Administrator- maintains the website, Institutes-Register to select the
forms submitted by the students, Students-Apply for admission online) a summary of
the major functions that the website will perform:
b. Institutes can enter the number of programs and there course details and the list
of eligible students selected.
6
iii.) Constraints:
* Since the DBMS being used is MSSQL server 2019, which is not a very popular
DBMS, it will not be able to store a very huge number of records.
* Due to limited features of DBMS being used performance tuning features will not
be applied to the queries and thus the system may become slow with the increase in
number of records being stored.
iv.) Assumptions: The application is online so taking into consideration that all the
details are true. Students can submit application form just once.
v.) Apportioning of Requirements: The future versions of the website will be having a
better database to handle larger number of records, in a more secure way.
Also separate profile will be maintained later for all students so that he can view all his
previous academic records later.
*Programs
*Student ID
*Student Name
*Student ID
7
*Student Name
*Institute ID
*Result (Select/Reject)
*Hardware interfaces:
*Screen resolution of at least 800X600 is required for proper and complete viewing of
screens. Higher resolution will be accepted.
*Software interfaces:
*Communications
interfaces None
Validity Checks: Vb code provides validity checks for various fields in the
student list,
question details, display of result should be handled sequentially that is data should be
stored only in a particular sequence to avoid any inconvenience.
8
*All the transactions will be processed within
9
*Security: Only authorized users will be able to access the website by entering the
correct login name and corresponding password.
The website will be also easily portable on any windows based system that has
MYSQL installed.
10
GIANT CHART:
11
Activity 01/9 -12/9- 1/10- 22/11- 16/12- 18/01- 13/02- 16/02-
11/930/9 21/10 15/12 17/01 12/01 15/02 26/02
Project
Search
Finalization
& Allocation
Investigation
of System
Requirement
System
design
Program
Design
Program
Coding
System
Integration
Acceptance
Test
12
DATA FLOW DIAGRAM (DFD):-
0 LEVEL DFD
Login Online
USER Admission
ADMIN
1 LEVEL DFD
Course Manager
Student
Online
Admission
System
Admission
Payment
Admin
11
nd
2 LEVEL DFD
Staff
Admin
Course
manager
Student
Student
profile
creater
Admission
Admissiondetail
Payment
Payment G.way
Stud
entZ
on e
Man
12
ager
Enquiry details
13
USE CASE DIAGRAM
Marks verification
Student Conduct
Open
Administrator
Register User
14
C tion
l
o
s Create Course Catalogue
e
R
e
g
is
tr
at Collect codes information
i
o
n
P
r
o
v
i
d
e
c
o
u
r
s
e
i
n
f
o
r
m
a
15
16
Data Structure
Table Structure In Details:
o LOGIN_MST:
Field Name Data Type Descriptions Constraints
U_id Int User id Primary Key
U_name Varchar(100) User name Not Null
Password Varchar(100) Password Not Null
o STAFF_MST
Field Name Data Type Descriptions Constraints
Teacher_id Int Teacher id Primary Key
Teacher_name Varchar(20) Teacher name Not Null
Photo Varchar(MAX) Path Not Null
Address Varchar(MAX) Address Not Null
Contact no. Varchar(13) contact no. Null
Qualification Varchar(20) Qualification Not Null
o FACILITY_MST
Field Name Data Type Descriptions Constraints
F_id Int Facility id Primary Key
F_name Varchar Facility Name Not Null
Photo Varchar Path or photo Not Null
Remarks Varchar Remarks Null
o REG_MST
Field Name Data Type Descriptions Constraints
Stud_id Int Student id Primary Key
Stud_name Varchar Student name Not Null
Stud_city Varchar Student city Not Null
Mobile No. Int Mobile no. Not Null
Username Varchar(20) Username Not Null
Password Varchar(10) Password Not Null
17
o ADMISSION_DETAIL
Field Name Data Type Descriptions Constraints
no Int Serial no. Primary Key
Stud_id Int Student id Foreign Key
Stud_Name Varchar(20) Student Not Null
Name
Father_Name Varchar(20) Father name Not Null
Occupation Varchar(20) Father Not Null
Occupation
Address Varchar(MAX) Address Not Null
Birthdate Date Birth Date Not Null
Cast Varchar(20) Cast Not Null
Gender Varchar(5) Gender Not Null
Passed_standard Varchar(10) Last Not Null
Standard
Last_School_Name Varchar(20) School Name Not Null
Last_Year_Result Varchar(10) Result Not null
Stream Varchar(10) Stream Null
o MERIT_DETAIL
Field Name Data Type Descriptions Constraints
Sr_no. Int Serial Number Primary Key
Stud_id int Student Id Foreign Key
Stud_Name Varchar(20) Student Name Not Null
Percentage Varchar(5) Student Not Null
Percentage
o FEEDBACK_DETAIL
Field Name Data Descriptions Constraints
Type(Size)
Sr_no. int Serial Number Primary Key
Stud_Id int Student Id Foreign key
Stud_Name Varchar(20) Student Name Not Null
Remarks Varchar(Max) Student Null
Remarks
18
POST IMPLIMENTATION REVIEW
FUTURE ENHANCEMENT
19