School Management System Project Database Design

School Management system Project Database Design in MSSQL. Its Sample Database Design for School Management system.Download School Management system Project Design.This will Help you How to create Database in MSSQL and you can find Free download Project Schema.

Description 

School Management system will help You to manage daily school activities like Student registration , Subject Assign Teachers with Subject , Teachers management , Student Grads, Student Exam , leave management system. we have Design Demo Database For complete School management ERP. You can Download Complete PDF 

School System Database Detail 

Tables

Class Rooms Grades Course Students Parent Student Classroom Attendance Exam Exam Type Exam Result Teacher Teacher Department Teacher Type Departments Table Courses Table Enrollments Table Assignments Table Exams Table ExamScores Table Library Table BorrowedBooks Table Fees Table

Colum Detail In Tables 

Students Table:

• StudentID (Primary Key) Must Be
• StudentFirstName
• StudentLastName
• StudentDateOfBirth
• StudentGender
• StudentAddress
• StudentPhoneNumber
• StudentEmail

Teachers Table:

• TeacherID (Primary Key)
• TeacherFirstName
• TeacherLastName
• TeacherDateOfBirth
• TeacherGender
• TeacherAddress
• TeacherPhoneNumber
• TeacherEmail

Courses Table:

• CourseID (Primary Key)
• CourseName
• Description

Classes Table:

• ClassID (Primary Key)
• ClassName
• TeacherID (Foreign Key referencing Teachers Table)

Enrollments Table:

• EnrollmentID (Primary Key)
• StudentID (Foreign Key referencing Students Table)
• ClassID (Foreign Key referencing Classes Table)
• EnrollmentDate

Grades Table:

• GradeID (Primary Key)
• EnrollmentID (Foreign Key referencing Enrollments Table)
• CourseID (Foreign Key referencing Courses Table)
• GradeValue

 

Download Now