A_Research_Paper_on_College_Management_S.pdf

International Journal of Computer Applications (0975 – 8887)
Volume 122 – No.11, July 2015
32
A Research Paper on College Management System
Lalit Mohan Joshi
M.tech scholar
BTKIT Dwarahat, Almora, Uttarakhand
ABSTRACT
This paper is aimed at developing an Online Intranet College
Management System (CMS) that is of importance to either an
educational institution or a college. The system (CMS) is an
Intranet based application that can be accessed throughout the
institution or a specified department. This system may be
used for monitoring attendence for the college. Students as
well as staffs logging in may also access or can be search any
of the information regarding college. Attendance of the staff
and students as well as marks of the students will be updated
by staff. This system (C.M.S ) is being developed for an
engineering college to maintain and facilitate easy access to
information. For this the users must be registered with the
system after which they can access as well as modify data as
per the permissions given to them. CMS is an intranet based
application that aims at providing information to all the levels
of management with in an organization. This system can be
used as a knowledge/information management system for the
college. For a given student/staff (technical/Non-technical)
can access the system to either upload or download some
information from the database.
1. INTRODUCTION
The title of the project is “COLLEGE MANAGEMENT
SYSTEM FOR COLLEGE” (CMS). CMS is defined as an
application based on Intranet that aims to all the levels of
management providing information within an organization.
This system can be used as a information management system
for the college.
For a given student/staff (Technical / Non-technical) the
Administrator creates login id & password, using these
student/ staff (Technical / Non-technical) can access the
system to either upload or download some information from
the database.
The front-end will be HTML pages for client side validation
with Java Script where as all business logics will be in Java
reside at middle layer. third layer of database will be
intereacted with these layers, which would be Oracle
database. The web server would be Tomcat 5.5 version.
Server have Tomcat5.5 as web server is required to start
working on this project environment like Java Runtime
Environment (JRE) as development environment and
Oracle10g as database
The project is divided into 6 scenarios; each scenario can be
developed independently. And knowledge of Java with
oracle10g is desirable to execute this project.
2. PURPOSE OF DOCUMENT
This document is the Software Requirement Specification
(SRS) for the College Management System for College
(CMS) project .The purpose of this document is to describe
the functionality, requirements and general interface of the
CMS.
3. SCOPE FOR DEVELOPMENT OF
THIS PROJECT
The requirement of the user is to
 Access/ Search information.
 Login to the system through the first page of the
application
 Change the password after logging into the system
 View/change his/her details.
 Can get help through the help option to view different
features of the system.
 Students can give feedback on college/staff/any other
student.
An admin login should be present who can read as well as
remove any uploads
4. OVERVIEW OF DOCUMENT
This document describes the product and its requirements and
constraints. It provides a primarily non-technical description
of the project targeted towards external audiences. This
section includes information such as data requirements,
functional requirements, and a general description of the
product and its interaction with users from the perspective of
the client. Section 3 provides specific technical requirements
as the team understands them at this time and is intended for
an internal audience. This section includes information such
as external interface requirements, performance requirements,
and any other technical requirements needed to design the
software.
5. GENERAL DESCRIPTION
User Characteristics: The target audience for CMS
product is the college students/staff (Technical/Non-
technical). The users for this system are
Administrator – The Super user of the system.
Student – A user with limited access rights.
Staff – A user of the system who has more access rights than a
normal user.
Product Perspective
The product will be a standalone application and may be run
on multiple systems within an Intranet network. The product
will require a keyboard, mouse and monitor to interface with
the users. The minimum hardware requirements for the
product are specified in this document.
Overview of Functional Requirements The client
requires the following features:

33
 The administrator governs the working of the
system.
 The staff can view the student’s details.
 A mechanism to uniquely identify each student
 The students can view their marks/attendance/exam
schedules .
 The system should have a login.
 The system should have help feature.
