school managment
TRANSCRIPT
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 1/22
A PROJECT REPORT ON
“SCHOOL MANAGEMENT SYSTEM”
PREPARED BY
KATHIRIYA BHAVIK JAIN SAKET
BATCH: H2 BATCH: H2
ROLL NO: 34 ROLL NO:29
GUIDED BY
MS. KRUPA PATEL
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 2/22
DHARMSINH DESAI UNIVERSITYDEPARTMENT OF INFORMATION TECHNOLOGY
CERTIFICATE
This is to certify that MR.KATHIRIYA BHAVIK and MR.JAIN SAKET Of
Department of Information technology, “Dharmsinh Desai University” as a part
of his Bachelor of Engineering Vth
semester has done his project work on
“SCHOOL MANAGEMENT SYSTEM”.
MS. Krupa Patel Prof. R.S.chajjed
(Internal Guide) (Head.IT Dept)
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 3/22
ACKNOWLEDGEMENT
On completion of project we would like to express our sincere thanks to all those who
have guide, advised, inspired and supported during our project work.
Every work that one completes successfully stands on the constants encouragement,
good will and support of the people around. We, hereby, avail this opportunity to
express our heartfelt gratitude to a number of people who extended their valuable
time, full support and cooperation in developing this project.
At the outset, We express our sincere thanks to MS. Krupa Patel who gave us a
unique and excellent opportunity to work in this esteemed organization.Without theirhelp this project would never have been realized in its entity and our special thanks to
all of them for their kind support and helpful hints during the entire project.
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 4/22
INDEX
SR.NO CONTENTS
PART-1 INTRODUCTION TO PROJECT
• About the System
PART-2 Detail Description of System
• Existing System
• Proposed System
PART- 3 SYSTEM DOCUMENTATION
• Feasibility Study
• Entity Relationship Diagram
• Context Diagram
• Data Flow Diagram
• Data Dictionary
PART-4 SCOPE AND LIMITATION
PART-5 FUTURE EXPANSION
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 5/22
ABOUT THE SYSTEM
.
• The system name is School Management System.
• This system was proposed and designed to overcome the manual work. The
system is of School Management System, so in this system there is no chance of
create paperwork.
• The system is made completely automated and all the work is done computerized.In this system there are more features than existing system.
• In this system we have add the work which are not done manually also so this is
one of the best advantages of this system.
• They have generate the fee receipt so, the work is half done as they work
manually.
• Now with the help of this system they have found the information about all
student of any class.
• Now with the help of this system administrator can easily find the staff
information. All requirements for the school are available in this project.
• Now with the help of this project administrator can easily find the all expenses for
the academic year.
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 6/22
Detail Description of The System
EXISTING SYSTEM
Manual:
A School has no used any type of system. They are work manual in the school.
As mentioned above we have provided solutions to lots of manual works carried out.
Here record keeping and information keeping was done manually by Administrator.
Only administrator with unlimited information which led to miscommunication and
misinterpretation leading to either duplicity of data or leading to misinformation.
PROPOSED SYSTEM
Manual:
Manual system was lethargic and containing errors and loopholes which were
missed out by management leading to administrative complications. The reports andinformation were not promptly available for management decision, thus system was
planned, design with tracking of each and every critical data in all document, forms
etc and providing spontaneous report generation for better management decision
making.
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 7/22
Advantages of Proposed System
Administrator can easily fill data in the form and keeping the record of studentadmission, student information, school expenses, staff information, easily generate fee
receipt, easily make the result. Administrator can easily fetch the data from the record.
The work flow is so well defined easy to understand by user and helps in
generate report at mere click which helps in managerial and administrative decision
making.
Limitation of Proposed System
Till the system does not go in the school we cannot predict future
E.g.
• Only Administrator and Teachers are login entry and working the system.
We have take precautions validations and tested used the application and work
on in desktop which is working successfully till now.
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 8/22
Feasibility study
A feasibility study is undertaken to determine the possibility or probability of
either improving the existing system or developing a completely new system. It helps
to obtain an overview of the problem and to get rough assessment of whether feasible
solution exists. This is essential to avoid committing large resources to a project and
then repent on it later.
Need for feasibility study
• Answer the question whether any system is to be installed or not.
• Determine the potential of the existing system.• To improve the existing system.
• Know what should be embedded in the new system.
• Define the problem and objective involved in a project.
• Avoid costly repair at a later stage when the system is implemented.
• Avoid crash implemented of a new system.
• Avoid the ‘Hardware approach i.e. getting a computer first and then deciding
how to use it.
There are three types of feasibility study.
(1) Technical feasibility
:
• Adequacy of available technology.
• Adequacy of Hardware.
• Available of computer.
• Operating time and support facilities, etc.
Technical feasibility determines whether the technology needed for theproposed to system is available and how it can be integrated within the “MRM
System”, “Training Management System” & “PME-Project Planning and Estimation”
and Technical Estimation must also assess whether the existing system can be
upgraded to use the new technology and whether the “MRM System”, “Training
Management System” & “PME-Project Planning and Estimation” have the expertise
to use it. The technical feasibility in the proposed system deals with the technology
used in the system. It deals with the hardware and software used in the system
whether they are of latest technology or not. It happens that after a system is prepared
a new technology arises and the user wants the system based on that technology. Thus
it is important to check the system to be feasible.
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 9/22
(2) Economic feasibility:
Economic feasibility looks at the financial aspects of the project. Economic
feasibility concerns with the returns from the Expenses Form. It determines whether itis worthwhile to invest money in the proposed system. It is not worthwhile spending a
lot of money on a project for no returns. The advocate plans to acquire the necessary
hardware and software require for the system and there is no hindrance whether
economical or otherwise towards its purchase. A brief description of hardware and
software required in the system is given later in the report.
(3) Operational feasibility of the project
:
Operational feasibility covers two aspects one is the technical performance aspect
and other is the acceptance within the “test Engine”& Project Monitoring and control
system. Operational feasibility determines how the proposed system will fit in the
current operational.
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 10/22
E-R Diagram
Book Id
Book
Auth Edition
Issue date
Qty
Giving
student Data
Add No
Add Date
Per Priz
Stud Nam
JR.NoStud_Cit
Std
BirthDat
Pincode
PH No
Category
Cast
Generate
receipt
Receip
Stud-
Gr.no
Paid Fee
Staff Master
Staff Id
Join_yrName
Add
Ph.No
salar
Edu
Gender
Subject
Master
StdSub Id
Result Master
Gr.no
Exam
Sub Name
Obt Mar
Out of
Expenses
Master
Sr.No Detail
ExpDat
Total
Ex T e
Library
Master
Admission
Master
Fee Receipt
Sub
detail
Result of
sub ect
Expens
e details
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 11/22
Data Dictionary
Table Name: Admission Master
Primary Key: Add_No
Field Name Data Type Size Description
Add_no Number 5 Admission NumberAdd_Date Date/Time - Admission Date
GR_No Number 10 General Register Number
Std Number 2 Standard
Stud_Name Varchar2 35 Student Name
Stud_Add Varchar2 50 Student Address
Stud_city Varchar2 15 Student city
Stud_ph_no Number 15 Student Phone No
Stud_Birth_Date Date/Time - Student Birth Date
Stud_caste Varchar 25 Student Caste
Table Name: Expenses
Primary Key: Sr.No
Field Name Data Type Size DescriptionSr.No Auto Number Long Integer Serial No
Exp_Date Date/time - Expense Date
Exp_Type Text 20 Expense_Type
Total Number 7 Total
Detail Text 50 Remarks or Description
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 12/22
Table Name: Subject Master
Primary Key: Sub_Id
Field Name Data Type Size Description
Sub_Id Auto Number Long Integer Subject
Identification
Std Number 2 Standard
Sub_Name Varchar2 15 Subject Name
Table Name: Fee Receipt
Primary Key: Receipt no.
Field Name Data Type Size Description
Receipt No Number 5 Fee Receipt Number
Receipt Date Date/Time - Fee Receipt Date
Stud_Jr_No Varchar2 5 Student General Register No.
Stud_std Number 2 Student Standard
Paid Fee Number 5 Fee paid for By the Student
Receiver Name Varchar 40 Receiver Name
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 13/22
Table Name: Library Master Primary Key: Book ID
Field Name Data Type Size Description
Book_Id Varchar2 5 Book Id Number
Book_Name Varchar2 25 Book Name
Book_Auth Varchar 25 Book Author
Book_Edition Number 2 Book edition
Book_qty Number 5 Book quantityIssue_date date 5 Date of issue
Table Name: Staff Master
Primary Key: None
Field Name Data Type Size Description
Staff_ID Text 5 Staff Identification
Join_Date Date/Time - Staff Joining Date
Name Varchar 40 Staff NameAdd Varchar2 50 Staff Address
PH.No Number 15 Staff Phno
Salary Number 5 Staff Salary
Stream Varchar 15 Staff Stream
Edu Varchar 15 Staff Education
Gender Varchar 6 Gender
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 14/22
Table Name: Result Master
Primary Key: None
Field Name Data Type Size Description
GR_No Number 5 General Register no.
Held_ Exam Varchar 15 Exam Type
Std Number 2 Student standard
Sub_Name Varchar2 15 Subject Name
Obt_Mark Number 2 Obtain Mark
Out_Mark Number 3 Out of Mark
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 15/22
QUERIES
CREATE TABLES
CREATE TABLE "ADMISSIONMASTER10"
{ "ADD_NO" VARCHAR2(4000),
"GR_NO" VARCHAR2(4000),"STUD_NAME" VARCHAR2(4000),
"STUD_CITY" VARCHAR2(4000),
"STUD_PH_NO" NUMBER,
CONSTRAINT "ADMISSIONMASTER10_PK" PRIMARY KEY
("ADD_NO") ENABLE
}
CREATE TABLE "SUBJECT_MASTER"
{ "SUB_ID" VARCHAR2(4000),
"STD" VARCHAR2(4000),
"SUB_NAME" VARCHAR2(4000),
CONSTRAINT "SUBJECT_MASTER_PK" PRIMARY KEY
("SUB_ID") ENABLE
}
CREATE TABLE "LIBRARY_MASTER"
{ "BOOK_ID" VARCHAR2(4000),
"BOOK_NAME" VARCHAR2(4000),
"BOOK_EDI" VARCHAR2(4000),CONSTRAINT "LIBRARY_MASTER_PK" PRIMARY KEY
("BOOK_ID") ENABLE
}
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 16/22
INSERT DATA
INSERT INTO ADMISSIONMASTER VALUES(‘A101’,’G101’,’JAIN
SAKET’,’AHMEDABAD’,’9727716351’);
INSERT INTO ADMISSIONMASTER
VALUES(‘A102’,’G102’,’THAKKAR HARSH’,’NADIAD’,’9824387384’);
INSERT INTO SUBJECT_MASTER VALUES(‘S101’,’12’,’DAA’);
INSERT INTO LIBRARY_MASTER VALUES(‘B101’,’ANALYSIS OF
ALGO’,’2ND’);
OTHER QUERIES
FIND OUT NAMES OF ALL STUDENTS HAVING ‘a’ AS
SECOND LETTER IN THEIR NAMES. SELECT STUD_NAME FROM ADMISSIONMASTER WHERE
STUD_NAME=’_a%’;
DISPLAY RESULT DETAIL ACCORDING TO THEIR GR.NO
SELECT * FROM ADMISSIONMASTER A CROSS JOIN
RESULTMASTER R WHERE A.GR_NO=R.GR_NO;
DISPLAY INFORMATION WITH STAFF NAME WHO HASJOINED BEFORE 10 OF ANY MONTH
SELECT * FROM STAFF_MASTER WHERE (JOIN_DATE.”d”)<10;
DISPLAY ALL THE BOOK NAMES WRITTEN BY AUTHOR
GAONKAR.
SELECT BOOK_NAME FROM LIBRARY_MASTER WHERE
BOOK_AUTH=”GAONKAR”;
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 17/22
VIEW
CREATE A VIEW WHICH SHOWS THE DETAIL OF
SUBJECT_MASTER WITH SUBJECT NAME AND STD.
CREATE VIEW ADMISSIONMASTER101
SELECT SUB_NAME,STD FROM ADMISSIONMASTER;
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 18/22
PROCEDURE
CREATE A PROCEDURE TO IMPLEMENT LIBRARY
BOOK ISSUE SCHEME.
CREATE OR REPLACE PROCEDURE DATE_ISSUE( BNO IN VARCHAR2,T_M
IN VARCHAR2)
IS
ID VARCHAR2(5);TM VARCHAR2(10);
A NUMBER(10);
BEGIN
SELECT BOOK_ID INTO ID FROM LIIBRARY_MASTER1 WHERE
BOOK_ID=BNO;
SELECT ISSUE_DATE INTO TM FROM LIBRARY_MASTER1 WHERE
BOOK_ID=BNO;
IF TM >=T_M THEN
DBMS_OUTPUT.PUT_LINE(‘YOUR BOOK CAN BE RENEWED ‘);
ELSE
DBMS_OUTPUT.PUT_LINE(‘YOUR BOOK CANNOT BE RENEWED.PAYTHE FINE!!!’);
END IF;
END;
DECLARE
BEGIN
DATE_ISSUE(’B101’,’48’);
END;
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 19/22
TRIGGER
IMPLEMENT A TRIGGER TO INCREMENT SALARY
OF TEACHERS HAVING EXPERIENCE MORE THAN
1 YEAR BY 5%.
CREATE OR REPLACE TRIGGER PRO_DISC
AFTER INSERT
ON STAFF FOR EACH ROW
DECLARE INCREMENT NUMBER(10);
AC_AMT1 NUMBER(20);
AC_AMT2 NUMBER(20);
CURRENT NUMBER(20);
JOIN NUMBER(10);
BEGINCURRENT:=10;
INCREMENT:=5;
AC_AMT1:=:NEW.SALARY*5/100;
AC_AMT2:=:NEW.SALARY+AC_AMT1;
INSERT INTO STAFF_MASTER
VALUES
(:NEW.STAFF_ID,:NEW.JOIN_YR,:NEW.NAME,AC_AMT2);
END;
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 20/22
SCOPE AND LIMITATION
Scopes of Proposed System
School Management System is based on data fed by Administrator for variousdatabase, record keeping and report generating.
This keeps track of all linked data with do duplicity and reductioning human
error. The work flow is so well defined easy to understand by user and helps in
generate report at mere click which helps in managerial and administrative decision
making
Limitation of Proposed System
Till the system does not go in the school we cannot predict future
E.g.
• Only Administrator and Teachers are login entry and working the system.
We have take precautions validations and tested used the application and
work on in desktop which is working successfully till now.
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 21/22
FUTURE EXPANSION
Future needs is always arise in every system, because at the time of analysis,
we study existing system and thinking of proposing system which should contain all
the features which make system user friendly but during whole SDLC phase many
changes may arise in the system which should be develop for the better use of end-
user and thus those new features, new needs are define as future enhancements.
School Management System so many changes can be done in the system, and future
works are always welcome in case of School Management System.
User can edit an Attendance form or make a form of record keeping of sports
item for the Academic Year.
User can change in result form and make proper use of Result Form.
5/11/2018 School Managment - slidepdf.com
http://slidepdf.com/reader/full/school-managment 22/22