Online Admission System Project Report
Online Admission System Project Report
Online Admission System Project Report
CONTENTS
1. INTRODUCTION
05
2. SYSTEM ANALYSIS
2.1 PROJECT IDENTIFICATION OF NEED
06
06
06
06
07
07
3.FEASIBILITY STUDY
09
09
09
10
11
125.1.1
12
13
13
14
14
15
15
15
15
16
16
6. SYSTEM DESIGN
17
17
18
18
17
18
OUTPUT DESIGN
19
19
6.4.1 NORMALIZATION
20
6.4.2 TABLES
21
1. PERSONAL DETAILS
21
2. LOGIN
22
3. EXAM
22
4. COURSE
23
5. ADDRESS
23
24
Level 0
24
Level 1
24
Level 2
25
Level 3
26
7.CODING
27
27
7.1.1 CORRECTNESS
27
7.1.2 RELIABILITY
28
7.1.3 ROBUSTNESS
28
28
28
28
28
30
7.2.3 My SQL
30
30
30
31
31
31
8.3 TESTING
8.3.1 TESTING OBJECTIVES
31
32
32
33
33
33
34
34
35
35
35
35
35
36
36
37
38
12. CONCLUSION
38
13.BIBLIOGRAPHY
39
14. APPENDICES
40
1.INTRODUCTION
Online Admission System is aimed at developing an online admission application for
a college. This system is an online system that can be accessed throughout the organization
User
Administrator
Students logging is to apply for the course by filling an applycation form provided by online.
College principal/administrator logging in may also access/search information put up by the
students.
2. SYSTEM ANALYSIS
System analysis aims at establishing requests for the system to be acquired, developed
and installed. It involves studying and analyzing the ways of an organization currently
processing the data to produce information. Analyzing the problem thoroughly forms the vital
part of the system study. In system analysis, prevailing situation of problem carefully
3.FEASIBILITY STUDY
3.1 ECONOMIC FEASIBILITY
Economic analysis is most frequently used for evaluation of the effectiveness of the
system. More commonly knows as cost/benefit analysis the procedure is to determine the
benefit and saving that are expected from a system and compare them with costs, decisions is
made to design and implement the system.
Is it advantageous?
: Multimedia PC
Processor
: Pentium 4 or above
Memory
: 512MB RAM
Hard Disk
: 80GB or above
Keyboard
: 104 standards
Monitor
: SVGA
: Dial up/Broadband
: PHP,HTML,CSS,JavaScript
: MYSQL
6. SYSTEM DESIGN
The system design develops the architectural detail required to build a system or
product. As in the case of any systematic approach, this software too has undergone the best
possible design phase fine tuning all efficiency, performance and accuracy levels. The first
step in system designing is to determine how the output is to be produced and in what format.
Samples of the output and input are also presented. In the second step, input data and master
6.1.1
LOGICAL DESIGN
Logical design of an information system shows the major features and also how they
are related to one another. The first step of the system design is to design logical design
elements. This is the most creative and challenging phase and important too. Design of
proposed system produces the details of the state how the system will meet the requirements
identified during the system analysis that is, in the design phase we have to find how to solve
the difficulties faced by the existing system. The logical design of the proposed system
should include the details that contain how the solutions can be implemented. It also specifies
how the database is to be built for storing and retrieving data, what kind of reports are to be
created and what are the inputs to be given to the system. The logical design includes input
design, output design, and database design and physical design
MODULAR DESIGN
A software system is always divided into several sub systems that makes it easier for
the development. A software system that is structured into several subsystems makes it easy
for the development and testing. The different subsystems are known as the modules and the
process of dividing an entire system into subsystems is known as modularization or
decomposition.
A system cannot be decomposed into several subsystems in any way. There must
some logical barrier, which facilitates the separation of each module. The separation must be
simple but yet must be effective so that the development is not affected.
The system under consideration has been divided into several modules taking in
consideration the above-mentioned cri
are
user module
1.
2..administrator module
6.2
INPUT DESIGN
The input design is the link between the information system and the user. It comprises
the developing specification and procedures for data preparation and those steps are
necessary to put transaction data into a usable form for processing data entry. The activity of
putting data into the computer for processing can be achieved by inspecting the computer to
read data from a written or printed document or it can occur by having people keying the data
directly into the system. The design of input focuses on controlling the amount of input
required, controlling errors, avoiding delay, avoiding extra steps and keeping the process
simple.
Methods for preparing input validations and steps to follow when error occur
the monitor for immediate need and for obtaining the hardcopy. The options for the output
reports are given in the appendix.
6.4
DATABASE DESIGN
The overall objective in the development of database technology has been to treat data
as an organizational resource and as an integrated whole. DBMS allow data to be protected
and organized separately from other resources. Database is an integrated collection of data.
The most significant form of data as seen by the programmers is data as stored on the direct
access storage devices. This is the difference between logical and physical data.
Database files are the key source of information into the system. It is the process of
designing database files, which are the key source of information to the system. The files
Data integration.
Data integrity.
Data independence.
The proposed system stores the information relevant for processing in the MS SQL
SERVER database. This database contains tables, where each table corresponds to one
particular type of information. Each piece of information in table is called a field or column.
A table also contains records, which is a set of fields. All records in a table have the same set
of fields with different information. There are primary key fields that uniquely identify a
record in a table. There are also fields that contain primary key from another table call ed
foreign keys.
6.4.1 NORMALIZATION
Normalization is a technique of separating redundant fields and braking up a large table
in to a smaller one. It is also used to avoid insertion, deletion and updating anomalies. All the
tables have been normalized up to the third normal form. In short the rules for each of the
three normal forms are as below.
6.4.2 TABLES
1. PERSONAL DETAILS
DATATYPE
regid
Varchar()
name
Varchar()
father
Varchar()
age
Integer
gender
Varchar()
religion
Varchar()
caste
Varchar()
day
Integer
Month
Integer
year
Integer
2. LOGIN
FIELDNAME
DATATYPE
Regid
Varchar()
Password
Varchar()
Type
Varchar()
Flag
Integer
3. EXAM
FIELDNAME
DATATYPE
Regid
Varchar()
Eqxam
Varchar()
Rollno
Integer
Passyear
Integer
Mark
Integer
Total
Integer
Percent
Integer
4. COURSE
FIELDNAME
DATATYPE
regid
Varchar()
course
Varchar()
FIELDNAME
DATATYPE
regid
Varchar()
house
Varchar()
post
Varchar()
street
Varchar()
city
Varchar()
pin
Integer
Email-id
Varchar()
5. ADDRESS
Level 0
User/administrator
ONLINE
ADMISSION
SYSTEM
Database
Level 1
Admin
Username + Password
login
Acces
s
studen
t
details
studentdeatail
Make the
student
admit
shortlist
Level 2
User/student
Username +
Password
Sign
Up
Login
Student details
Show
student
details
STUDENTDETAIL
Old student details
Level 3
User/student
Admin
Username + Password
Username + Password
Sign Up
login
login
Show
details
Acces
s
studen
t
details
Make the
student
admit
shortlist
STUDENTDETAIL
7.CODING
Update
student
details
Uniqueness
Meaningfulness
Stability
Simplicity
Conciseness
Versatility
The goal of the coding or programming phase is to translate the design of the system
produced during the design phase into code in a given programming language, which can be
executed by a computer and that performs the computation specified by the design. The
coding phase affects both testing and maintenance profoundly. As we saw earlier, the time
spent in coding is a small percentage of the total software cost , while testing and
maintenance consume the major percentage. Thus it should be clear the goal during coding
should not be to reduce the implementation cost, but the goal should be to reduce the cost of
later phases, even if it means that the cost of this phase has to increase. In other words, the
goal during this phase is not to simplify the job of the programmer. Rather the goal should be
to simplify the job of the tester and the maintainer.
7.1.2 RELIABILITY
7.1.3 ROBUSTNESS
The robustness of the code is associated with memory management and exception
handling. Since he proposed system is developed with HTML this feature is not ensured
profoundly.
Security
7.2.3 My SQL
My SQL query () sends a unique query (multiple queries are not supported) to the
currently active database on the server that's associated with the specified link_identifier.
The query string should not end with a semicolon. If the link identifier is not specified, the
last link opened by My SQLconnection is assumed. If no such link is found, it will try to
create one as if mysql_connect () was called with no arguments. If by chance no
connection is found or established, an E_WARNING level warning is generated.
7.3OPTIMIZATION OF CODE
Code optimization aims at improving execution efficiency of a program. This is
achieved in two ways:
techniques such as dead code elimination and frequency reduction. Thus improves the
execution efficiency.
7.4VALIDATION CHECKS
Validation means observing the behavior of the system. The verification and
validation means that will ensure that the output of a phase is consistent with its input and
that the output of the phase is consistent with the overall requirements of the system. The
College Alumni system performed validation by verifying the output of each phase. This is
done to ensure that it is consistent with the required output. If not we apply certain
mechanisms for repairing and thereby achieved the requirement.
User
Administrator
Students logging is to apply for the course by filling an applycation form provided by
online. College principal/administrator logging in may also access/search information put up
by the students.
8.3 TESTING
Software testing is a critical element of the software development cycle. The testing is
essential for ensuring the Quality of the software developed and represents the ultimate view
of specification, design and code generation. Software testing is defined as the process by
which one detects the defects in the software. Testing is a set of activities that work towards
the integration of entire computer based system.
it would uncover errors in the software. Also testing demonstrates that software functions
appear to the working according to the specification, that performance requirements appear
to have been met.
feasibility
20/12/10
06/01/11
26/01/11
11/02/11
27/02/11
02/05/11
to
to
to
to
to
to
05/01/11
21/01/11
07/02/11
21/02/11
26/04/11
29/05/11
study
Requirement
analysis
System
design
Detailed
design
Coding and
testing
Operation
and
maintenance
Figure1
9. FUTURE SCOPE
The future scope of this project is very broad
Few of them are:
This can be implemented in less time for proper admission process
10. CONCLUSION
This system, being the first We have created in PHP, has proven more difficult than
originally imagined. While it may sound simple to fill out a few forms and process the
information, much more is involved in the selection of applicants than this. Every time
progress was made and features were added, ideas for additional features or
methods to improve the usability of the system made themselves apparent.
Furthermore, adding one feature meant that another required feature was now
possible, and balancing completing these required features with the ideas for
improvement as well as remembering everything that had to be done was a project in
itself.
Debugging can sometimes be a relatively straight forward process, or rather finding
out what you must debug can be. Since so many parts of the admissions system are
integrated into one another, if an error occurs on one page, it may be a display error,
for example; it may be the information is not correctly read from the database; or
even that the information is not correctly stored in the database initially, and all three
must be checked on each occasion. This slows down the process and can be
frustrating if the apparent cause of a problem is not obvious at first.
Language used must besimple and easy to understand and compatibility is paramount. If this
system were not designed as an entirely web based application, it would not have been
possible torecreate its current state of portability.
Overall, the system performs well, and while it does not include all of the features that
may have been desired, it lives up to initial expectations. The majority of features that
are included work flawlessly and the errors that do exist are minor or graphical.
11.BIBLIOGRAPHY
An Integrated approach to Software Engineering,Narosa publishers, Third edition by
Pankaj Jalote.
14. APPENDICES
SCREENSHOTS
1.HOME PAGE
2. LOGIN PAGE
3. REGISTRATION FORM
4. USER PAGE
6. ADMINISTRATOR PAGE
8. LOGOUT PAGE