Non functional requirements
CLIENT:
Hardware platform:- PIII or above with
RAM of 128 or 20GB or above Hard disk.
Software Platform:- Java Enabled Browser
SERVER:
Hardware Platform:- PIII or above with
RAM of 128 or above MB,20GB or above of Hard Disk.
Software Platform:-
HTML,Java,JavaScript,Oracle10g,tomcat5.0,windowsserver2
003.
6. USER VIEW OF PRODUCT USE:
The front view of the system consists of different services
provided by the system and a login page with which a user is
prompted to login in to the system through his user name and
password. Upon the student's login, his/her details are updated
in to the system. When all data is entered, the student can not
only view their details but also view their exams and report
details. When the student's session ends, all data is saved.
Staff can also login to the system with their id and password
and has access to the system.
There will be a special login name and password (to prevent
students in updating their details other than profile) to allow
the teacher to access all student data in a table form. Here, the
administrator can add students and staff to the system and
change student and staff details.
7. SPECIFIC REQUIREMENTS:
1. External Interface Requirements:
 Simple, Attractive, User Friendly
 Self-Contained, Consistent, Self-Explanatory
 Robust.
2. Main modules of the system:
Campus Information: This module gives the information
about
Buildings/Blocks: It contains the information about the total
number of blocks present in the campus and also the number
of rooms present in each block.
 Laboratories: This gives the information about the
number of laboratories present in each department.
 Buses: This gives the count of the buses deployed
by the management.
 Library: students can borrow/return and can view
status of books present in the library
Administration: This module deals mainly with,
 Admission: This mainly deals registering the
students/staff and assigning them with a login id and
password.
 Accounts: This keeps track of the financial details
of the college.
 Hostel: It gives information about the college hostel
for both boys and girls.
 Bus Routes: This maintains the route details of the
buses.
Department Information: This module gives the information
about,
 Course: This contains the information about the
number of the courses offered by the college and
number of seats present in each.
 Staff: This contains the number of staff available in
each department.
 Infrastructure: This has the details of the assets
allotted for each department.
 Syllabus: This provides the academic syllabus of the
students from different branches.
Staff Information: This module deals mainly with,
 Profile: This provides personal details of the staff.
 Attendance: This provides the staff with his/her
attendance details.
 Salary: This provides the staff with his/her salary
details.
 Feedback: This feature enables the staff to provide
feedbacks to the management.
 View Student Details: This provides the staff to
view the student details.
Student Information: This module gives information about,
 Profile: This provides personal details of the
student.
 Attendance: This provides the student with his/her
attendance details.
 Marks: This provides the internal/external marks of
a student.
 Feedback: This feature enables the student to
provide feedbacks to the management.
 Remarks: It contains the remarks written by the
faculties about a student.
 Change Password: Provides the student to change
his/her password.
Examination Branch: This module contains the information
about,

34
 Examination Form: This gives the information
about the issue of the examination form.
 Results: This contains the internal/externals marks
of a student.
 Attendance: It maintains the attendance of all the
students (in order to issue the examination form).
 Schedule: This has the various examinations
schedules/timetables.
 Seating Arrangement: This has the seating
arrangements for the various examinations.
8. SYSTEM DESIGN
PURPOSE: Purpose of College Management System for a
College (CMS) Design Document is to describe the design
and the architecture of CMS. The design is expressed in
sufficient detail so as to enable all the developers to
understand the underlying architecture of CMS. Logical
architecture of JDBC driver, Server, DML, DDL, Session and
Data Store are explained.
TARGET AUDIENCE
This Design document is intended to act as a technical
reference tool for developers involved in the development of
College Management System (CMS).This document assumes
that you have sufficient understanding of the following
Concepts
 RDBMS and its various component modules.
 SQL
 Java and JDBC
 Interaction Diagrams
 Classes and Interfaces
PRE-REQUISITES:
CMS requires Java JRE 1.5 or higher. Since CMS is written in
Java, it can run on any platform that supports the Java runtime
environment 1.5 or higher. The compiled files are contained
in Java Archives (JAR’s) and have to be defined in the
CLASSPATH environment variable.
Top Level Interaction Diagram
Logical architecture of JDBC driver, Server, DML, DDL, Session and Data Store
9. ARCHITECTURAL STRATEGIES:
The architectural design of a software project is simply the
design of the entire software system. This includes the
hierarchy of the modules and also which modules are present
in the system. A good architectural design will create a clear
and fair balance between cohesion (each module has only one
distinct purpose), coupling (no two modules depend
completely on each other), abstraction (seeing
modules in full and not in detail), hierarchy (logical modules
stem from others) and partitioning (logically grouping
modules together) of the software modules
JDBC
DRIVER
SERVER
DDL DML
SESSION
Data Store

