School Database Management System

School School database database management management system system Store all the records about school management system

School management database system • • • • • • •

Data about students Data about teacher’s Data about departments Data about sports Data about complaint department Data about medical case Data about student results

Data students tableabout data about students store • In this information of students like name ,id ,class, section,Incharge • In Incharge field store Incharge name of student that relate from teachers table . • Store about student name and id and class • Store about student section which belong science section or arts section.

Data about teacher’s • Store information about teachers in teacher table , teacher name ,ssn ,qualification, experience,address,contact email, phone number, assign section. • In one fields store assign section that relate with student table. • And other field’s store about teacher qualification and experience • Store about contact email and address in different fields in teacher table

Data about department • Store in one table data bout department department name ,special code ,head of department ,science section arts section • Science and arts section relate with teacher,s table to assign section • And store in other fields department name and special code and hod name

Data about sports • Store information about sports student’s like student age and student require class and name of student and his game. • special these two attribute relate with student table student require age and student class . • And other fields store info about student name and student game

Data about complaints • In this table store information complaints about teacher’s and student’s and name of student and teacher and complaint number • Teacher complaint section relate with teacher’s and student’s with student table store about complaint name and id and section. • And other fields store about unique complaint number

Data about students results • Student’s result table store information about student name ,id ,section ,subject ,grade. • Store all information in different fields but this section relate with department section name of student’s