School management system

Introduction,problem definition, scope, objective, Funtional non functional requirement, modules, relational schema

1. School Management System

2. Introduction Education system form the backbone of every nation. It is necessary to provide a strong educational foundation base. Advanced technology can play an important role in streamlining education-related processes to ensure better communication among students, teachers, parents and the school staff.

3. Overview of Presentation Introduction Introduction to school management system Problem definition Objectives Scope for Work Functional requirements Non functional requirements Modules ERD diagram Relational Schema (Table Design) SQL queries (screenshots) Advantages

4. Introduction to School Management System School management system is a large database system which is used for managing school’s daily routine work. It is designed to meet a most individual school needs. Our School Management System consists of administrative details, student details, employee details, fees details, salary details and parent portal.

5. Problem Definition Student Attendance Time Wastage Student Monitoring Maintains Problem Forecasting the academic achievement Staff management School Administration Lake of communication between teachers and parents

6. Objective And Description It is designed for better interaction between students, teachers, parents and management. This management software very greatly handles all the requirements for easy school management. Maintaining student details and information, registering students, employee and teacher’s information Giving Access to parents to view their children information regarding their performance. Enabling employees, admin and parents to stay in touch with each other.

7. Scope for Work The purpose is to make people life easier. This project is used to manage the school system and will organize the work inside the school and will perform the following task Student information management Fees management Salary management Staff information management Administration management Employee information management Management of parent portal Attendance

8. Functional Requirements • Hardware requirements Processor Ram Hard disk Internet connection • Software requirements Operating system(Windows, Linux ,Mac ) Database Server Oracle Compatible Browser

9. Non-Functional Requirements • The system should be easy to use . • The system should be available 24 hour. • The system should response at the time • System should provide specific information to specific user. • The system should not fail. • Right information is available to right student and teacher at right time.

10. Modules: • Admin : Can view and access all information, including salary of employees, parents portal. • Teachers: They have access and can edit information regarding their respective classes/students. • Employees: Can access/edit information relevant to their particular jobs. • Parents: Can view all relevant information. • Students: Can view there fees and attendance. • Fees : Management of students fees. • Salary: Salary of employees is maintained.

11. Relational Schema teacher ATTENDANCE Att_ID(PK) stu_ID(FK) date time 001 1001 11-11-18 11:00 AM 002 1002 12-11-18 12:00 AM 003 1003 13-11-18 9:00 AM 004 1004 14-11-18 10:00 AM 005 1005 15-11-18 11:00 AM Tea_ID(PK) name email mobile 1234 Sara sara300 054312 1235 Nida nida301 052010 1236 Rida rida302 051200 1237 Aliya aliya303 055321 1238 Maira maira304 051110

12. Par_ID (PK) name tea_id(FK) stu_ID(FK) mobile email 300 Asma 1234 1001 9212345 asma.10 302 Amna 1235 1002 9234567 amna.12 302 Hamid 1236 1003 9212457 hamid11 303 Rabia 1237 1004 9200450 rabia56 304 Mohid 1238 1005 9212560 mohid78 Fees Fees_ID(PK) stu_ID(FK) amount date 100 1001 2000 24-11-18 101 1002 2500 28-11-18 102 1003 2500 1-12-18 103 1004 2000 5-12-18 104 1005 2500 20-12-18 Parents PORTAL

13. adm_ID(PK) name email mobile designation 111 Aliya Aliya12 9245678 Manager 222 Uzma Uzma13 9200100 Clerk 333 Arsala Arsala14 9234009 Adm Controller 444 Bushra Bush15 9234780 Coordinator 555 Beenish Bnsh16 9213447 Financial Controller stu_ID (PK) name address class mobile email 1001 Samra B-45, street1 1-A 051-1245 samra01 1002 Hira B-46, street2 3-B 051-0050 hira02 1003 Maryam A-78, street3 6-C 051-4890 maym03 1004 Wafa A-40, street4 4-A 051-0009 wafa04 1005 Misbah C-10, street5 4-D 051-5600 misbah05 ADMIN STUDENT

14. emp_ID (PK) name email mobile address O31 Tahira tahira12 923460 A-18, sector1 032 Nargis nargis67 920060 C-13, sector 3 033 Aroosa aroosa00 927800 A-01, sector 9 034 Anmol anmol99 921490 A-03, sector4 035 Muqadsa muqadsa45 925670 B-89, sector 5 sal_ID (PK) emp_ID(FK) salary date 10100 031 2500 28-11-18 10200 032 2500 1-12-18 10300 033 2000 5-12-18 10400 034 2500 20-12-18 10500 035 3000 03-12-18 EMPLOYEE SALARY

15. SQL Queries Creation of Tables & Insertion of Data

16. Administration

17. Insertion of data

18. Employee

19. Fees

20. Insertion of data

21. Student

22. Insertion of data

23. Salary

24. Insertion of data

25. Parent Portal

26. Insertion of data

27. Teacher

28. Insertion of data

29. Attendance

30. Insertion of data

31. Advantages/ benefits Of Our System User friendly Fast access to database Less error More Storage Capacity Search facility Efficient Flexible system to adopt any kind of changes

32. Thank You!