35
Logical view:
It provides the user with an abstract view of the overall system functionality.
Fig. Abstract view of CMS
10. DATA FLOW DIAGRAMS:
 The whole architectural structure stems from the
original flow design. Below are the Level 0, Level
1, Level 2 and Level3 Data Flow Diagrams (DFD)..
The diagrams below more accurately portray the
data flow through our system. These diagrams take
precedence over the diagrams in the requirements
document.
Level 0 DFD
USER
INTERFACE
BUSSINESS
LOGIC
DATA
ACCESS
DATA
STORE

36
Level 1 DFD
Level 2 for DEPARTMENT

37
Level 2 for ADMIN
Table 1 for USERS
Table no: 1
Table Name: Users
Table Description: Contains usernames and passwords of all the users in the
system.
Seq no Column name Column description Column type PK/FK? Null/Not
Null
Remarks
1 User name User name VarChar PK Not Null
2 Password Password VarChar
3 Designation Admin/student/staff varChar
Relationships: None
Constraints:
 Key Constraints: username is the primary key and must be unique.
 Referential Integrity: N/A
 Check Constraints: None
 Domain Constraints: None
 Expected Volume: None
Table 2 for STUDENTS
Table No: 2
Table Name: Student
Table Description: Contains all the details of students i.e student name, address,
phone number, etc.
Seq no Column Name Column Description Column
Type
PK/FK? Null/Not
Null
Remarks
1 Studentid User name of the
student
Varchar PK Not Null

38
2 Firstname First name of the
student
Varchar
3 Lastname Last name of the
student
Varchar
4 Fathersname Student’s father
name
Varchar
5 Address Student’s
permanent address
Varchar
6 Gender Sex of the student
i.e M/F
Varchar
7 Dateofbirth Date of Birth Varchar
8 Dateofjoin Joining date Varchar
9 Course CSE/ECE/EEE Varchar
10 Email e-mail id Varchar
11 Cas Caste –
OC/SC/BC/ST
Varchar
12 Religion Religion Varchar
13 Nation Nationality Varchar
14 Idmarks Identification marks Varchar
15 Designation student Varchar
16 Password Password Varchar
17 Image URL of the students
photo
Varchar
Relationships: None
Constraints:
 Key Constraints: student id is the primary key and must be unique.
 Expected None: None

39
TABLE 3 for STAFF
Relationships: None
Constraints:
Key Constraints: employee id is the primary key and must be unique.
Table 4 for FEEDBACK
Table No: 4
Table Name: feedback
Table Description: Contains all the feedback given by the staff
Seq No Column Name Column Description Column
Type
PK/Fk? Null/Not
Null
Remarks
1 fromuserid Sending userid Varchar
2 Feedbackon College/Staff/students Varchar
3 Comments Comments text
4 Touserid Destinationuserid Varchar
5 Pdate Current date Date
Relationships: users
Table No: 3
Table Name: Staff
Table Description: Contains all the details of staff i.e. staff name, address, phone
number, etc.
Type
PK/FK? Null/Not Null Remarks
1 employeeid User name of the
staff
Varchar PK Not Null
2 Firstname First name of the
staff
Varchar
3 Lastname Last name of the
staff
Varchar
4 Address Staff’s permanent
address
Varchar
5 Gender Sex of the staff i.e
M/F
Varchar
6 Date of birth Date of Birth Varchar
7 Date of join Joining date Varchar
8 Phone No. Phone number Varchar

40
Constraints:
 Key Constraints: user id is the primary key and must be unique.
 Referential Integrity: user id match with user id in users table
