School Management System
School Management System
School Management System
DECLARATION
I hereby declare that this project report entitled MANAGEMENT
ONLINEMANAGEMENT SYSTEM, submitted to the Sri Guru
TeghBahadur
Institute Of
Management &
Information
ANISH SAHNI
BCA 5th SEMESTER
02490202014
CERTIFICATE
Place: Delhi
ACKNOWLEDGEMENT
ANISH SAHNI
ABSTRACT
TABLE OF CONTENT
S.no
TOPIC
1
CANDIDATES DECLARTION
ACKNOWLDGEMENT
CERTIFICATE
ABSTRACT
PageNo.
LIST OF TABLES
5
6
LIST OF FIGURES
LIST OF SYMBOLS
CHAPTER 1- INTRODUCTION
10
1.2Objective Of The Project
11
1.3Scope Of Project
12
13
14
2.1 Introduction
15
16
2.3 Functional Requirements Of
The Project
17
2.4 Hardware Requirements
18
2.6 Technologies Used
19
20
21
3.1 Introduction
22
23
24
0-level
25
1-level
26
2-level
27
28
4.1 Introduction
29
30
31
CHAPTER 5-TESTING
32
6.1 Introduction
33
34
35
36
37
8.1Future Enhancement
APPENDICES
38
Biblography
LIST OF TABLES
s.no
1
2
3
Table
Table 1- Hardware
requirement
Table 2- Software
requirement
Table3- Technologies
used
Page number
LIST OF FIGURES
Sno
Figure
Page
Number
LIST OF SYMBOLS
Icon
Name
Use Case
Association
Actor
System
Include
Data Flow
Dependency
Generalization
Process
Source
Data Store
Entity
Attribute
Multivalued Attribute
Derived Attribute
CHAPTER-1
INTRODUCTION
1.1 Introduction
Education system forms the backbone of every nation. And hence
it is important to provide a strong educational foundation to the
young generation to ensure the development of open-minded
global citizens securing the future for everyone. Advanced
technology available today can play a crucial role in streamlining
education-related processes to promote solidarity among
students, teachers, parents and the school staff.
Education is central to development. It is one of the most
powerful instruments for reducing poverty and inequality and lays
a foundation for sustained economic growth. With this aim
currently our government has given special emphasis to the
educational sector and school improvement activities such as
continuous professional development for teachers, training and
maintain
long
period
data
thats
why
we
used
CHAPTER-2
REQUIREMENT AND ANALYSIS
School administrator wants to build the system that technically
and economically strong and helpful to company progress. He
wants to reduce large man-power involved
in company to
perform the task that high company cost and slow company work.
For future use all documents are kept in written or in a file in
secure manner. If a file gets lost it cannot be retrieved in any way.
A large storing area is required to store the data manually.
The purpose of software requirements specifications is to provide
a framework that enables the manager to take reasonable
estimates of resources, cost and schedule. These estimates are
made with a limited time frame at the beginning of a software
project and should be updated regularly as the project progresses.
In addition estimates should attempt to define best case and
worst case scenarios so that project outcomes can be bounded.To
gather the requirement of clients need, we take the idea about
the data flow from other school websites and also refer
documents of school.
2.1 Introduction
Requirement is determining the needs or conditions to meet for a
new or altered product.Requirement analysis is critical to the
success of a systems or software project. The requirements
should be documented, actionable, measurable, testable,
traceable, related to identified business needs or opportunities,
and defined to a level of detail sufficient for system design.
in company to
perform the task that high company cost and slow company work.
For future use all documents are kept in written or in a file in
secure manner. If a file gets lost it cannot be retrieved in any way.
A large storing area is required to store the data manually.
The purpose of software requirements specifications is to provide
a framework that enables the manager to take reasonable
estimates of resources, cost and schedule. These estimates are
made with a limited time frame at the beginning of a software
project and should be updated regularly as the project progresses.
Visitor:
User:
Component
Recommended
Processor
Secondary
Storage
500GB HDD
Memory
4 GB
Network Adaptor
WIFI
Component
Recommended
OS
Windows 7
Software
Visual Studio
Component
Recommended
Operating System
Windows 7
Technologies
Net Beans, C#
Front-end Tool
Asp.net ,HTML,
CSS,ado.net
Back-end Tool
SQL Server
Scripting Tool
Java Script
CHAPTER-3
SOFTWARE DESIGN
3.1. Introduction
Software design is an engineering process by which we are
representing of something that is to be built. It is a blueprint for
constructing the software... After making Software Requirement
Specification of the project, now we are in position to design the
software.
0 levels DFD:
L ib ra ry In fo .
2 .0
L ib ra ry
M anagem ent
P ro cess
S tu d e n t R e c o rd
1 .0
S tu d e n t
A d m is sio n
P ro c e ss
S tu d e n t M a s te r F ile
F e e D a ta b a s e
F e e S tru c tu re
M a rk s D a ta b a s e
4 .0
E x a m in a tio n
T C D a ta b a s e
5 .0
T C R e co rd
U p d a tio n
M o n th ly F e e
R e c o rd
3 .0
M o n th ly F e e
C o lle c tio n
Fi
gure: 1 level DFD
st
1 .1
R e g is tra tio n
E n try
U p d a tio n R e q u e s t
T C G iv e n b y S c h o o l
M ark s
S tu d e n t D e ta il
S tu d e n t R e c o rd
1 .2
A d m is s io n
C o n firm
C o n firm
R e je c tio n
F e e D a ta b a s e
A d m is s io n D e ta il
1 .5
E x a m in a tio n
S tu d e n t D e ta il
F e e B ill D e ta il
1 .3
F e e B ill
G e n e r a tio n
B ill D e ta ils
M a rk s D a ta b a s e
S tu d e n t D e ta il
F e e S tr u c tu r e
S tu d e n t M a s te r F ile
T C D e ta il
1 .6
T C R e c o rd
U p d a tio n
F e e D e ta ils
M o n th ly F e e R e c o rd
T C D a ta b a s e
1 .4
M o n th ly F e e
C o lle c tio n
CHAPTER-4
DATABASE DESIGN
4.1 Introduction
Data design is the backbone of any RDBMS related software. So
first we are creating the database. Database design is a process
by which we transform the information gathered enduring the
analysis into the data structures.
4.2Database Fields Specification
Table 1: Academic Year
ER Diagram
CHAPTER-5
TESTING
5.1. Introduction
Executing a program with the intent of finding errors is called
testing. Testing is vital to the success of any system. Testing is
done at different stages within the development phase. System
testing makes a logical assumption that if all parts of the system
are correct, the goals will be achieved successfully. Inadequate
testing or no testing at all leads to errors that may come up after
a long time when correction would be extremely implementation.
The testing of the system was done on both artificial and live
data. In order to test data test cases are developed. Following are
the various methods that are employed for testing:
Unit Testing
In unit testing the module is tested independently. It is done to
test that the module does satisfy the functional specification. This
is done to check syntax and logical errors in programs. At the
time of preparation of technical specifications, unit test data was
also prepared. The coding for that program was considered after
verifying its output against this test data.
Integration Testing
the
system
is
performing
as
according
to
the
Title
Successful
admin
verification
Description
Expected Outcome
outcome
occured
Resul
t
Admin should
be log in with
the correct
login ID and
password
Login
Login is
Passe
should be successful d
successful
Unsuccessf
ul admin
verification
due to
wrong
password
The login to
the system
with a wrong
password.
Login
should fail
with an
error
invalid ID
and
password
.
Login fails
Passe
d
Unsuccessf
ul user
verification
due to
wrong
userID
The login to
the system
with a wrong
UserID
Login
should fail
Login fails
passe
d
Registrati
on
Successful
.
Registrati Passe
on
d
Successful
.
visitor.
4
User can
view /print
admission
slip
User can
successful successful Passe
view /print
d
admission slip
by entering
valid
admissionID
Successful
admission
and
payment
Databases
have entry of
new
Admissions
payment
details
Data of
should be
stored in
database
Data is
stored
successful
ly
Passe
d
6.
Successful
user
verification
User should
be logged in
with correct
UserID
Login
Login
passe
should be should be d
successful successful
1. Admin Module
2.
<h:head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<link href="./../resources/css/default.css" rel="stylesheet"
type="text/css" />
<h:outputStylesheet library="css" name="default.css"/>
<h:outputStylesheet library="css" name="cssLayout.css"/>
<title>
<ui:insert name="title">School Management</ui:insert>
</title>
</h:head>
<h:body>
<div id="container">
<div id="top">
<ui:insert name="top">
<p:panel style="min-height: inherit; height: inherit;">
<f:view>
<p:outputPanel>
<p:panel style="margin: 0px 0px0px 150px;padding: 0;border: 0;fontvariant: normal;background: none;" styleClass="menu">
<li><h:link value="Home" outcome="../index.xhtml"/></li>
<li><h:link value="Notice" outcome="../public/publicNotice.xhtml"/></li>
<li><h:link value="Result" outcome="./../public/publicResult.xhtml"/></li>
<li><h:link value="About us" outcome="../about.xhtml"/></li>
<li><h:link value="Contact us"
outcome="./../public/contactus.xhtml"/></li>
</p:panel>
</p:outputPanel>
</f:view>
</p:panel>
</ui:insert>
</div>
<!--<p:panel>
<ui:insert name="top">
<p:panel style="height: 70px; border: 0;padding: 0;">
<p:outputLabel value="SMS Public School" style="font-size: 25pt;fontvariant: small-caps;font-weight: bold;"/>
</p:panel>
<h:panelGrid id="menubarpg" columns="2" style="width: inherit;padding:
0;margin: 0;">
<h:form>
<p:menubar style="margin: 0px 0px0px 150px;padding: 0;border: 0;fontvariant: small-caps;background: none;">
<p:menuitem value="Home" outcome="../index.xhtml" style="width:
70px;text-align: center;"/>
<p:menuitem value="Notice" style="width: 70px;text-align: center;"/>
<p:menuitem value="Result" style="width: 70px;text-align: center;"/>
<p:menuitem value="About us" outcome="../about.xhtml" style="width:
70px;text-align: center;"/>
<p:menuitem value="Contact us" style="width: 70px;text-align: center;"/>
<p:menuitem value="log in" outcome="../login.xhtml" style="width:
70px;text-align: center;"/>
</p:menubar>
</h:form>
<p:inplace label="log in" editor="true" style="width: 70px;text-align:
center;"
</div>
</p:tab>
<p:tab title="Notice">
<div class="adminMenu">
<h:link value="Notice" outcome="notice.xhtml"/>
</div>
</p:tab>
<p:tab title="Others">
<div class="adminMenu">
<h:link value="Admin Home" outcome="adminPanel.xhtml"/>
</div>
</p:tab>
</p:accordionPanel>
</p:panel>
</ui:insert>
</div>
<div id="content" class="left_content">
<p:panel style="min-height: inherit;">
<ui:insert name="content">Content</ui:insert>
</p:panel>
</div>
</div>
<div id="bottom">
<ui:insert name="bottom">
<p:panel style="min-height: inherit; margin: 0 auto;text-align: center;">
<ui:composition template="./adminTemplate.xhtml">
<ui:define name="title">
School Management - Admin - Exam info
</ui:define>
<ui:define name="content">
<f:view>
<h:form id="addform">
<p:growl id="grl" showDetail="true"/>
<p:fieldset legend="Add Exam Title" style="font-size: 9pt" >
<p:panelGrid columns="3">
<p:column>
<p:outputLabel value="Exam Title"></p:outputLabel><br/>
<p:inputText value="#{examTitleBean.examTitle}"></p:inputText>
</p:column>
<p:column>
<p:outputLabel value="Description"></p:outputLabel><br/>
<p:inputText value="#{examTitleBean.examDescription}"></p:inputText>
</p:column>
<p:column>
<p:commandButton value="Save" action="#{examTitleBean.insertExam()}"
update=":dtform:exTitle,:addform:grl" icon="ui-icon-disk"/>
</p:column>
</p:panelGrid>
</p:fieldset>
</h:form>
<h:form id="dtform">
<p:dataTable id="exTitle" value="#{examTitleBean.allExamTitle}"
var="item" style="font-size: 9pt">
<p:column style="width: 40px;">
<f:facet name="header">Exam Id</f:facet>
#{item.examTitleId}
</p:column>
<p:column style="width: 150px;">
<f:facet name="header">Exam Title</f:facet>
#{item.examTitle}
</p:column>
<p:column>
<f:facet name="header">Description</f:facet>
#{item.examDescription}
</p:column>
<p:columnheaderText="Option" style="width: 100px;">
<p:commandButton value="Edit"
action="#{examTitleUpdate.doSetSelectedRow()}"
oncomplete="editdialog.show()" update=":dtform:editpane" icon="ui-iconpencil" style="font-size: 7pt;">
<f:setPropertyActionListener target="#{examTitleUpdate.selectedRow}"
value="#{item}"/>
</p:commandButton>
<p:spacer width="3px"/>
<p:commandButton value="Delete"
action="#{examTitleBean.deleteExam()}"
update=":dtform:exTitle,:addform:grl" icon="ui-icon-close" style="color:
#D20005;font-size: 7pt;">
<f:setPropertyActionListener target="#{examTitleBean}"
value="#{item}"/>
</p:commandButton>
</p:column>
</p:dataTable>
<p:spacer/>
<p:commandButton value="Update"
action="#{examTitleUpdate.updateExam()}"
update=":dtform:exTitle,:addform:grl" oncomplete="editdialog.hide()"/>
</p:panelGrid>
</p:dialog>
</h:form>
</f:view>
</ui:define>
</ui:composition>
</body>
</html>
Marks-
<ui:composition template="./adminTemplate.xhtml">
<ui:define name="title">
School Management - Admin - Result info
</ui:define>
<ui:define name="content">
</ui:define>
</ui:composition>
</body>
</html>
Registration-
<body>
<ui:composition template="./adminTemplate.xhtml">
<ui:define name="title">
School Management - Admin - Registration info
</ui:define>
<ui:define name="content">
<f:view>
<h:formenctype="multipart/form-data">
<p:panel id="all" style="font-size: 9pt;padding: 0;margin: 0;border: none;">
<p:growlshowDetail="true" id="g"/>
<p:fieldset legend="Basic Information">
<h:panelGrid columns="3" cellpadding="7"
columnClasses="firstcolumn,centercolumn,thirdcolumn" style="margin: 0
auto;">
<p:message for="acy"/>
</h:panelGrid>
</p:fieldset>
<h:panelGrid columns="1" style="margin: 0 auto;">
<p:commandButton value="submit"
action="#{newStudentBean.doInsert()}" update="all,g" ajax="false"/>
</h:panelGrid>
</p:panel>
</h:form>
</f:view>
</ui:define>
</ui:composition>
</body>
</html>
CHAPTER-6
ROLES AND RESPONSIBILTY
project.
I am responsible for designing, coding, implementation and
testing of all the modules in the project.
I have used very easy and user-friendly designing tools so
that the users can interact with the system easily.
I am responsible for approving the designing tool and
database selection.
Planning and Execution of the project were done by me.
CHAPTER-7
CONCLUSION
The conclusion of SMS PUBLIC SCHOOL is to construct such
dynamic website which will provide information about school
activities such as admission system, event schedule, school timetable, important notices and dignitary messages.
Towards the end of the School Management System, I would like
to say that the target, which was initially set up, was achieved to
a good extent. The project made me realise the significance of
developing software for client, where the sole aim is to learn.
During the School Management System, the real importance for
following all principle of system analysis and design dawned on
me. I felt the necessity of going through the several stages.
As we done the initial investigation, now we can say that this
application possible to create. But as project will progress there
may some change in functionality of the project.