PROJECT REPORT ON

School
Management
System
SUBMITTED AS THE PARTIAL FULFILLMENT OF DEGREE OF
BACHELOR OF COMPUTER APPLICATION

By

Amarat Bharvad

Exam No.:

Under the Guidance of

Mrs. Priya Patel

ANAND COMMERCE COLLEGE, ANAND

SARDAR PATEL UNIVERSITY VALLABH
VIDYANAGAR

YEAR: 2023-2024
 Certificate
This is to certify that Amarat Raghubhai Bharvad of
T.Y.B.C.A.(SEMV)Exam No.: _ _ Roll No.: _07_, of
Anand Commerce College, Anand has satisfactorily
completed his project work during year 2023-24 as
per the university curriculum and here with, it is to
be submitted to S.P. University, Vallabh
Vidhayanagar, for his/her final Examination.

Principal
 PREFACE

It gives me great pleasure in placing in the handling of my esteemed faculties this

individual report, which, I believe, will go through the documentation of the project work done by
me.

The objective of this report is to provide both a conceptual understanding of the system as
well as working guidelines.

The need for software development today is a competence in G.U.I based front-end tools
as far as the database programming is concerned. A typical scenario today involves an application
consisting of a visual front-end for presenting data and reporting options to the enterprise user
and a connection to a database for piping data to the controls such as textboxes, tables etc.

As a student of BCA when I acquire all the theoretical knowledge, it is both necessary
and advisable to acquaint the real situation through. Well-planned project in relevant fields. The
project is important as the student not only learns to develop efficient real world application but
also gets a chance of self- development.

I have done a project School Management System fulfillment of Bachelor of

Computer Applications (BCA) program. Now a day, Internet is one of the best mediums for
providing information to the students or Employees of any Educational Institutes or
Organizations. There are Lots of manual efforts and processes that go into the keeping track on
the user while accessing Internet, which consume a lot of time.

School Management System efforts and hence brings significant gains in time. Aimed for
providing the reader with easier and in knowledge of report contain the literature of almost all the
things, which I have gone through from the point of view of any system development life cycle.
An effort has been made of exhaustively deal with every part of the system developed.
 ACKNOWLEDGEMENT

It gives me great pleasure and gratification to present my Project School

Management System which has been completed in Third Year B.C.A.

On this stage I would like to thank all people who were behind and along with me,
and who constantly guided me during the time of difficulties I faced while developing this
project.

First and fore most I would like to thank the Teacher of Anand Commerce college to
whom I am highly indebted towards their invaluable contribution in making my project
presentable and without them this project would have not been completed.

I would like to give very special thanks to my Project Guide, Mrs. Priya Patel for
helping me to develop the Project. He is always ready with his invaluable Suggestions
through his complete Perseverance.

Next, I would acknowledge staff members and Teachers of Anand Commerce

College who have contributed a help with their active suggestions to the development of my
project, which provided to be of great help.

Lastly, I would express my whole hearted appreciation to the College Name family
for the continuous support, encouragement and invaluable tips.

[Amarat Bharvad]
 PROJECT INDEX

Sr. Description of Topic Page

No. No.
1 Introduction 1
2 Scope Of Work 4
3 An Existing System 6
4 Need of proposed System 8
5 Feasibility Study 10
6 System Features 14
7 Hardware and Software Requirement 17
8 Data Flow Diagram (DFD) 20
9 Database Layout/File Layout 22
10 Design Of Input-Output Screens 24
1. Introduction
 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,and
the School Staff.

 School Management System consists of tasked such as registering Students,

record keeping controlling absents, producing report cards,preparing time-table
and producing different reports for teachers and parents.
2.Scope Of Work
 2.Scope Of Work

 In School Information Through this service one can access the complete
information about the school campus such as courses available, admission
procedure, placements, school events, achievements etc.

 This project deals with the various functioning in School management process.

 admission: Admission table contain student details like name, dob address etc.

 admin: Admin table contain password and user name field.

3.An Existing System
 3.An Existing System

 In the existing system all the works are done manually. Students have to fill
up admission form on paper and all the records are maintained on paper file.

 Let us take an example Initially schools appoint many employees to

maintain the record of the student, teachers, other staff, employees' salaries,
and student's fees.

• It was limited to a single system.

• It was less user-friendly.
• It requires more no of employees need to work.
• It was time consuming process.
4.Need of proposed System
 4.Need of proposed 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 are added in the database and so students can
also view the ,arks whenever they want.

 Our Proposed System has several Advantages:

 User Friendly Interface.

 Fast Access to Database.
 Less Error.
 More Storage Capacity.
 Search Facility.
 Look and Feel Environment.
5.Feasibility Study
 5.Feasibility Study

 Scheduling Feasibility:

 A very significant part of feasibility study is scheduling Feasibility. It also plays an