TABLE 5 :FOR ATTENDANCE
Table No: 5
Table Name: Attendance
Table Description: Contains the attendance of the students/staff.
Seq No Column
Name
Column
Description
Column
Type
PK/FK? Null/Not
Null
Remarks
1 userid User id Varchar FK
2 attendance Attendace
percentage
Varchar
Relationships: users
Constraints:
 Key Constraints: user id is the Foreign key.
 Referential Integrity: user id match with user id in users table
Table 6 for ACCOUNTS
t 6
Table Name: Accounts
Table Description: Contains the fee details of the students.
Type
PK/FK? Null/Not
Null
Remarks
1 Student id User name of the staff Varchar FK
2 First name First name of the staff Varchar
3 Last name Last name of the staff Varchar
4 Course CSE/EEE/ECE/ME Varchar
5 Pay for Nature of payment
(bus, College,..)
Varchar
6 Year of pay Which year of the course Varchar

41
7 Modeofpay Mode of payment
(DD/Cheque)
Varchar
8 Amount Amount Paid Varchar
11. IMPLEMENTATION
CMS Home Page
This is the home page for Knowledge management system. This page also contains the discussion forum topics. Here teaching/non-
teaching staff or student can login by their id & password.
ABOUT CMS
This screen gives the overview of the Knowledge Management System i.e., the main modules in KMS
INFRASTRUCTURE
This screen tells about the student/staff admission. The admission will be provided by the administrator. The administrator provides
the ID and Password for the student and staff.

42
STUDENT ADMISSION FORM
The BELOW screen provides the administrator, the different fields to be filled to give an admission to student.
SYLLABUS

43
TEST CASES
Test case 1: Authentication
Test case#: validity of name and password/priority (H, L)-
High
Test objective: To check the name of the user
Testdescription:Tocheckwhether username and pds valid or
not
Requirements verified: valid user
Test Environment: Tomcat server, database.
Test setup/reconditions:
Actions Expected results
Correct name and pwd
entered
The user will be logged in
Wrong name and pwd
entered
Generates an error report
Pass: yes Condition pass: … Fail: Problems/issues:
None
Notes: successfully tested and executed.
Test case 2: E-mail verification
Test case#:- validation of e-mail/priority (H, L)-High
Test objective:- validity check for e-mail
Test description:- To check whether the e-mail is valid or not
Requirements verified:- valid e-mail
Test Environment:- Tomcat server, database.
Test setup/reconditions
Actions Expected results
Correct e-mail entered Validation cleared
Wrong e-mail entered Displays an error prompt
Pass: yes Condition pass: … Fail: …….
Problems/issues: None
Notes:- successfully tested and executed
12. CONCLUSION
The project entitled as College Management System is the
system that deals with the issues related to a particular
institution.
 This project is successfully implemented with all
the features mentioned in system requirements
specification.
 The application provides appropriate information to
users according to the chosen service.
 The project is designed keeping in view the day to
