Synopsis
Contents
1. Title of the project
2. Introduction and objective of the project
3. Analysis
a. Data Flow Diagram
b. Entity-Relationship Diagram
4. A complete structure which include-
a. Number of module & their description
b. Data structure
c. Process logic diagram
d. Testing process
e. Report generation
5. Tool/platform/hardware and software requirement specification.
6. Future scope and further enhancement of the project.
1- TITLE OF THE PROJECT
Synopsis
2- Introduction and objective of project
Synopsis
Now a day life become very fast ,therefore every person wants to solve our
work quickly. This era is the electronic era, everything has become
computerized . Manual work has subsided and computer based format has
come up.
Day to day every system becomes computerized Therefore, in
order to, I thought to develop such type of software which could be able
to computerized the School Management System.
In this application we manage system for
Registration , Fee , staff , Library , Enquiry and Generate Report.
Problem with the current system
Time consuming
Delay in service
Difficulty in maintaining large records
3- Analysis
Synopsis
In order to complete the project, project should begin with analysis in
which the requirements and clear list of goal.
ANALYSIS
DESIGN CODING TESTING DOCUMENTATION
DFD :
Graphical description of system’s data and how the processes
transform the data is known as Data Flow Diagram(DFD).
To construct DFD ,we use :
Arrows,
Circles
Open – ended boxes
Squares
Synopsis
Work breakdown structure for
“SHRI KRISHNA inter college management system”
“SHRI KRISHNA
Inter College
Management system
“
Analysis Design Coding Testing Implementation
Analysis Design Coding Testing Implementation
Analysis Design Coding Testing Implementation
Synopsis
DATA FLOW DIAGRAM
DFD ON “ENQUIRY”-
Student
Fee details
Report Enquiry Students
generated counter
Courses
Database
DFD ON “REGISTRATION”-
Student
Report Registratio Registration form
generated n counter
Database
DFD ON “STUDENT DETAILS”-
Student
Fee details
Report Student Courses
generated details
Attendance
Student
database
Synopsis
DFD FOR “FEES DETAILS”-
Student
Additional fees
Report Fees Current fees
generated details
Dues fees
Fees database
DFD ON “LIBRARY DETAILS”-
Staff
Book
Report Library Issue book
generated details
Return book
Library
database
DFD ON “STAFF DETAILS”-
Staff
Class details
Report Staff Attendance details
generated details
Salary details
Staff
database
Synopsis
E-R-DIAGRAM:
The E-R-Diagram was originally proposed by Peter for the design of the
relation data base system. components is identified for the ERD ; data
objects , attributes , relationships and various types of indicators .
The primary purpose of the E-R-D is to The E-R Diagram was
originally proposed by Peter Chen for the design of Relational
Database System . The E-R model is extremely useful in mapping
the meaning and interactions of real world enterprise .
The primary purpose of the E-R-Diagram is to represent data object and their
relation ship.
Table (Entity):
Student
Enquiry
Registration
Fee submission
Staff
Library
Relationship:
Relationship Between Student And Enquiry
Synopsis
Student M Query M Enquiry
Relationship between Student and Registration
S-
S-ID
Amoun M Rege
S-Name 1 SchoolName
t
Student
d S-ID Program
T-ID
Program
fee Submit
Student
Relationship between Student andby
Fee submission
take Ha Study Class Quer
M 1Rege
Student s y
in the d
T-ID
T-Name E-
Name
Relationship between Student and Progress Report
Teacher/Staff Employe School Give Enquiry
d detai
ls
1 Empl M Teacher Addres
Joining School Address Course
DOB oyed Phone s
Date
No Phone
No
Salary Book
s
Relationship between Student and Library
Issue
S-ID
M 1 Program
Issue/
Student Submit Library
Books
Issue
S- Date
Name
B-Name
B-ID
Synopsis
M M
M M M M
M 1 1 M
M 1 1 M
Library
4-. A COMPLETE STRUCTURE WHICH INCLUDES
Synopsis
Number of modules and their description:
a) Students:
With the help of this module we can view, delete and update the
Record of students.
b) fees:
With the help of this module we can submit, view, and update fee
Status.
c) Library:
With the help of this module we can issue and submit books.
d) Staff:
With the help of this module we can entry the new staff’s name and
Update the current staff records.
e) Enquiry:
With the help of this module we can retrieve the information about
Enquiry.
f) registration:
With the help of this module we can retrieve the information about
Registration..
DATA STRUCTURE
Table –STUDENT
Synopsis
Name of field Data type Data size constraints
S_id integer 15 Primary key
S_name string 30 Not null
S_Fname string 30 Not null
S_Mname string 30 Not null
Sex string 15 Not null
S_DOB Date Not null
S_Address string 50 Not null
S_Ph integer 10 Not null
Table – LIBRARY
Name of field Data type Data size constraints
L_id integer 15 Primary key
L_Name string 30 Not null
L_Incharge string 15 Not nul
L_location string 30 Not null
L_Ph string 10 Not null
Table – STAFF
Name of field Data type Data size constraints
S_id integer 15 Primary key
S_Name string 20 Not null
S_Address string 50 Not null
S_Salary string 10 Not null
S_JD string 30 Not null
S_Ph string 10 Not null
Table – REGISTRATION
Name of field Data type Data size constraints
S_id integer 15 Primary key
S_Name string 30 Not null
S_Fname string 30 Not null
S_Mname string 30 Not null
S_DOB Date Not null
S_Address string 50 Not null
S_Ph integer 10 Not null
Synopsis
Table – ENQUIRY
Name of field Data type Data size constraints
E_id integer 15 Primary key
E_name string 30 Not null
E_Purpose string 50 Not null
E_Address string 50 Not null
E_Ph string 10 Not null
Table – FEE
Name of field Data type Data size constraints
S_id integer 15 Primary key
S_name string 30 Not null
S_Fname string 30 Not null
S_Mname string 30 Not null
S_Bdues string 10 Not null
S_Cdues string 10 Not null
S_Address string 50 Not null
Process logic Diagram –
1. Enquiry :-
Description: - this table holds the details about the enquiry.
Input :- e_ id , e_ purpose
Process :-search related information
Output :-give the correct information
2. Registration :-
Description :- - this table holds the details about the registration
Input :- s_id , s_name
Process :- search related information
Output :- give the correct information
3. Student :-
Description :- - this table holds the details about the student
Input :- stu_id , stu_name
Process :- search related information
Synopsis
Output :- give the correct information
4. Fees :-
Description :- - this table holds the details about the fees
Input :- stu_id , stu_name
Process :- search related information
Output :- give the correct information
5. Library :-
Description :- - this table holds the details about the library
Input :- stu_id , stu_name , b_id , b_name
Process :- search related information
Output :- give the correct information
6. Staff :-
Description :- - this table holds the details about the staff
Input :- st_id , st_name
Process :- search related information
Output :- give the correct information
Testing process of each module :-
.
Black box testing
Black box testing focuses on the fundamental requirement of the software. that is,
Black box testing enables the software engineer to
Drive sets of input condition that will fully exercise all functional requirements for a
program. Black box testing is not
Alternative to white box testing. There are two level of testing-unit testing and system
testing
Report generated –
Enquiry: With the help of enquiry table, we can generate the report about
enquiry.
Synopsis
Registration: With the help of registration table, we can generate the report about
registration.
Student: With the help of student table, we can generate the report about student.
Fee: With the help of fees table, we can generate the report about fees.
Library: With the help of library table, we can generate the report of the library.
Staff: With the help of staff table, we can generate the report of the staff.
5- Tool/platform H/w & S/w requirement specification
Hardware:-
C.P.U. : Core 2 Due
Motherboard : Intel chip/ original based Pentium pc
RAM : 2 GB
Monitor : color (SVGA)
Resolution : 800*600
HDD : 160 GB
Synopsis
Software:-
Operating system : windows XP (SP2)
Front end : Microsoft visual basic 6.0
Back end : Oracle 10g
6. FUTURE SCOPE AND FURTHER ENHANCEMENT
OF THE PROJECT.
1. All college, School or Institute can use my project with little changes.
2. My project can handle also Hostel management with little change.
3. This project can be converted into client - server based, so all the user
may do any work on this software at same time.