important roles to complete the project in its schedule time.

 Legal Feasibility:

 Legal feasibility study is used to conclude whether the proposed plan or system is
conflicts with the national or international legal requirements. Protection Acts simply
use to decide the any violation requirements. It is also a planned method.

 Technical Feasibility:

 Technical feasibility mainly associated with the technologically evaluates the project.
In this subject area generally a group of engineers or technical expert study the whole
projects and technical aspects. This study facilities said organizations to proper
assess. The industrial possessions may assemble capability. Based on the results it
decides whether the technical team can convert the idea into real.

 Operational Feasibility:

 Operational Feasibility may employ the responsibility to examine and decide whether
the proposed methods fulfill all kind of business requirements. It actions forecast all
possible schemes to recognized and resolves troubles. These studies may also
examine and verify how the project planned guarantee the method development is
feasible or not.

 Economic Feasibility:

 Economic Feasibility study related with price, and all kind of expanditure with the
scheme before the project start. This study also improves project reliability. It is also
helpful for the decision-makers to decide the planned scheme processed later or now,
depending financial condition of the organization. This evaluation process also
studies the price benefits of the proposed scheme.
6. System Features
 6. System Features

 This university management system is a must-have for every educational

institute that wants to scale higher heights and want to be well known for
academic excellence.

 But with the inception of college ERP software, these have been greatly
reduced and it has made provision for better academic performance with its
mind-blowing features.

1. Efficient Accounting Mechanism.

2. Ability to Manage Staffs Effectively.
3. Accurate Entrance Test and Merit Lists.
4. Timetable Generation.

5. General Library Management.

7.Hardware and
Software Requirement
 7.Hardware and Software Requirement

Requirements Specification
Processor Intel Core i3 or higher

RAM 8 GB

HDD 1 TB

Graphics Minimum 2 GB

Processor 800 MHz

Speed

• Front End: Visual Studio

• Back End: Sql Server
• Technology: .NET FRAMEWORK 5 or HIGHER
• Performing Language:VB.NET
8. Data Flow Diagram (DFD)

8. Data Flow Diagram (DFD)

Context level DFD :

Student info Student info

School management
User system StudentDB

response response

0th level DFD:

request Check For Login

LoginDBin
1.0 n_in_DBs
user login f_Previou
response Reply s_Exam
 Add Course Insert Data
Student DB
2.0
Student Master
1st level DFD : Reply
response

Add Teachers Insert Data

Teacher
3.0 DB
Add Teachers
response Reply

request info
Login DB
Add student 1.1 Fees status
User Fees DB
registration
4.0
response Fees response
Payment done conformation

Username, password data

1.2
View Report Send Data
Log in Exam DB
5.0
response Exam Success or not

Display Data Reply

Request to update info with

New data
new data
1.3
Edit account
response response
9. Database Layout/File
Layout
 9. Database Layout/File Layout

1.Login_DB:
Field Name Data Type Constraints Description
User_ID Varchar(10) Primary Key User ID
First_name varchar(10) Not Null First Name
Password varchar(10) Not Null Password
Last_name varchar(10) Not Null Last Name

2.Student_DB:
Field Name Data Type Constraints Description
F_Name Varchar(50) Not Null First Name
Address Varchar(50) Not Null Address
Email Varchar(50) Not Null Email
DOB nVarchar(50) Not Null DOB
Gender Varchar(15) Not Null Gender
Age Numeric(18,0) Not Null Age
Phone_Number Numeric(18,0) Not Null Phone Number
Category Varchar(25) Not Null Category
Stream Varchar(25) Not Null Stream
Class Numeric(18,0) Not Null Class

3.Teachers_ DB:
Field Name Data Type Constraints Description
Staff_id nrchar(10) Not Null Staff Id
F_name Varchar(25) Not Null Full Name
Gender Varchar(10) Not Null Gender
Age Numeric(18,0) Not Null Age
Phone_Number Numeric(18,0) Not Null Email Id
Email_Id varchar(25) Not Null Phone Number
Address Varchar(50) Not Null Address
4.Fees_ DB:
Field Name Data Type Constraints Description
Full_Name Varchar(50) Not Null Full Name
Address Varchar(50) Not Null Address
Phone_No Numeric(18,0) Not Null Phone Number
Class Numeric(18,0) Not Null Class
Date Datetime Not Null Date
Roll_No Numeric(18,0) Not Null Roll Number
Category Varchar(15) Not Null Category
Stream Varchar(15) Not Null Stream
Fees Numeric(18,0) Not Null Fees

5.Exam DB:
Field Name Data Type Constraints Description
F_Name Varchar(50) Not Null First Name
Roll_No Numeric(18,0) Not Null Roll Number
Class Numeric(18,0) Not Null Class
Previous_Result_Status Varchar(20) Not Null Previous Result
Status
Percentage_Of_Previous_Exa Numeric(18,0) Not Null Percentage Of
m Previous Exam