day problems faced by a college.
13. REFERTENCES
[1] D B Heras, D. Otero,and F. Arguello,” An eco feedback
system for impro ving the sustainability Performanceof
universities,” in Proc. 2011 IEEE International
Conference on Virtual Environments Human –Computer
Interfaces and Measurement Systems, Ottawa, ON 2011
, pp. 1 – 6
[2] Y Wang, B Y Sun, and F Cheng,“Electronic document –
based process model for image archives in niversities,”
in Proc. 2011 IInternational Conference on Information
Technology, Computer Engineering, and Management
Sciences , Nanjing, Jiangsu , pp. 57– 60
[3] X. X. Xin, R. M.Wu,and H. H.Li,“A faremework model
of the e-campus management system based on SOA,” in
Proc.2009 International Conference on Computational
Intelligence and Software Engineering Wuhan, 2009, pp.
1-3[4] H. M. Weiand L. J.He, “Constructing the
comprehensive academic affairs management system
based on SOA,” in Proc. 2009 1stInternational
Conference on Information Science and Engineering,
Nanjing, Jiangsu, pp. 3261-3264
[4] S. Jeyalatha, B. Vijayakumar,and G.S. Wadhwa, “Design
and implementation of web based application for
relational data maintenance in an university
environment,” in Proc. 2011 International Conference
and Workshop on Current Trends in Information
Technology , Dubai,pp. 105-112
[5] M-H.Lee, C -J.Yooand O.-B.Jang,“Embedded System
Software Testing Using Mobile Service Based On SOA”,
IJAST,vol. 1, (2008), pp. 55-64
[6] S.H. Al-Daajeh, R.E Al- Qutaish and Fuad Al-Qirem,
“Engineering Dependability to Embedded Systems
Software via Tactics”, IJSEIA, vol. 5,no.4,(2011),pp. 45-
62
[7] Ming-Syan Chen, Jiawei Han, Philip S yu. Data Mining:
An Overview from a Database Perspective[J]. IEEE
Transactions on Knowledge and Data Engineering, l996,
8(6):866-883.
[8] R Agrawal ,T 1 mielinski, A Swami. Database Mining: A
Performance Perspective[J]· IEEE Transactions on
Knowledge and Data Engineering, 1993,12:914-925.
[9] Vasant Dhat. Data Mining In Finance: Using
Counterfactuals to generate knowledge from
organizational information
[10] System[J].Information System,1998,23(7):423-437.
[11] Rakesh Agrawal, Sakti Ghosh, Tomasz Imielinski, Bala
lyer, Aran Swami. An Interval Classifier for Database
Mining Applications[M]. CLDB92. Vancouver, British
Coumbia, Vanada, 1992:560～573.
[12] J Han, Y Cai, N Cercone. Knowledge Discovery in
Database: An Attribute-Oriented Approach [M]. VLDB-
92, Vancouver, British Columbia,Canada,1992:547-559.
[13] J.Hipp, U.Guntzer, G.Nakhaeizadeh. Algorithms for

44
association generation. In Proc ACM-SIGMOD. Dallas,
TX, May 2000. 1-12
[14] Advanced Embedded System Assisted GsmAndRfid
Based Smartschool Management System.V.
Sivasankaran, S. Muruganand,
Azha.Periasamyinternational Journal Of Advanced
Research In Electrical, Electronics And Instrumentation
Engineering Vol. 2, Issue 7, July 2013.
[15] An Efficient Automatic Attendance System Using
Fingerprint Reconstruction Technique.Josphineleela.R
Research Scholar Department Of Computer Science And
Engineering
[16] Sathyabamauniversity chennai,India Dr.M.Ramakrishnan
Professor/Hod-It Velammal Engineering College
Chennai,India(Ijcsis) International Journal Of Computer
Science And Information Security,Vol. 10, No. 3, March
2012 Online Attendance Management System Using
RFID with Object Counter AnkitaAgrawal and
AshishBansal Department of Information Technology,
ShriVaishnav Institute of Technology and Science,
Baroli, Sanwer Road, Indore, India.International Journal
of Information and Computation Technology.ISSN 0974-
2239 Volume 3, Number 3 (2013).
[17] N. M. Z. Hashim and S. N. K. S. Mohamed,
“Development of Student Information System” ,
Universitiy Teknikal Malaysia Melaka, vol. 2, pp. 256 -
260, August 2013.
[18] S.R.Bharamagoudar, Geeta R .B. and S.G.Totad, “Web
Based Student Information Management System”,
[19] Andhra Pradesh, vol. 2, pp. 2342-2348, june 2013
Agrawal R, Srikant R. Privacy-Preserving Data Mining.
ACM SIGMOD Conference on Management of
Data.Dallas,Texas,2000.439-450.
[20] Hand D, Mannila H, Smyth P. Principle of Date Mining,
Cambridge, CA. MIT Press, 2001:1-2.
[21] Han J W, Kamber M. Data Mining: Concepts and
Techniques. San Francisco: CA. Morgan Kaufmann
Publishers. 2001:2-4.
.
.
IJCATM : www.ijcaonline.org

A_Research_Paper_on_College_Management_S.pdf

Recommended

Recommended

More Related Content

Similar to A_Research_Paper_on_College_Management_S.pdf

Similar to A_Research_Paper_on_College_Management_S.pdf (20)

More from MUSHAMHARIKIRAN6737

More from MUSHAMHARIKIRAN6737 (7)

Recently uploaded

Recently uploaded (20)

A_Research_Paper_on_College_Management_S.pdf