Scribd
Upload
866 views8 pages

School Database Management System Overview

This document describes the tables in a school management database system. It outlines 7 tables that store data about students, teachers, departments, sports, complaints, medical cases, and student results. Each table contains fields that relate to other tables through foreign keys to integrate the data across the different areas of school management.

Uploaded by

api-3840828
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
866 views8 pages

School Database Management System Overview

This document describes the tables in a school management database system. It outlines 7 tables that store data about students, teachers, departments, sports, complaints, medical cases, and student results. Each table contains fields that relate to other tables through foreign keys to integrate the data across the different areas of school management.

Uploaded by

api-3840828
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
  • Introduction to School Database Management System
  • School Management Database System Overview
  • Data about Students
  • Data about Teacher's
  • Data about Department
  • Data about Sports
  • Data about Complaints
  • Data about Student Results

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
• In this tableabout students
data about students store
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

School database School database management system management system School database School database management system
School management database system • Data about students • Data about teacher’s • Data about departments • Data about sports
Data about students • In this table data about students store information of students like name ,id ,class, section,Incharg
Data about teacher’s • Store information about teachers in teacher table , teacher name ,ssn ,qualification, experience,add
Data about department • Store in one table data bout department department name ,special code ,head of department ,science
Data about sports • Store information about sports student’s like student age and student require class and name of student
Data about complaints • In this table store information complaints about teacher’s and student’s and name of student and te
Data about students results • Student’s result table store information about student name ,id ,section ,subject ,grade. •

You might also like