School Management System
School Management System
School Management System
Introduction
Page | 1
1.1 Existing System
In the current system we need to keep a number of records related to the
student and want to enter the details of the student and the marks
manually. In this system only the teacher or the school authority views
the mark of the student and they want to enter the details of the student.
This is time consuming and has much cost.
Teachers may want to associate a student with his parent or emergency
persons for disciplinary measures which need searching of the student’s
record in the record office. It has been difficult to search a record from
thousands of such records and observed that students can take any person
claiming that he/she is their parent or emergency person which creates
problem in control of students.
With traditional reporting methods parents may not find out how their
student is performing in school until the end of the quarter or semester --
usually too late to correct a problem situation. SMS allows parents to know
how their student is doing on a continual basis by using the internet. SMS
can even send electronic progress reports to parents via email on a weekly,
monthly, or even daily basis.
Page | 2
1.2 Need for System
In our proposed system we have the provision for adding the details of
the students by themselves. So the overhead of the school authorities and
the teachers is become less. Another advantage of the system is that it is
very easy to edit the details of the student and delete a student when it
found unnecessary. The marks of the student are added in the database
and so students can also view the marks whenever they want.
Less error
Search facility
The School Management System (SMS) will replace the paper-based data
collection and information exchange system among the various
departments of a particular school.
The School Management System provides an innovative solution for
Today’s school record-keeping challenges. This school management
software will give you room to handle your responsibilities whether
you’re just starting or are an experienced professional.
School Management System opens a universe of opportunities to
automate the laborious paperwork involved in proper school
management. With our proposed record-keeping software, the
management can more effectively interact with the students as they
develop skills and character for success. They will not only have more
time to spend with them, but it will be quality time because they will have
up-to-date student information to facilitate them.
Page | 3
1.4 Purpose
The purpose of any new technology is to make people life easier. This
project is database used to manage the school and allows the
administrators to register the daily required information of Students,
Teachers & office staff.
1.5 Scope
School Management System will organize work inside school
and proposed system will do the following tasks:
Insert student’s information such as student name, student number,
address etc.
View data about certain student and can edit it like adding or
removing a student.
View data about certain employee and can edit it like adding or
removing an employee.
Page | 4
1.6 Process Model
Requirement Analysis
Design
Implementation
Testing
Maintenance
Page | 5
1.6.1 Advantages:
1.7 Overview
Page | 6
2.1 The Proposed Student Information Management System
The proposed physical system will be the same as the current system.
Page | 7
2.4 Accounts Management using the system
The transactions which include fee collection of 3000 students, salary
payment for 300 staff members every month, expenditure of hostel with
1500 students, a lot of other expenses, advances and loans, sums up to a
substantial amount and requires a lot of effort and attention from both
management and staff to make it accurate and effective.
With this software, even without qualified personnel in accounting, the
staffs are very much able to handle the accounts without almost any effort
and keep every record up to date at every point in time.
Page | 8
2.6 Components of making software are
System analysis is an activity that encompasses most of the tasks that are
collectively called Computer System Engineering.
Page | 9
2.10 Ensuring, verifying and maintaining software integrity
The degree to which the software makes optimal use of system resources
as indicated by the following sub attributes: time behavior, resource
behavior. The efficiency is the amount of computing resources and code
required by a program to perform its functions.
A design should clearly be very verifiable, complete (implements all the
specification), and traceable (all design elements can be traced to some
requirements). However, the two most important properties that
concerned designers are efficiency and simplicity.
The Term “Code Optimization” refers to techniques a compiler can
employ in an attempt to produce a better object language program than
the most obvious for a given source program.
Verification and validation (V & V) is the generic name given to the
checking processes which ensure that software conforms to its
specification and meets the need of the software customer.
Verification and validation i.e. starts with requirements reviews and
continues through design and code reviews to product testing.
Page | 10
2.11 Maintenance:
The term Maintenance is a little strange when applied to software. In
common speech, it means fixing things that break or wear out. In
software nothing wears out; it is either wring from beginning, or we
decode later that we want to do something different. It is a very broad
activity that includes error corrections, enhancements of capabilities,
deletion of obsolete capabilities, and optimization.
Corrective Maintenance:
It means repairing processing or performances failures or
making changes because of the previously uncorrected problems.
Adaptive Maintenance:
It includes modifying the software to match changes in the ever-
changing environment.
Perfective Maintenance:
It means improving processing efficiency or performance, or restructuring
the software to improve changeability.
Security involves both policies and mechanism to protect data and ensure
that it is not accessed, altered or deleted without proper authorization.
Integrity implies that any properly authorized access, alteration or
deletion of the data in the database does not change the validity of the
data.
Database security policies are guidelines for present and future designers
regarding the maintenance of the data base security.
Page | 11
2.13 Architecture of a System
Page | 12
2.14 In Normal Interactive Mode (Admin)
Admin will be able to see the system, see the details of the School System
View Campus
Information
View Class
Information
View Student
Information
View Fee
Admin
Information
Grade
Information
Page | 13
Admin: Only admin have the access to login to this software.
Class: Admin have the access to view the details of all class information
of the students.
Student: Admin have the rights to add, delete or update the record of a
student of a student.
Fee: Admin need to make the fee slip or challan form and should give to
a student. And when student pay the fees, admin then have to update the
fees record of a student.
Grade: When teacher give result to the admin staff then teacher also
give grade of pass or fail marks to the student and teachers have to write
everything regarding the student details and when it’s done it should give
to a admin staff properly.
Page | 14
2.15 In Normal Interactive Mode: (Student)
Student will be able to see the details of his/her marks, class, subject, fee
and bank slip.
View Class
Information
View Subject
Information
View Fee
Student
Information
Bank Slip
Page | 15
Student: Student has no rights to access to this software. Only admin
have the access, students only have to view about his details of his career.
Marks Details: Student have only view the details of his marks, he/her
has no right to edit change or delete the result or marks.
Class Information: Student has to talk to the admin staff to get the
details of his/her class and it should talk should talk to change the class
from different group.
Subject Information: Student has the right to view its subjects
through the admin staff.
Fee Information: Student has to give the fee slip. And it should be
given all the detail to where he/her have to submit the fees.
Page | 16
2.16 In Normal Interactive Mode: (Teacher)
View job
Information
View Subject
Information
Teacher
View Class
Information
Page | 17
Teacher: Teacher has to no access to login to the software of school
system, only admin have the access to give details to the teacher.
Subject: Teacher has to view its subject information through the admin
staff.
Class: Teacher has to view its class information that should be given by
the management through the admin staff.
Page | 18
3.1 Specific Requirements
3.2 Technology Used
3.2.1 Microsoft Visual Studio 2010
Visual Studio is a complete set of development tools for
Building ASP.NET Web applications, XML Web Services,
Desktop applications and mobile applications. Visual
Basic, Visual C#, and Visual C++ all use the same integrated
Development environment (IDE), which enables tool sharing
And eases the creation of mixed-language solutions. In
Addition, these languages use the functionality of the .NET
Framework, which provides access to key technologies that
Simplify the development of ASP Web applications and XML
Web Services.
Page | 19
3.2.3 Crystal Reports
Page | 20
3.3 Functional Requirements
School management system shall be network base.
Admin shall login.
Admin shall add new student, teacher, and class and modify them.
Admin shall update school news.
Admin shall access all the data about student related.
Admin shall manage the school activity.
Admin shall generate time table.
Page | 21
The system will be used to keep information the following types of
information:
Students
Instructors
Classes
Test scores
Grades
Course registration
Fee record
The system will also generate printable reports for use by admin
staff.
Class List
Class Counts
Page | 22
3.5 Hardware requirements
Processor
Ram
Hard disk
Internet Connection
Page | 23
3.9 Performance Requirements
The system is expected to have reasonable short time response. The admin
should be able to login and should be able to get response for his requests in
2-3 second. The system’s performance is different according to its mode.
Page | 24
3.12 PROGRAM EVALUATION REVIEW TECHNIQUE
(PERT) CHART
The chart shows clearly that the project consists of the activities of Analysis,
design, front-end coding, back-end coding and report generation.
Page | 25
3.13 Reliability
In admin Mode: The system should be 99% reliable. In Normal Interactive
Mode: Since it may need some maintenance or preparation for the School
Days, the system does not need to be reliable every time. So, 80%
reliability is enough.
Page | 26
4.1Entity Relation Diagram (ER Diagram)
The admin runs on desktop application that is enabled to handle server. It
uses a relational database to keep track of the polls, which it connects
through standard database connectivity interfaces. In order to run the
setup software, the environment needs to have a fast machine running on
it.
Page | 27
4.2 Context Level Diagram
Page | 28
4.3First Level Data Flow Diagram
Page | 29
4.3.1 First Level Data Flow Diagram
Page | 30
4.3.2 First Level Data Flow Diagram
Page | 31
4.4 Second Level Data Flow Diagram
Page | 32
4.4.1 Second Level Data Flow Diagram
Page | 33
4.5 System Sequence Diagram
Admin
Choose
Generate
Validation
Failed
Proceed
Page | 34
4.5.1 System Sequence Diagram
Page | 35
4.6 Complete Data Model Class Diagram
Page | 36
4.7 Use Case Diagram
A use case is a methodology used in system analysis to identify, clarify,
and organize system requirements. The use case is made up of a set of
possible sequences of interactions between systems and users in a
particular environment and related to a particular goal. It consists of a
group of elements (for example, classes and interfaces) that can be used
together in a way that will have an effect larger than the sum of the
separate elements combined. The use case should contain all system
activities that have significance to the users. A use case can be thought of
as a collection of possible scenarios related to a particular goal, indeed,
the use case and goal are sometimes considered to be synonymous .
Page | 37
Use Case Diagram
Registration Student
Teacher
Timetable
Student
Report card
Admin Teacher
Report Attendance
Exam
Generate Attendance
View Reports
Student Teacher
Generate Result
View Result
Page | 38
4.8 Table Design
4.8.1 Username
Column Name Data Type Null
LoginID int No
LoginName varchar(10) No
Password varchar(10) No
FullName Varchar(50) Yes
Designation Varchar(50) Yes
Block Bit Yes
FyearID Numeric(9,0) Yes
locationId Int Yes
Createdby Varchar(50) No
CreationDatetime Varchar(50) No
Modifyby Varchar(50) Yes
ModificationDate Datetime Yes
Terminal Varchar(50) Yes
Windowlogin Varchar(50) yes
4.8.2 Campus
Column Name Data Type Null
UserCampusID Numeric(9,0) No
UserId Numeric(9,0) Yes
CampusId Numeric(9,0) yes
Page | 39
4.8.4 Student
Column Name Data Type Null
CampusID Numeric(9,0) Yes
StudentID Numeric(9,0) No
ClassId Numeric(9,0) Yes
SectionId Numeric(9,0) Yes
RollNo Varchar(20) Yes
StudentCode Numeric(9,0) No
StudentName Varchar(250) Yes
AdmissionNo Varchar(100) No
AdmissionDate datetime Yes
Relation Varchar(100) yes
Page | 40
4.8.6 Class
Column Name Data Type Null
ClassID numeric(9,0) No
ClassCode numeric(9,0) No
ClassTitle varchar(250) No
CampusID numeric(9,0) No
CategoryId Numeric(9.0) No
Createdby Varchar(50) Yes
CreationDate Datetime Yes
Modifyby Varchar(50) Yes
ModificationDate Datetime Yes
InsertTerminal Varchar(50) Yes
UpdateTerminal Varchar(50) yes
4.8.7 Attendance
ColumnName DataType Null
AttendanceId Int No
AttnDate Smalldatetime No
CampusID Numeric(9,0) No
StudentID Numeric(9,0) No
SectionId Numeric(9,0) Yes
LeaveId Int Yes
Createdby Varchar(30) Yes
CreationDate Smalldatetime Yes
Modifyby Varchar(30) Yes
ModificationDate Smalldatetime Yes
UpdateTerminalInfo Varchar(50) Yes
InsertTerminalInfo Varchar(50) Yes
4.8.8 Subjects
Page | 41
4.8.9 Teacher
4.8.10 Voucher
Column Name Data Type Null
VtypeId Numeric(9,0) No
Vtitle Varchar(250) Yes
Page | 42
5.1 Login Screen
Page | 43
5.2 Home Screen
Page | 44
5.3 Setup/Campus
Page | 45
5.4 Setup/Class Information
Page | 46
5.5 Setup/Subject Information
Page | 47
5.6 Setup/Fee Information
Page | 48
5.7 Setup/Attendance Report
Page | 49
5.8 Student Regristration
Page | 50
5.9 Student Information
Page | 51
5.10 Teacher Information
Page | 52
5.11 Student Promotion
Page | 53
5.12 All Student Fee Information
Page | 54
5.13 Fee Challan Slip
Page | 55
5.14 Fee Receipt Voucher
Page | 56
5.15 Student Bank Payment
Page | 57
5.16 Student Registration Report
Page | 58
5.17 Student General Report
Page | 59
5.18 Details of New Admission
Page | 60
5.19 Student Conformation Slip
Page | 61
5.20 Ledger Reports
Page | 62
5.21 Benevolence Report
Page | 63
DETAILED ANALYSIS AND PLANNING
Software project management comprises of a number of activities, which
contains planning of project, deciding scope of software product, estimation
of cost in various terms, scheduling of tasks and events, and resource
management. Project management activities may include:
Project Planning
Scope Management
Project Estimation
Page | 64
6.3.1 Project estimation may involve the following:
Software size estimation
Software size may be estimated either in terms of KLOC (Kilo Line of
Code) or by calculating number of function points in the software. Lines
of code depend upon coding practices and Function points vary according
to the user or software requirement.
Effort estimation
The managers estimate efforts in terms of personnel requirement and man-
hour required to produce the software. For effort estimation software size
should be known. This can either be derived by managers’ experience,
organization’s historical data or software size can be converted into efforts
by using some standard formulae.
Time estimation
Once size and efforts are estimated, the time required to produce the
software can be estimated. Efforts required is segregated into sub
categories as per the requirement specifications and interdependency of
various components of software. Software tasks are divided into smaller
tasks, activities or events by Work Breakthrough Structure (WBS). The
tasks are scheduled on day-to-day basis or in calendar months.
The sum of time required to complete all tasks in hours or days is the total
time invested to complete the project.
Cost estimation
This might be considered as the most difficult of all because it depends on
more elements than any of the previous ones. For estimating project cost,
it is required to consider -
Size of software
Software quality
Hardware
Additional software or tools, licenses etc.
Skilled personnel with task-specific skills
Travel involved
Communication
Training and support
Page | 65
6.4 Project Estimation Techniques
We discussed various parameters involving project estimation such as size,
effort, time and cost.
Project manager can estimate the listed factors using two broadly
recognized techniques –
Page | 66
6.6 Process Model
Since our requirements are defined properly and will not be object to
big changes, we will use Waterfall process model throughout our
system development.
Page | 67
A- Pre- phase:
Manage admin
Manage setup
Manage Transaction
Manage vouchers
B- Report phase
Submit Report
C- Result phase
View results
Generate reports
Performance testing:
Page | 68