lOMoARcPSD|29792868

E-School Management System

Master of Computer Application(MCA) (Indira Gandhi National Open University)

Studocu is not sponsored or endorsed by any college or university

Downloaded by Trst Trst (codeasitis@gmail.com)
 lOMoARcPSD|29792868

E-SCHOOL MANAGEMENT SYSTEM MCS-044 MINI

PROJECT

TITLE OF THE PROJECT

E-SCHOOL
MANAGEMENT
SYSTEM

IGNOU Page 1 of 30
MCA-4

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

INTRODUCTION
E-School Management System is a comprehensive web-based School
Management Software. It is designed for better interaction between students,
teachers,parents & management. This management software very gracefully
handles all the requirements For Easy School Management. All or a majority of
the student services are conducted via Internet technology. The E-School
Management System from the traditional school through the physical media
that links administrators, teachers, and students. E-School Management
System are an alliance of public distance learning schools. Many states in the
India have their own virtual school often with a student population numbering
in the thousands. .

Governance and organization :-

The parents of students are very busy now a days, this school
management system helps the parents monitor their children from anywhere.
They can check their children's academic performance from a remote location.
They can also deposit the school fees, bus fees etc., using online secured
payment integrated with this application (online payment available with pro
version). Using this school management system the users can see the
students class attendance in various formats, day-wise, monthly attendance,
session or total attendance. Marks or report card can be viewed or added.
Assignment's & homework' s can be viewed or posted using this application.
Online leave applications can also be filed by students which gets viewed
when the teachers take the daily attendance Books, apparels & other
essential items can be bought online using the online shopping cart included
with the

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

school management system (online purchasing available in proversion).School

and class notices can also be posted using this application The School
Management System also has a built in forum which develops an online
student teacher community over the net, sharing each others ideas

E-School Management Services :-

1. View/Take Attendance
2. Report Cards Section
3. Online Fee details
4. School time-table
5. Assignments
6. Homework
7. Tutorials
8. Exam Schedule
9. Student/Teachers Profile
10. School Bus details
11. Online leave application
12. Holidays List
13. Buy books/ apparels online
14. Discussion Forum / Message Board
15. Internal Messaging System
16. School/Class Notices
17. School Dress Kits

There are many different virtual school instructional and enrollment

models. Instructional models range from fully independent self paced

(asynchronous) courses to semester based virtual (synchronous) teacher

facilitated courses. Class sizes range widely with anywhere from 25 students

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

to as many as 200 students in each class section. Students keep in contact

with teachers and collaborate with other students through web

communication tools provided in the course delivery platforms like

Blackboard or Desire2Learn or Moodle. In some cases students communicate

by phone with instructors. To help with communication many virtual schools

have implemented their own system programs to help build courses and

maintain student profiles. There are also many books and training manuals to

aid in the development of such schools and courses.

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

OBJECTIVES OF THE PROJECT

For easy and convenient processing we need to develop software which

works as per our requirements. While preparing this software we got to

remember few things i.e. this software must have a friendly environment, in

other words it should not be much complicated to handle, it should have

options for future modifications in the society i.e. Teacher list, Fee and Book

list. For smooth functioning, we had to prepare a database by which we could

enter the required data in their respective locations. In this data base all the

records of daily transactions made are stored i.e. Results, Fee generated,

Question paper etc., so that we can use them in future whenever needed.

From security point of view this software has a special login name and

password allotted to their Teacher. Other then that no one could use this and

on entering an illegal password or login name an error message get displayed.

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

PROJECT CATEGORY

Relational Data Base Management System (RDBMS) .

The proposed system comes under RDBMS category, as there is need to store

and manipulate a huge amount of data related to Fee Details, Attendence ,

Student, etc as per various queries.

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

TOOLS & PLATFORM TO BE USED

a) Operating System:-

The proposed software is targeted to run on Windows Xp, Windows NT

version 2.0 (Server/Workstation) and Windows 2000 (Professional/Server)

editions.

b) Front End:-

PHP is a general-purpose scripting language originally designed for web

development to produce dynamic web pages. For this purpose, PHP code is

embedded into the HTML source document and interpreted by a web server

with a PHP processor module, which generates the web page document. It

also has evolved to include a command-line interface capability and can be

used in standalone graphical applications.

c) Back End (Central Repository)

MySQL is a relational database management system (RDBMS) that runs as

