1 of 20

��������Student Management System

2 of 20

��������GOAL OF THE PROJECT���Computerize The Manually� Operated System

3 of 20

���������EXISTING SYSTEM���DISADVANTAGES:�1)Physical Strain� 2)Less Interactive� 3)Time Consuming��

4 of 20

PRESENT SYSTEM

​

ADVANTAGES:

​

  • Highly Interactive
  • Instant Response
  • Time Saving

5 of 20

��������SOFTWARE ���VISUAL STUDIO.NET�ORACLE 8i�WINDOWS 2000 SERVER

6 of 20

DATABASE ARCHITECTURE

USER INTERFACE

DATA STORE

DATABASE ENGINE

​

7 of 20

���������BRIEF DESCRIPTION

8 of 20

��������STUDENT ADMINISTRATION�STAFF ADMINISTRATION�OFFICE ADMINISTRATION

9 of 20

STUDENT ADMINISTRATION

  • Student Registration
  • Class Administration
  • Class Registration
  • Attendance
  • Performance List
  • Monthly Payments
  • Exam Fee Structure

10 of 20

STAFF ADMINISTRATION

  • Staff Recruit Application
  • Recruit Confirmation
  • Salary Payments

​

​

11 of 20

OFFICE ADMINISTRATION

​

​

  • Stock Administration
  • Library Management

12 of 20

��������DATA FLOW DIAGRAMS

13 of 20

FIRST LEVEL DATAFLOW DIAGRAM

Student Administration

Student

Student Registration

Class Administration

Attendance

Students Installment

Fee Payments

Students Exam Fee Payments

Student Performance

14 of 20

  • SECOND LEVEL DATAFLOW DIAGRAM

STAFF

Staff Administration

Recruitments

Recruit_confirmation

Salary Payments

Staff scheduling

15 of 20

  • THIRD LEVEL DATAFLOW DIAGRAM

OFFICE ADMINISTRATION

INWARD ITEMS

TO STORES

​

Stock Maintenance

Library Management

Other Activities

Library

16 of 20

���������E-R DIAGRAMS

17 of 20

Student

Registration

studid

Student name

Fathername

occupation

DOB

Registration Fee

Remarks

Class

Administration

​

Classid

classname

studid

studname

admissionFee

Starting date

endingdate

noofworkingdays

extracharges

sno

Classregister

classid

Admissionfee

Installmentpay

classname

18 of 20

Attendance

NoOfWorking Days

NoOfDays Attended

Remarks

ClassId

StudId

Month

Sno

ClassRegister

Feestructure

ExamId

ExamFee

ClassName

TypeOfExam

ClassId

19 of 20

Sno

Remarks

Hindi

Average

Other

Social

Telugu

StudId

English

Maths

StudName

ClassId

Percentage

Totmarks

PerformanceList

StudentRegistration

ExamFeePayments

StudId

ExamId

ExamFee

Sno

ClassId

TypeOfExam

MonthlyInstallments

StudId

Sno

InstallmentPayDate

ClassId

InstallmentAmount

20 of 20

Recruit_Applications

Address

Appno

Postappliedfor

Appl_Namee

AppliedDate

SalaryExpected

Qualification

Recruit_Confirm

Appno

TeacherCode

Address

TeacherId

Appl_Name

Doj

Salary

Designation

TeachersMaster

Description

TeacherId