School Management 414bu
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 2z6p3t
Overview 5o1f4z
& View School Management as PDF for free.
More details 6z3438
- Words: 2,978
- Pages: 78
SCHOOL MANAGEMENT SYSTEM By Akash Banginwar
COMPANY PROFILE About organization ISTR is a rapidly growing, innovative, dynamic company situated in the very happening city of Pune, Nasik, Kolhapur. ISTR provide the clients a strategic competitive edge in their marketplace by leveraging cost effective key technology resources to rapidly produce business critical applications. In today’s dynamically changing marketplace, ISTR work harder, faster and smarter to deliver high quality services and solutions to the clients. The delivery model is proven, flexible and highly cost-effective way to give the clients a technological edge over their competition. Our Vision To become one of the leading lights in software and web application development by providing reliable and quality services ensuring lasting customer satisfaction. Our Mission To rapidly produce business critical applications, high quality, timely and cost effective IT solution.
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. School
Management System consists of tasks such as ing students, attendance record keeping controlling absentees, producing report cards, producing official transcript, preparing timetable and producing different reports for teachers and parents.
EXISTING SYSTEM In the current system we need to keep a number of records related to the student and want to enter the details of the student and the marks manually. In this system only the teacher or the school authority views the mark of the student and they want to enter the details of the student. This is time consuming and has much cost. Teachers may want to associate a student with his parent or emergency persons for disciplinary measures which need searching of the students record in the record office. It has been difficult to search a record from thousands of such records and observed that students can take any person claiming that he/she is their parent or emergency person which creates problem in control of students.
NEED FOR 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 when it found unnecessary. The marks of the student are added in the database and so students can also view the marks whenever they want. Our proposed system has several advantages:
friendly interface
Fast
access to database
Less
error
More
Storage Capacity
Search Look
facility
and Feel Environment
SCOPE OF WORK The purpose of any new technology is to make people life easier. This project is database used to manage the school and allows the s to the daily required information of Students, Teachers & office staff. School Management System will organize work inside school and proposed system will do the following tasks: Insert
student’s information such as student name, student number, address etc. Insert employee’s information such as employee name, number, address etc. Insert section’s information such as section name etc. Insert marks for each student in each subject he/she taken. View data about certain student and can edit it like adding or removing a student. View data about certain employee and can edit it like adding or removing an employee.
TECHNOLOGY USED
Microsoft Visual Studio 2005: Visual Studio is a complete set of development tools for building ASP.NET Web applications, XML Web Services, desktop applications, and mobile applications. Visual Basic, Visual C#, and Visual C++ all use the same integrated development environment (IDE), which enables tool sharing and eases the creation of mixedlanguage solutions. In addition, these languages use the functionality of the .NET Framework, which provides access to key technologies that simplify the development of ASP Web applications and XML Web Services.
SAS (Statistical Analysis System) SAS is driven by SAS programs, which define a sequence of operations to be performed on data stored as tables. Although nonprogrammer graphical interfaces to SAS exist (such as the SAS Enterprise Guide), these GUIs are most often merely a front-end that automates or facilitates the generation of SAS programs. The functionalities of SAS components are intended to be accessed via application programming interfaces, in the form of statements and procedures.
Microsoft Office Access Microsoft Access, also known as Microsoft Office Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases. Software developers and data architects can use Microsoft Access to develop application software, and "power s" can use it to build software applications. Like other Office applications, Access is ed by Visual Basic for Applications, an object-oriented programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose their methods and properties in the VBA programming environment, and VBA code modules may declare and call Windows operating-system functions.
DATA FLOW DIAGRAM
Context Level Diagram
ission details
Fees Details
0.0 Student details
STUDENT
School Management System
Get ission details
Get ission
STUDENT
Enquiry about ission Get Payment slip
STAFF
Salary details
ission details
STAFF
First Level Data Flow Diagram 1.0
Enter Name &
Process
Show message Correct or not _word Check Name &
Staff
Student
2.0 Fill the form submit ission
Add Student Details
ission Process
Add student
Student Add employee
Staff
Get job
Staff A
A
Student
Pay fees Details
Insert Fees Details
3.0
Pay Process Staff
Fees_details
Get fees receipt
Insert Payment Details
Student Payment_details
Get Pay slip
Staff Details
Insert Exam Details 4.0
Student
Staff
Give exam timetable details
Exam Process
A
Staff Exam
Student Get exam details
Insert Exam time_table
Staff
Time_table
A
Student
Marks
5.0
Staff
Get Result details
Result Generation process
Student
Get result details
Give Result details Student details Employee details
Result details Student details Staff details
Staff
Exam marks details Student Fees details
6.0
Report Generation
Add Emp Marks Fees
Salary details Attendance details
Staff Payment details Emp/student Attendance details
Add Student
Exam details
Payment Attendance
Exam
Second Level Data Flow Diagram Student
2.1 Submit ission Form process
Staff
Student
Student
Add Staff Details
Add employee
Get job details
2.2 Submit the form pay fees
Get ission Receipt
Gives the ission receipts
Get the job
Staff
Add student
Add Student Details
Staff
Student
Staff
Get fees details
Student
Gives Category details
3.1 Paying Fees Process
Pay fees
Get the fee receipt Give category details Add Student Insert category details
3.2
Insert Emp Attendance Emp_Attendance
Gives Status details
Get Salary Process
Staff Gives attendance details
Student
Get payment/salary slip
Staff
Add Employee Insert Status details
Gives Allowance details
Set Allowance
Entity Relationship Diagram EMP_ATTEND ENCE Daily_Time _Table
M
Has
M
M
WORKING_DAYS
DESIGNATION
Has
1
1
CLASS
Has
TEARCHERS 1
1
1 1
SOFTWARE_ SETTING M
Teach
DIVISION
1
M
Has M
Appear
EXAM 1
Gets Has
M
MARKS
M
M
CASTE M
Has
1
M
Has
1
Has M
Has
Has M
1
RELIGION
ALLOWNCES
M M
M
Has
Has
1
CATEGORY_ FEES
Pays
Has M
1
Has
1
PAYMENT 1
M
FEES
ADD STUDENT M
Gets
Has
STU_ATTEN DENCE M
1
M
1
Has
M
1
Has
1
ADD EMPLOYEE
1
SUBJECTS
QUALIFICATIO N CATEGORY
EXAM_TIME_ TABLE
1
Has
M
Has VENDORS
M
1
M
M
EXAM_DATES
SUBJECT_TIME _TABLE
Provides
PRODUCTS M
Table Design
•Student ission (addstudent) Column Name
Data Type
Constraints
sid
AutoNumber
Primary_Key
fname
Text
Not Null
mname
Text
Not Null
lname
Text
Not Null
pfname
Text
Not Null
pmname
Text
Not Null
plname
Text
Not Null
mfname
Text
Not Null
mmname
Text
Not Null
mlname
Text
Not Null
dob
Date/Time
Not Null
wt
Number
Not Null
ht
Number
Not Null
rid
Number
Foreign_Key(Religion)
rel_name
Text
Not Null
bus_facility
Text
Not Null
mother_tounge
Text
Not Null
birth_mark
Text
Not Null
diesease
Text
Not Null
student_bus_no_rto
Text
Not Null
bus_no_school
Text
Not Null
student_adhar_card_no
Text
Not Null
pre_institute_name
Text
Not Null
pre_institute_address
Text
Not Null
e_physician_name
Text
Not Null
e_physician_address
Text
Not Null
e_physician_phone
Number
Not Null
classs
Number
Foreign_Key(Add_Class)
occupation_father
Text
Not Null
edu_father
Text
Not Null
fbgroup
Text
Not Null
email
Text
Not Null
father_office_address
Text
Not Null
cont1
Number
Not Null
occupation_mother
Text
Not Null
memail
Text
Not Null
mother_office_address
Text
Not Null
cont2
Text
Not Null
caddress
Text
Not Null
paddress
Text
Not Null
talukatem
Text
Not Null
districttem
Text
Not Null
pintem
Number
Not Null
talukaper
Text
Not Null
districtper
Text
Not Null
pinper
Number
Not Null
ddate
Date/Time
Not Null
_name
Text
Not Null
sex
Text
Not Null
addate
Date/Time
Not Null
fromyy
Text
Not Null
toyy
Text
Not Null
installments
Number
Not Null
•Student Attendance(stu_attendance)
Column Name
Data Type
Constraints
sid
Number
Foreign_key(addstudent)
adate
Date/Time
Not Null
astatus
Text
Not Null
dd
Number
Not Null
mm
Number
Not Null
yy
Number
Not Null
ddate
Text
Not Null
_name
Text
Not Null
Acic_year
Text
Not Null
class
Number
Not Null
div
Text
Not Null
•Assign Religion(Religion)
Column Name
Data Type
Constraints
rid
Number
Primary_key
rel_name
Text
Not Null
Acic_year
Text
Not Null
•Employee Details(addemployee) Column Name
Data Type
Constraints
eid
Number
Primary_key
efname
Text
Not Null
emname
Text
Not Null
elname
Text
Not Null
epfname
Text
Not Null
epmname
Text
Not Null
eplname
Text
Not Null
emfname
Text
Not Null
emmname
Text
Not Null
emlname
Text
Not Null
dob
Date/Time
Not Null
wt
Number
Not Null
Ht
Number
Not Null
marries_status
Text
Not Null
jodate
Date/Time
Not Null
did
Number
Foreign_Key(designation)
day_id
Number
Foreign_Key(Workingday)
quali
Text
Not Null
aid
AutoNumber
Not Null
sex
Text
Not Null
rel_name
Text
Not Null
caste
Text
Not Null
bgroup
Text
Not Null
mother_tounge
Text
Not Null
birth_mark
Text
Not Null
dieaseas
Text
Not Null
teacher_bus_no_rto
Text
Not Null
bus_no_school
Text
Not Null
adhar_card_no
Text
Not Null
pre_institute_name
Text
Not Null
pre_institute_address
Text
Not Null
bus_facility
Text
Not Null
e_physician_name
Text
Not Null
e_physician_address
Text
Not Null
e_physician_phone
Number
Not Null
status_id
Number
Foreign_key(set_Allowance)
basic_pay
Number
Not Null
add_class
Number
Not Null
occupation_father
Text
Not Null
occupation_father
Text
Not Null
fbgroup
Text
Not Null
email
Text
Not Null
father_office_addres
Text
Not Null
cont1
Text
Not Null
occupation_spouse
Text
Not Null
edu_spouse
Text
Not Null
Subgroup
Text
Not Null
Semail
Text
Not Null
spouse_office_addre
Text
Not Null
cont2
Number
Not Null
caddress
Text
Not Null
paddress
Text
Not Null
talukatem
Text
Not Null
districttem
Text
Not Null
pintem
Number
Not Null
talukaper
Text
Not Null
districtper
Text
Not Null
pinper
Number
Not Null
ddate
Text
Not Null
_name
Text
Not Null
eemail
Text
Not Null
econt1
Number
Not Null
yy
Text
Not Null
mm
Text
Not Null
dd
Text
Not Null
Acic_year
Text
Not Null
•Employee Attendance(emp_attendance) Column Name
Data Type
Constraints
eid
Number
Foreign_key(addemployee)
adate
Date/Time
Not Null
astatus
Text
Not Null
dd
Number
Not Null
mm
Number
Not Null
yy
Number
Not Null
ddate
Text
Not Null
_name
Text
Not Null
Acic_year
Text
Not Null
•Category Fees Structure(cate_fee)
Column Name
Data Type
Constraints
cat_id
Number
Foregin_key(Category)
cat_name
Text
Not Null
classs
Number
Not Null
fee_amt
Number
Not Null
periodf
Text
Not Null
periodt
Text
Not Null
ddate
Text
Not Null
Text
Not Null
Acic_year
Text
Not Null
•Caste(castt)
Column Name
Data Type
Constraints
cast_id
Number
Primary_key
rid
Number
Foregin_key(Religion)
cast_name
Text
Not Null
Acic_year
Text
Not Null
•Category(category) Column Name
Data Type
Constraints
cat_id
Number
Primary_key
cat_name
Text
Not Null
Acic_year
Text
Not Null
•Assign caste to category(category_cast) Comp.P.K(cat_id +cast_id) Column Name
Data Type
Constraints
cat_id
Number
Foreign_key(Category)
cast_id
Number
Foreign_key(Caste)
Acic_year
Text
Not Null
•Add class(addclass)
Column Name
Data Type
Constraints
classs
Number
Primary_key
Acic_year
Text
Not Null
•Add Division to class(adddiv) Column Name
Data Type
Constraints
classs
Number
Foregin_key(Addclass)
did
Number
Primary_key
division
Text
Not Null
ddate
Text
Not Null
_name
Text
Not Null
Acic_year
Text
Not Null
•Add Subject(subjects)
Column Name
Data Type
Constraints
sub_id
Number
Primary_key
sub_name
Text
Not Null
marks
Number
Not Null
_marks
Number
Not Null
Acic_year
Text
Not Null
•Assign Division & Roll no. student(adddivision)
Column Name
Data Type
Constraints
Sid
Number
Foregin_key(addstudent)
Classs
Number
Foregin_key(addclass)
did
Text
Foregin_key(adddiv)
Roll
Number
Not Null
Fdate
Text
Not Null
Tdate
Text
Not Null
bona_status
Text
Not Null
lc_status
Text
Not Null
ddate
Text
Not Null
_name
Text
Not Null
Academic_year
Text
Not Null
•Add class Subject(class_subject)
Column Name
Data Type
Constraints
sub_id
Number
Foregin_key(Subjects)
classs
Number
Foregin_key(addclass)
did
Number
Foregin_key(adddiv)
Acic_year
Text
Not Null
•Designation(designation) Column Name
Data Type
Constraints
did
Number
Primary_key
designation
Text
NotNull
Acic_year
Text
NotNull
•Teachers(teachers) Column Name
Data Type
Constraints
classs
Number
Foregin_key(addclass)
did
Number
Foregin_key(adddiv)
qid
Number
Foregin_key(qualification)
sub_id
Number
Foregin_key(subjects)
teacher
Text
NotNull
aid
Number
Foregin_key(addemploye)
_name
Text
NotNull
ddate
Date/Time
NotNull
Acic_year
Text
NotNull
•Daily Time Table Settings(Daily_timetable_settings)
Column Name
Data Type
Constraints
day_id
Number
Foregin_key(Workingday)
day
Number
NotNull
school_st_tm
Date/Time
NotNull
lecture_no
Number
NotNull
lecture_st_tm
Date/Time
NotNull
lecture_tm
Number
NotNull
breakno
Text
NotNull
after_lec
Number
NotNull
recess_tm_min
Number
NotNull
Acic_year
Text
NotNull
•Create Time Table(Daily_time_table) Column Name
Data Type
Constraints
classs
Number
Foregin_key(addclass)
division
Text
Foregin_key(adddiv)
subject
Text
NotNull
sub_id
Number
Foregin_key(subjects)
day_id
Number
Foregin_key(Workingday)
teacher
Text
NotNull
lecture_no
Number
NotNull
period_no
Number
NotNull
ddate
Text
NotNull
name
Text
NotNull
ftime
Date/Time
NotNull
ttime
Date/Time
NotNull
Acic_year
Text
NotNull
•Software Settings(software_settings)
Column Name
Data Type
Constraints
sinfo
Text
Primary_key
svalue
Text
NotNull
ddate
Text
NotNull
Text
NotNull
•Add Qalifiction(qualifiction)
Column Name
Data Type
Constraints
qid
AutoNumber
Primary_key
quali
Text
NotNull
Acic_year
Text
NotNull
•Set Allowances(set_allowances) Column Name
Data Type
Constraints
Status_id
Number
Primary_key
did
Number
Foreign_key(desination)
designation
Text
NotNull
etype
Text
NotNull
DA
Number
NotNull
TA
Number
NotNull
HRA
Number
NotNull
PF
Number
NotNull
da_status
Text
NotNull
ta_status
Text
NotNull
hra_status
Text
NotNull
pf_status
Text
NotNull
TDS
Number
NotNull
tds_status
Text
NotNull
Acic_year
Text
NotNull
•Payment Details(payment_details)
Column Name
Data Type
Constraints
pid
Number
Primary_key
eid
Number
Foregin_key(addemploye)
status_id
Number
Foregin_key(setAllowances)
pdate
Text
NotNull
basic_pay
Number
NotNull
da
Number
NotNull
ta
Number
NotNull
hra
Number
NotNull
gross_pay
Number
NotNull
pf
Number
NotNull
net_pay
Number
NotNull
ddate
Text
NotNull
_name
Text
NotNull
Acic_year
Text
NotNull
•Vendor Details(vendor_details)
Column Name
Data Type
Constraints
vid
Number
Primary_key
vregno
Number
NotNull
vname
Text
NotNull
vaddr
Text
NotNull
office_cont
Number
NotNull
mob_cont
Number
NotNull
vdate
Text
NotNull
_name
Text
NotNull
Acic_year
Text
NotNull
•Product Details(product_details)
Column Name
Data Type
Constraints
pid
Number
Primary_key
vid
Number
Foregin_key(Vender_detail)
pname
Text
NotNull
ddate
Text
NotNull
usr
Text
NotNull
Acic_year
Text
NotNull
•Purchase Details(purchase_details) Column Name
Data Type
Constraints
pur_id
Number
Primary_key
pid
Number
Foregin_key(Product_details)
vid
Number
Foregin_key(Vender_detail)
iname
Text
NotNull
iquantity
Number
NotNull
i_rate
Number
NotNull
ipur_date
Text
NotNull
itax
Number
NotNull
itotal
Text
NotNull
sdate
Text
NotNull
_name
Text
NotNull
Acic_year
Text
NotNull
•Fees Details(fees_details) Column Name
Data Type
Constraints
fid
Number
Primary_key
sid
Number
Foregin_key(addstudent)
cid
Number
Foregin_key(category fees struct)
ftype
Text
NotNull
dd
Number
NotNull
mm
Number
NotNull
yy
Number
NotNull
installments
Number
NotNull
ddate
Text
NotNull
Text
NotNull
cashier_name
Text
NotNull
paying_mode
Text
NotNull
bank_name
Text
NotNull
dd/check_no
Memo
NotNull
remark
Text
NotNull
total_fees
Number
NotNull
fees_paid
Number
NotNull
paid_by
Text
NotNull
status
Text
NotNull
•Create Message Group Name(mas_group) Column Name
Data Type
Constraints
gid
Number
Primary_key
gname
Text
NotNull
Acic_year
Text
NotNull
•Add Student Into Message Group(msg_group)
Column Name
Data Type
Constraints
gid
Number
Forigen_key(mas_group)
sid
Number
Forigen_key(addstudent)
ddate
Text
NotNull
_name
Text
NotNull
Acic_year
Text
NotNull
•Message Report(msg)
Column Name
Data Type
Constraints
gid
Number
Forigen_key(mas_group)
sid
Number
Forigen_key(addstudent)
mdate
Date/Time
NotNull
msg
Text
NotNull
ddate
Text
NotNull
_name
Text
NotNull
Acic_year
Text
NotNull
•Exam(exam) Column Name
Data Type
Constraints
exid
Number
Primary_key
ex_am
Text
NotNull
outof
Number
NotNull
ddate
Text
NotNull
_name
Text
NotNull
Acic_year
Text
NotNull
•Exam Dates(Exam_Date) Column Name
Data Type
Constraints
exid
Number
Foreign_key(exam)
edate
Text
NotNull
end_date
Text
NotNull
classs
Number
Foregin_key(addclass)
did
Number
Foregin_key(addiv)
ex_rec_id
Number
NotNull
Acic_year
Text
NotNull
•Exam Time Table(ex_time_table)
Column Name
Data Type
Constraints
extid
AutoNumber
Primary_key
exid
Number
Forigen_key(exam)
edate
Text
NotNull
classs
Number
NotNull
division
Text
NotNull
emonth
Number
NotNull
eyear
Number
NotNull
ddate
Text
NotNull
_name
Text
NotNull
Acic_year
Text
NotNull
•Exam Subject Time Table(Subject_time_table) Column Name
Data Type
Constraints
extid
Number
Forigen_key(Exam timetable)
etimef
Text
NotNull
etimet
Text
NotNull
Sub_id
Number
Forigen_key(Subjects)
sub_name
Text
NotNull
exdate
Text
NotNull
Acic_year
Text
NotNull
•Working Days(workingday)
Column Name
Data Type
Constraints
day_id
Number
Primary_key
day
Text
NotNull
•Exam Marks(marks) Column Name
Data Type
Constraints
sid
Number
Forigen_key(addstudent)
exid
Number
Forigen_key(exam)
subject
Text
NotNull
marks
Number
NotNull
outof
Number
NotNull
Ddate
Text
NotNull
_name
Text
NotNull
sub_id
Number
Forigen_key(subjects)
edate
Text
NotNull
Acic_year
Text
NotNull
•Log-in(_word) Column Name
Data Type
Constraints
nm
Text
Primary_key
Text
NotNull
priority
Text
NotNull
SYSTEM SCREEN SHOTS
•Log-In Page:
•Dash Board(Main Screen):
System screen Shots
•Set Allowances:
•Add Caste:
•Add Religion:
•Daily Timetable Settings:
•Assign Subject Teacher:
•Add Student Information Form:
•Add Parents Information Form:
•Assign Class & Division For Student:
•Assign Roll Number For Student:
•Student Fees Payment:
•Sent Message Individually:
•Sent Message to Group:
•Add Vendor Details:
Daily Timetable creation1
•Daily Timetable creation For Student :
•Daily Timetable creation For Teacher:
•Result in PDF Format :
GRAPHICAL REPORT OF RESULT
•Student Report :
•Student Attendance Report :
•Send Message Report :
•Generate Bonafide Certificate :
•Generate Bonafide Certificate into PDF Format :
THANK YOU…..
COMPANY PROFILE About organization ISTR is a rapidly growing, innovative, dynamic company situated in the very happening city of Pune, Nasik, Kolhapur. ISTR provide the clients a strategic competitive edge in their marketplace by leveraging cost effective key technology resources to rapidly produce business critical applications. In today’s dynamically changing marketplace, ISTR work harder, faster and smarter to deliver high quality services and solutions to the clients. The delivery model is proven, flexible and highly cost-effective way to give the clients a technological edge over their competition. Our Vision To become one of the leading lights in software and web application development by providing reliable and quality services ensuring lasting customer satisfaction. Our Mission To rapidly produce business critical applications, high quality, timely and cost effective IT solution.
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. School
Management System consists of tasks such as ing students, attendance record keeping controlling absentees, producing report cards, producing official transcript, preparing timetable and producing different reports for teachers and parents.
EXISTING SYSTEM In the current system we need to keep a number of records related to the student and want to enter the details of the student and the marks manually. In this system only the teacher or the school authority views the mark of the student and they want to enter the details of the student. This is time consuming and has much cost. Teachers may want to associate a student with his parent or emergency persons for disciplinary measures which need searching of the students record in the record office. It has been difficult to search a record from thousands of such records and observed that students can take any person claiming that he/she is their parent or emergency person which creates problem in control of students.
NEED FOR 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 when it found unnecessary. The marks of the student are added in the database and so students can also view the marks whenever they want. Our proposed system has several advantages:
friendly interface
Fast
access to database
Less
error
More
Storage Capacity
Search Look
facility
and Feel Environment
SCOPE OF WORK The purpose of any new technology is to make people life easier. This project is database used to manage the school and allows the s to the daily required information of Students, Teachers & office staff. School Management System will organize work inside school and proposed system will do the following tasks: Insert
student’s information such as student name, student number, address etc. Insert employee’s information such as employee name, number, address etc. Insert section’s information such as section name etc. Insert marks for each student in each subject he/she taken. View data about certain student and can edit it like adding or removing a student. View data about certain employee and can edit it like adding or removing an employee.
TECHNOLOGY USED
Microsoft Visual Studio 2005: Visual Studio is a complete set of development tools for building ASP.NET Web applications, XML Web Services, desktop applications, and mobile applications. Visual Basic, Visual C#, and Visual C++ all use the same integrated development environment (IDE), which enables tool sharing and eases the creation of mixedlanguage solutions. In addition, these languages use the functionality of the .NET Framework, which provides access to key technologies that simplify the development of ASP Web applications and XML Web Services.
SAS (Statistical Analysis System) SAS is driven by SAS programs, which define a sequence of operations to be performed on data stored as tables. Although nonprogrammer graphical interfaces to SAS exist (such as the SAS Enterprise Guide), these GUIs are most often merely a front-end that automates or facilitates the generation of SAS programs. The functionalities of SAS components are intended to be accessed via application programming interfaces, in the form of statements and procedures.
Microsoft Office Access Microsoft Access, also known as Microsoft Office Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases. Software developers and data architects can use Microsoft Access to develop application software, and "power s" can use it to build software applications. Like other Office applications, Access is ed by Visual Basic for Applications, an object-oriented programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose their methods and properties in the VBA programming environment, and VBA code modules may declare and call Windows operating-system functions.
DATA FLOW DIAGRAM
Context Level Diagram
ission details
Fees Details
0.0 Student details
STUDENT
School Management System
Get ission details
Get ission
STUDENT
Enquiry about ission Get Payment slip
STAFF
Salary details
ission details
STAFF
First Level Data Flow Diagram 1.0
Enter Name &
Process
Show message Correct or not _word Check Name &
Staff
Student
2.0 Fill the form submit ission
Add Student Details
ission Process
Add student
Student Add employee
Staff
Get job
Staff A
A
Student
Pay fees Details
Insert Fees Details
3.0
Pay Process Staff
Fees_details
Get fees receipt
Insert Payment Details
Student Payment_details
Get Pay slip
Staff Details
Insert Exam Details 4.0
Student
Staff
Give exam timetable details
Exam Process
A
Staff Exam
Student Get exam details
Insert Exam time_table
Staff
Time_table
A
Student
Marks
5.0
Staff
Get Result details
Result Generation process
Student
Get result details
Give Result details Student details Employee details
Result details Student details Staff details
Staff
Exam marks details Student Fees details
6.0
Report Generation
Add Emp Marks Fees
Salary details Attendance details
Staff Payment details Emp/student Attendance details
Add Student
Exam details
Payment Attendance
Exam
Second Level Data Flow Diagram Student
2.1 Submit ission Form process
Staff
Student
Student
Add Staff Details
Add employee
Get job details
2.2 Submit the form pay fees
Get ission Receipt
Gives the ission receipts
Get the job
Staff
Add student
Add Student Details
Staff
Student
Staff
Get fees details
Student
Gives Category details
3.1 Paying Fees Process
Pay fees
Get the fee receipt Give category details Add Student Insert category details
3.2
Insert Emp Attendance Emp_Attendance
Gives Status details
Get Salary Process
Staff Gives attendance details
Student
Get payment/salary slip
Staff
Add Employee Insert Status details
Gives Allowance details
Set Allowance
Entity Relationship Diagram EMP_ATTEND ENCE Daily_Time _Table
M
Has
M
M
WORKING_DAYS
DESIGNATION
Has
1
1
CLASS
Has
TEARCHERS 1
1
1 1
SOFTWARE_ SETTING M
Teach
DIVISION
1
M
Has M
Appear
EXAM 1
Gets Has
M
MARKS
M
M
CASTE M
Has
1
M
Has
1
Has M
Has
Has M
1
RELIGION
ALLOWNCES
M M
M
Has
Has
1
CATEGORY_ FEES
Pays
Has M
1
Has
1
PAYMENT 1
M
FEES
ADD STUDENT M
Gets
Has
STU_ATTEN DENCE M
1
M
1
Has
M
1
Has
1
ADD EMPLOYEE
1
SUBJECTS
QUALIFICATIO N CATEGORY
EXAM_TIME_ TABLE
1
Has
M
Has VENDORS
M
1
M
M
EXAM_DATES
SUBJECT_TIME _TABLE
Provides
PRODUCTS M
Table Design
•Student ission (addstudent) Column Name
Data Type
Constraints
sid
AutoNumber
Primary_Key
fname
Text
Not Null
mname
Text
Not Null
lname
Text
Not Null
pfname
Text
Not Null
pmname
Text
Not Null
plname
Text
Not Null
mfname
Text
Not Null
mmname
Text
Not Null
mlname
Text
Not Null
dob
Date/Time
Not Null
wt
Number
Not Null
ht
Number
Not Null
rid
Number
Foreign_Key(Religion)
rel_name
Text
Not Null
bus_facility
Text
Not Null
mother_tounge
Text
Not Null
birth_mark
Text
Not Null
diesease
Text
Not Null
student_bus_no_rto
Text
Not Null
bus_no_school
Text
Not Null
student_adhar_card_no
Text
Not Null
pre_institute_name
Text
Not Null
pre_institute_address
Text
Not Null
e_physician_name
Text
Not Null
e_physician_address
Text
Not Null
e_physician_phone
Number
Not Null
classs
Number
Foreign_Key(Add_Class)
occupation_father
Text
Not Null
edu_father
Text
Not Null
fbgroup
Text
Not Null
Text
Not Null
father_office_address
Text
Not Null
cont1
Number
Not Null
occupation_mother
Text
Not Null
memail
Text
Not Null
mother_office_address
Text
Not Null
cont2
Text
Not Null
caddress
Text
Not Null
paddress
Text
Not Null
talukatem
Text
Not Null
districttem
Text
Not Null
pintem
Number
Not Null
talukaper
Text
Not Null
districtper
Text
Not Null
pinper
Number
Not Null
ddate
Date/Time
Not Null
_name
Text
Not Null
sex
Text
Not Null
addate
Date/Time
Not Null
fromyy
Text
Not Null
toyy
Text
Not Null
installments
Number
Not Null
•Student Attendance(stu_attendance)
Column Name
Data Type
Constraints
sid
Number
Foreign_key(addstudent)
adate
Date/Time
Not Null
astatus
Text
Not Null
dd
Number
Not Null
mm
Number
Not Null
yy
Number
Not Null
ddate
Text
Not Null
_name
Text
Not Null
Acic_year
Text
Not Null
class
Number
Not Null
div
Text
Not Null
•Assign Religion(Religion)
Column Name
Data Type
Constraints
rid
Number
Primary_key
rel_name
Text
Not Null
Acic_year
Text
Not Null
•Employee Details(addemployee) Column Name
Data Type
Constraints
eid
Number
Primary_key
efname
Text
Not Null
emname
Text
Not Null
elname
Text
Not Null
epfname
Text
Not Null
epmname
Text
Not Null
eplname
Text
Not Null
emfname
Text
Not Null
emmname
Text
Not Null
emlname
Text
Not Null
dob
Date/Time
Not Null
wt
Number
Not Null
Ht
Number
Not Null
marries_status
Text
Not Null
jodate
Date/Time
Not Null
did
Number
Foreign_Key(designation)
day_id
Number
Foreign_Key(Workingday)
quali
Text
Not Null
aid
AutoNumber
Not Null
sex
Text
Not Null
rel_name
Text
Not Null
caste
Text
Not Null
bgroup
Text
Not Null
mother_tounge
Text
Not Null
birth_mark
Text
Not Null
dieaseas
Text
Not Null
teacher_bus_no_rto
Text
Not Null
bus_no_school
Text
Not Null
adhar_card_no
Text
Not Null
pre_institute_name
Text
Not Null
pre_institute_address
Text
Not Null
bus_facility
Text
Not Null
e_physician_name
Text
Not Null
e_physician_address
Text
Not Null
e_physician_phone
Number
Not Null
status_id
Number
Foreign_key(set_Allowance)
basic_pay
Number
Not Null
add_class
Number
Not Null
occupation_father
Text
Not Null
occupation_father
Text
Not Null
fbgroup
Text
Not Null
Text
Not Null
father_office_addres
Text
Not Null
cont1
Text
Not Null
occupation_spouse
Text
Not Null
edu_spouse
Text
Not Null
Subgroup
Text
Not Null
Semail
Text
Not Null
spouse_office_addre
Text
Not Null
cont2
Number
Not Null
caddress
Text
Not Null
paddress
Text
Not Null
talukatem
Text
Not Null
districttem
Text
Not Null
pintem
Number
Not Null
talukaper
Text
Not Null
districtper
Text
Not Null
pinper
Number
Not Null
ddate
Text
Not Null
_name
Text
Not Null
eemail
Text
Not Null
econt1
Number
Not Null
yy
Text
Not Null
mm
Text
Not Null
dd
Text
Not Null
Acic_year
Text
Not Null
•Employee Attendance(emp_attendance) Column Name
Data Type
Constraints
eid
Number
Foreign_key(addemployee)
adate
Date/Time
Not Null
astatus
Text
Not Null
dd
Number
Not Null
mm
Number
Not Null
yy
Number
Not Null
ddate
Text
Not Null
_name
Text
Not Null
Acic_year
Text
Not Null
•Category Fees Structure(cate_fee)
Column Name
Data Type
Constraints
cat_id
Number
Foregin_key(Category)
cat_name
Text
Not Null
classs
Number
Not Null
fee_amt
Number
Not Null
periodf
Text
Not Null
periodt
Text
Not Null
ddate
Text
Not Null
Text
Not Null
Acic_year
Text
Not Null
•Caste(castt)
Column Name
Data Type
Constraints
cast_id
Number
Primary_key
rid
Number
Foregin_key(Religion)
cast_name
Text
Not Null
Acic_year
Text
Not Null
•Category(category) Column Name
Data Type
Constraints
cat_id
Number
Primary_key
cat_name
Text
Not Null
Acic_year
Text
Not Null
•Assign caste to category(category_cast) Comp.P.K(cat_id +cast_id) Column Name
Data Type
Constraints
cat_id
Number
Foreign_key(Category)
cast_id
Number
Foreign_key(Caste)
Acic_year
Text
Not Null
•Add class(addclass)
Column Name
Data Type
Constraints
classs
Number
Primary_key
Acic_year
Text
Not Null
•Add Division to class(adddiv) Column Name
Data Type
Constraints
classs
Number
Foregin_key(Addclass)
did
Number
Primary_key
division
Text
Not Null
ddate
Text
Not Null
_name
Text
Not Null
Acic_year
Text
Not Null
•Add Subject(subjects)
Column Name
Data Type
Constraints
sub_id
Number
Primary_key
sub_name
Text
Not Null
marks
Number
Not Null
_marks
Number
Not Null
Acic_year
Text
Not Null
•Assign Division & Roll no. student(adddivision)
Column Name
Data Type
Constraints
Sid
Number
Foregin_key(addstudent)
Classs
Number
Foregin_key(addclass)
did
Text
Foregin_key(adddiv)
Roll
Number
Not Null
Fdate
Text
Not Null
Tdate
Text
Not Null
bona_status
Text
Not Null
lc_status
Text
Not Null
ddate
Text
Not Null
_name
Text
Not Null
Academic_year
Text
Not Null
•Add class Subject(class_subject)
Column Name
Data Type
Constraints
sub_id
Number
Foregin_key(Subjects)
classs
Number
Foregin_key(addclass)
did
Number
Foregin_key(adddiv)
Acic_year
Text
Not Null
•Designation(designation) Column Name
Data Type
Constraints
did
Number
Primary_key
designation
Text
NotNull
Acic_year
Text
NotNull
•Teachers(teachers) Column Name
Data Type
Constraints
classs
Number
Foregin_key(addclass)
did
Number
Foregin_key(adddiv)
qid
Number
Foregin_key(qualification)
sub_id
Number
Foregin_key(subjects)
teacher
Text
NotNull
aid
Number
Foregin_key(addemploye)
_name
Text
NotNull
ddate
Date/Time
NotNull
Acic_year
Text
NotNull
•Daily Time Table Settings(Daily_timetable_settings)
Column Name
Data Type
Constraints
day_id
Number
Foregin_key(Workingday)
day
Number
NotNull
school_st_tm
Date/Time
NotNull
lecture_no
Number
NotNull
lecture_st_tm
Date/Time
NotNull
lecture_tm
Number
NotNull
breakno
Text
NotNull
after_lec
Number
NotNull
recess_tm_min
Number
NotNull
Acic_year
Text
NotNull
•Create Time Table(Daily_time_table) Column Name
Data Type
Constraints
classs
Number
Foregin_key(addclass)
division
Text
Foregin_key(adddiv)
subject
Text
NotNull
sub_id
Number
Foregin_key(subjects)
day_id
Number
Foregin_key(Workingday)
teacher
Text
NotNull
lecture_no
Number
NotNull
period_no
Number
NotNull
ddate
Text
NotNull
name
Text
NotNull
ftime
Date/Time
NotNull
ttime
Date/Time
NotNull
Acic_year
Text
NotNull
•Software Settings(software_settings)
Column Name
Data Type
Constraints
sinfo
Text
Primary_key
svalue
Text
NotNull
ddate
Text
NotNull
Text
NotNull
•Add Qalifiction(qualifiction)
Column Name
Data Type
Constraints
qid
AutoNumber
Primary_key
quali
Text
NotNull
Acic_year
Text
NotNull
•Set Allowances(set_allowances) Column Name
Data Type
Constraints
Status_id
Number
Primary_key
did
Number
Foreign_key(desination)
designation
Text
NotNull
etype
Text
NotNull
DA
Number
NotNull
TA
Number
NotNull
HRA
Number
NotNull
PF
Number
NotNull
da_status
Text
NotNull
ta_status
Text
NotNull
hra_status
Text
NotNull
pf_status
Text
NotNull
TDS
Number
NotNull
tds_status
Text
NotNull
Acic_year
Text
NotNull
•Payment Details(payment_details)
Column Name
Data Type
Constraints
pid
Number
Primary_key
eid
Number
Foregin_key(addemploye)
status_id
Number
Foregin_key(setAllowances)
pdate
Text
NotNull
basic_pay
Number
NotNull
da
Number
NotNull
ta
Number
NotNull
hra
Number
NotNull
gross_pay
Number
NotNull
pf
Number
NotNull
net_pay
Number
NotNull
ddate
Text
NotNull
_name
Text
NotNull
Acic_year
Text
NotNull
•Vendor Details(vendor_details)
Column Name
Data Type
Constraints
vid
Number
Primary_key
vregno
Number
NotNull
vname
Text
NotNull
vaddr
Text
NotNull
office_cont
Number
NotNull
mob_cont
Number
NotNull
vdate
Text
NotNull
_name
Text
NotNull
Acic_year
Text
NotNull
•Product Details(product_details)
Column Name
Data Type
Constraints
pid
Number
Primary_key
vid
Number
Foregin_key(Vender_detail)
pname
Text
NotNull
ddate
Text
NotNull
usr
Text
NotNull
Acic_year
Text
NotNull
•Purchase Details(purchase_details) Column Name
Data Type
Constraints
pur_id
Number
Primary_key
pid
Number
Foregin_key(Product_details)
vid
Number
Foregin_key(Vender_detail)
iname
Text
NotNull
iquantity
Number
NotNull
i_rate
Number
NotNull
ipur_date
Text
NotNull
itax
Number
NotNull
itotal
Text
NotNull
sdate
Text
NotNull
_name
Text
NotNull
Acic_year
Text
NotNull
•Fees Details(fees_details) Column Name
Data Type
Constraints
fid
Number
Primary_key
sid
Number
Foregin_key(addstudent)
cid
Number
Foregin_key(category fees struct)
ftype
Text
NotNull
dd
Number
NotNull
mm
Number
NotNull
yy
Number
NotNull
installments
Number
NotNull
ddate
Text
NotNull
Text
NotNull
cashier_name
Text
NotNull
paying_mode
Text
NotNull
bank_name
Text
NotNull
dd/check_no
Memo
NotNull
remark
Text
NotNull
total_fees
Number
NotNull
fees_paid
Number
NotNull
paid_by
Text
NotNull
status
Text
NotNull
•Create Message Group Name(mas_group) Column Name
Data Type
Constraints
gid
Number
Primary_key
gname
Text
NotNull
Acic_year
Text
NotNull
•Add Student Into Message Group(msg_group)
Column Name
Data Type
Constraints
gid
Number
Forigen_key(mas_group)
sid
Number
Forigen_key(addstudent)
ddate
Text
NotNull
_name
Text
NotNull
Acic_year
Text
NotNull
•Message Report(msg)
Column Name
Data Type
Constraints
gid
Number
Forigen_key(mas_group)
sid
Number
Forigen_key(addstudent)
mdate
Date/Time
NotNull
msg
Text
NotNull
ddate
Text
NotNull
_name
Text
NotNull
Acic_year
Text
NotNull
•Exam(exam) Column Name
Data Type
Constraints
exid
Number
Primary_key
ex_am
Text
NotNull
outof
Number
NotNull
ddate
Text
NotNull
_name
Text
NotNull
Acic_year
Text
NotNull
•Exam Dates(Exam_Date) Column Name
Data Type
Constraints
exid
Number
Foreign_key(exam)
edate
Text
NotNull
end_date
Text
NotNull
classs
Number
Foregin_key(addclass)
did
Number
Foregin_key(addiv)
ex_rec_id
Number
NotNull
Acic_year
Text
NotNull
•Exam Time Table(ex_time_table)
Column Name
Data Type
Constraints
extid
AutoNumber
Primary_key
exid
Number
Forigen_key(exam)
edate
Text
NotNull
classs
Number
NotNull
division
Text
NotNull
emonth
Number
NotNull
eyear
Number
NotNull
ddate
Text
NotNull
_name
Text
NotNull
Acic_year
Text
NotNull
•Exam Subject Time Table(Subject_time_table) Column Name
Data Type
Constraints
extid
Number
Forigen_key(Exam timetable)
etimef
Text
NotNull
etimet
Text
NotNull
Sub_id
Number
Forigen_key(Subjects)
sub_name
Text
NotNull
exdate
Text
NotNull
Acic_year
Text
NotNull
•Working Days(workingday)
Column Name
Data Type
Constraints
day_id
Number
Primary_key
day
Text
NotNull
•Exam Marks(marks) Column Name
Data Type
Constraints
sid
Number
Forigen_key(addstudent)
exid
Number
Forigen_key(exam)
subject
Text
NotNull
marks
Number
NotNull
outof
Number
NotNull
Ddate
Text
NotNull
_name
Text
NotNull
sub_id
Number
Forigen_key(subjects)
edate
Text
NotNull
Acic_year
Text
NotNull
•Log-in(_word) Column Name
Data Type
Constraints
nm
Text
Primary_key
Text
NotNull
priority
Text
NotNull
SYSTEM SCREEN SHOTS
•Log-In Page:
•Dash Board(Main Screen):
System screen Shots
•Set Allowances:
•Add Caste:
•Add Religion:
•Daily Timetable Settings:
•Assign Subject Teacher:
•Add Student Information Form:
•Add Parents Information Form:
•Assign Class & Division For Student:
•Assign Roll Number For Student:
•Student Fees Payment:
•Sent Message Individually:
•Sent Message to Group:
•Add Vendor Details:
Daily Timetable creation1
•Daily Timetable creation For Student :
•Daily Timetable creation For Teacher:
•Result in PDF Format :
GRAPHICAL REPORT OF RESULT
•Student Report :
•Student Attendance Report :
•Send Message Report :
•Generate Bonafide Certificate :
•Generate Bonafide Certificate into PDF Format :
THANK YOU…..
Related Documents c2h70
School Management 414bu
November 2022 0
School Management System k2o49
October 2019 111
School Management System k2o49
April 2020 30
School Management Systems Proposal 662b4w
November 2019 40
School Management System k2o49
December 2020 0
School Management System k2o49
November 2021 0More Documents from "Akshay Nayal" 4t5i5c
School Management 414bu
November 2022 0
2. Company Final s.pdf 3z6s5o
November 2019 80
Dme 2o5v5n
August 2021 0
International Foodstuffs Co V. Parle 5ft43
December 2021 0
Photoelectric Tachometer 2u3p6d
April 2022 0