a server providing multi-user access to a number of databases. MySQL is
officially pronounced ("My S-Q-L"),but is often also pronounced ("My

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

Sequel"). It is named after developer Michael Widenius' daughter, My. The

SQL phrase stands for Structured Query Language.

1. It is very simple to maintain.

2. It is highly secured.

3. It can support and manage a large amount of data.

4. It is a very scalable product and can support as many number

of users as supported by the infrastructure.

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

ANALYSIS

Problem Statement:-

It would be a cumbersome job to keep track of the Stuident and Fee details,

Book status, Result. If we do it manually, first we need to know how many

tables are occupied and how raw many are vacant. The front office should key

records of the customer and details of their services that come to the E-school

management system.

Requirement Analysis:-

The E-school management requires computerizing its Aducation System

Service to fully automate its corresponding activities. The requirements

from the proposed software are as follows:

d) Student`s information handling.

e) Printing of receipt.

f) Printing of Result status.

g) Printing of Fee related Reports.

h) Searching of Student, Teacher and Services.

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

E-SCHOOL MANAGEMENT SYSTEM MCS-044 MINI

PROJECT

Design:-

The table structure for the various tables to be used in the proposed

software is described in Data Structure part of this proposal.

The data flow in the software is depicted in next page through Data

Flow Diagram (DFD).

IGNOU Page 10 of 30
MCA-4

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

Data Flow Diagram (DFD)

Zero Level DFD

Zero Level DFD gives a brief overview of the entire system.

STUDENT Sport Games

Request for Book

E-SCHOOL MANAGEMEN T SYSTEM

Provide service

Request Result

STUDENT

ATTEND
Access

CLASS

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

E-SCHOOL MANAGEMENT SYSTEM MCS-044 MINI

PROJECT

FIRST LEVEL DFD

First level DFD of a system gives a broad picture of all the processes of the system and
the data transformation within the system.

STUDENT
Request for Book

Report
Information Check
Availabil
ity
Not Module
Report available
Generati
on Updat
Module Available
e Access

BOOK
Request and Bill Information

Reques t
Bill proces s
Request & Book Info
Module Module

Update Acces Access

s Update

IGNOU BILL
MCA-4 Page 12 of 30

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

E-SCHOOL MANAGEMENT SYSTEM MCS-044 MINI

PROJECT
STOCK

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

SECOND LEVEL DFD

STUDENT

Request for service

Service details Notic

SCHOO Update
L Acces s
Module

Work in
branch
Charg
e
CLASS
Modul
Charge e
Access Details
Charge for Fee
service
Teach

Teacher Charge for

Module Exam fee
Charge for Fee
Book
Request Modul
e
Expens Exam
e of Modul
Facliti
e Access
Expens Book
e Reque
Module

st Book Attend
Exam
details Fee Detail
Expense

Updat

e Access Purches
IGNOU MCA-4 Page 13 of 30
Access

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

Libra
rary STUDEN
Book info
T

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

E-R
DIAGRA
M
Downloaded by Trst Trst (codeasitis@gmail.com)
 lOMoARcPSD|29792868

IGNOU MCA-4 Page 14 of 30

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

Stu
_name
E-SCHOOL MANAGEMENT SYSTEM PROJECT MCS-044 MINI

Requ
est
Atten
d

#Stu_i d

STUDENT Buy
Book_na
# Book
me
C _categ _id
Book
# C _id _type

Book
Book
C _amt Report C _type _Class
Book
Card _amt Dress
Pay
C
C _from _date Fee_am
t
D_Size

Fee
C _to # Fee
Mana _id
ge
Tea_na Fee

a le
me _dtls
# Tea
_id Tea
_type Fee
_type
Tea
_gen
Teacher

Tea
_add
Cla
# Cla _id
Tea _d Tea _pol_id
oj _dob

Class
Provi
de

Cla_pda Cla
te _empid
Tak D_amt
e Pro
vid
Cla
Sal_am _validty

Emp_id t

Sal_da Exam_i # Exam

Salary d _Name
te
Tickets Exam
Sal_bonu Tickets Exam
s
_type
#Sal_id
Exam
IGNOU Page 15 _in
oExfam30

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

_Sub date
MCA-4

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

E-SCHOOL MANAGEMENT SYSTEM MCS-044 MINI

PROJECT

DATABASE TABLES

Table Name:-

1. View Attendance
2. Report Cards Section
3. Online Fee details
4. School time-table
5. Assignments
6. Homework
7. Tutorials
8. Exam Schedule
9. Student Profile
10. Teachers Profile
11. School Bus details
12. Holidays List
13. Buy books online
14. Discussion Board
15. Internal Messaging System
16. School Dress Kits
17. Login

IGNOU Page 16 of 30
MCA-4

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

1. ATTENDANCE

FIELD_NAME DATA_TYPE DESCRIPTION

Student_id Int It show Student id
Student_name Varchar It show Student Name
Student _Class Varchar It show Student Class
S_Teacher_Name Varchar It show
Student
Teacher Name
Student_Class_Time Varchar Class Time

2. REPORT-CARDS

FIELD_NAME DATA_TYPE DESCRIPTION

Card_id Int It show Student id
Card _name Varchar It store Student name
Card _type Varchar It represent Student
type
Student_dob Int It store Student date
of birth
Card _gender Varchar It show employ
gender
Card _dop Date/time It show Student date
Of Pass out
Student_add Varchar It store the Student
add

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

3.FEE

FIELD_NAME DATA_TYPE DESCRIPTION

Fee_id Int It show Fee id
Fee_amount currency It show Fee amount of
Student
Fee_date Date/time It show date of
getting salary
Fee_Stu_id Int Store the Student id
Fee_Off Int It store the Fees
Offers

4.TIME-TABLE

FIELD_NAME DATA_TYPE DESCRIPTION

TT_id Int It show Time Table id
TT _Name Varchar It show Time Table
Name
TT_type Varchar It show the type Time
Table
TT_Discripation Varchar It show the
Discripation of Time
Table

5. ASSIGNMENT

FIELD_NAME DATA_TYPE DESCRIPTION

Assignment_id Int It show Assignment
id
Assignment _Name Int It show Assignment
Name
Assignment _type Varchar It represent the type
of Assignment

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

Assignment _date Date/time It store the date of

Assignment
Assignment _to Varchar It show the
Assignment Submit
To
Assignment Varchar It show the
_Last_Date Assignment Last Date
Assignment _category Varchar It represent the
category of
Assignment

6. HOMEWORK

FIELD_NAME DATA_TYPE DESCRIPTION

HW_Id Int It show Home Work
Id
HW_type Varchar It show the type of
Home Work
HW_date Date/time It show Home Work
date&time

7.TUTORIALS

FIELD_NAME DATA_TYPE DESCRIPTION

S_id Int Store the Student id
S_p_id Int Store the project id
Tut_Name Varchar Store the Tutorial id
Tut_Id Int Store the Tutorial Id

8. EXAM-SCHEDULE

FIELD_NAME DATA_TYPE DESCRIPTION

Exam_id Int It show Exam id
Exam _Center Varchar It represent the Exam
Center
Exam _in date Date/time It show the date of
Exam Start
Exam _Others Varchar It show order

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

9. STUDENT

FIELD_NAME DATA_TYPE DESCRIPTION

Student_id Int It show Student id
Student_name Varchar It show Student Name
Student _Addrerss Varchar It show Student
Address
Student _Class Varchar It show Student Class
Student_Phone Varchar It show Contact
Number
S_Father_Name Varchar It show Student Father
Name
Student_Other Varchar Other Remark

FIELD_NAME DATA_TYPE DESCRIPTION

Teacher_id Int
10.TEACHER It show Teacher id
Teacher_name Varchar It show Teacher Name
Teacher _Addrerss Varchar It show
Teacher
Address
Teacher _Class Varchar It show Teacher Class
Teacher_Phone Varchar It show
Contact
Number

11. BUS

FIELD_NAME DATA_TYPE DESCRIPTION

Bus_id Int It show our Bus id
Bus _Name Int It present Bus Name
S_ Bus _issuing_date Date/time It show Bus issue date
S_ Bus _valid Date/time It present the Bus
validity
S_Teacher_id Int It show the Teacher id

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

12. HOLIDAYS

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

FIELD_NAME DATA_TYPE DESCRIPTION

Holiday_id Int It show the Holiday id
Holiday_Name Varchar It show the Holiday
Name
Holiday_Date Date/time It show the Holiday
Times
Others Varchar It show the other
Remarks

13.BOOK

FIELD_NAME DATA_TYPE DESCRIPTION

Book_id Int It show Book id
Book _name Varchar It show the Book
name
Book _Type Varchar It show Book Info
Book_Class Varchar It show Book Class
Book _Cost Varchar It show Book Cost

14.BOARD
FIELD_NAME DATA_TYPE DESCRIPTION
Notic_id Int It show the Notic
Notic _name Varchar It show Notic name
Notic _info Varchar show Notic
Information

15. MASSAGES

FIELD_NAME DATA_TYPE DESCRIPTION

Massage_id Int It show the Massage

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

Massage _name Varchar It show Massage

name
Massage _Details Varchar It show Massage
Massage_date Date/time It show the sending
date
16. DRESS

FIELD_NAME DATA_TYPE DESCRIPTION

Dress_id Int It show the Dress
Dress_cust_name Varchar It show customer
name
Dress_reciving_name Varchar It show Dress receiver
name
Dress_day Date/time It show the Bear Day
Dress_name Varchar It show the Dress
name

17.LOGIN
FIELD_NAME DATA_TYPE DESCRIPTION
User_id Int It show User Id
User_Pass Varchar It show User
Password

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

PROCESS LOGIC

Notices:-

School Notices can be posted by the admin, which can be for whole school or

class specific, visible only to students or class teachers of that specific class.It

acts like he school-notice-board.

Sale Module:-

This module contains functions related to the sale of the Book, Dress, etc.

Attendance:-

Students can view their attendance; parents can also watch their children’s

attendance from home. Class-teachers / data-entry operators can add-

students (class-wise) attendance.While taking the attendance the students

leave application is visible if any leave is filed online by the student.

Assignments:-

Assignments can be created with the help of a rich-text editor tool or an

assignment file can be uploaded having the assignment. Students can view

the list of available assignments for them & can view or download the

ssignments.

Report-Cards:-

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

This section shows all the results/marks/performance of students. Students

can view their marks/report-card in this section. Admin/Parents can watch

students/Childs performance.

Exam schedules:-

Exam schedules can be posted on the system so that students/parents &

teachers can view all the list of exams/tests scheduled. These can be created

online on the system or the list can be uploaded to the server.

Message Board:-

A full-featured message-board/forum is there in the system which enables

students, teachers, principal & parents to create an online community &

discuss their views, thoughts & ideas on various topics. These forums are

monitored by the admin. An abusive language filter is installed which restricts

the use of abusive content on the forums.

Fees:-

School fees details will be available in this section. Fees can be easily paid

online using credit/debit cards or e-checks through a secured & encrypted

payment gateway.

Students/Teachers/Principal Profiles:

Students, teachers & principal can view & update their profiles, photgraphs,

contact numbers, password; so that most current informations are available

in school database.

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

Security Module:-

This module handles the security features of software. It checks for

unauthorized login/accesses, unauthorized deletion/editing of records,

defining the access permissions to users, etc.

Reporting Module:-

This module handles the process of all types of report generation for e.g.

Result Cards generation, list of policies, list of tickets etc. These reports are

very beneficial for both management and the Student. Results are generated

for the Student.

Validation :-

When user wants to write any non-alphabetic character in any textbox in

which only Name is allowed a messagebox appears which tell the user that

only alphabetic value will be accepted.

The validation on date data type has been specified to be of the format

DD/MM/YY. Any other format is unacceptable.

The field specified with number as then their data-type will not accept

character.

Automatically generation of the Student, and Enroll No .

No duplicate ID number is allowed.

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

There is a facility of auto fill comboboxes which means only some character is

need to type to get the existing record.

Re-entry of any customer and company is not allowed.

The forms which are not fulfilled or not accepted and highlighted the invalid

entry area.

All function and menu can be accessed without the help of mouse.

Thus, we have tried to make this system very secured and reliable by putting

a number of validation checks in it. The future versions of this software are

supposed to have more extended validations checks based on varied client

needs.

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

TYPES OF REPORT GENERATION

 List of the all Student.

 List of the available services.

 Details of Fee.

 Displays the Free details.

 Provide Reports of all types of Expenses.

 Details of Teacher and their Salaries.

 Generate Receipt of the sales.

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

LIMITATIONS

Time available for the project work approximately three months. Normally within such a

short span of time, many of facilities couldn’t be included in this software. The

limitations of the software are: -

I. This system should not be taken as a tool to assist the Student in selection of
services. In other words it is not a type of Expert System.

II. As its title indicates, the project aims at automating the service aspects of the E-
School. It is only meant for out Student Teaching.

III. It also does not cover all services provided by the E-School Management.

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

FUTURE SCOPE OF THE PROJECT

If we consider E-School Management, it seems to be an integration of many functions. As

we see that there is a lot of work performed by E-School Management that maintain a

relationship and provide helps to other Student.

This software, in its current scope, basically enables to provide a records of the

available facilities in E-School Management. Its not cover all the services provided by the

E-School Management. So, in future this software will cover the other advanced services

of E-School Management.

 In future this software can be used for the e-Exam, online Exam, etc.

 Video conferencing from the Experts, etc.

 Chatting facilities, etc.

Downloaded by Trst Trst (codeasitis@gmail.com)

 lOMoARcPSD|29792868

BIBLIOGRAPHY

The books will be referred during the development of this project are as follows:

 PHP and MySQL Web Development (4th Edition) by Luke Welling

 PHP 6 and MySQL 5 for Dynamic Web Sites: Visual by Larry Ullman

 MySQL Cookbook by Paul DuBois

 E-BOOKS Related to PHP and Sql Server.

 Contents from websites.

Downloaded by Trst Trst (codeasitis@gmail.com)