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
• DateOfBirth
• ParentID (Foreign Key referencing Parent.ParentID)
• ClassroomID (Foreign Key referencing Classrooms.ClassroomID)

Teachers Table:

• TeacherID (Primary Key)
• TeacherFirstName
• TeacherLastName
• TeacherDateOfBirth
• TeacherGender
• TeacherAddress
• TeacherPhoneNumber
• TeacherEmail
• DepartmentID (Foreign Key referencing Departments.DepartmentID)
• TeacherTypeID (Foreign Key referencing TeacherType.TeacherTypeID)

Courses Table:

• CourseID (Primary Key)
• CourseName
• Description
• TeacherID (Foreign Key referencing Teacher.TeacherID)
• DepartmentID (Foreign Key referencing Departments.DepartmentID)

StudentClassroom Table:

• TeacherID (Foreign Key referencing Teachers Table)
• StudentClassroomID (Primary Key)
• StudentID (Foreign Key referencing Students.StudentID)
• ClassroomID (Foreign Key referencing Classrooms.ClassroomID)
• EnrollmentDate
•  

Enrollments Table:

• EnrollmentID (Primary Key)
• StudentID (Foreign Key referencing Students.StudentID)
• CourseID (Foreign Key referencing Courses.CourseID)
• EnrollmentDate

Grades Table:

• GradeID (Primary Key)
• GradeName

Classrooms Table

• ClassroomID (Primary Key)
• ClassroomName
• GradeID (Foreign Key referencing Grades.GradeID)
• TeacherID (Foreign Key referencing Teacher.TeacherID)

Parents Table

• ParentID (Primary Key)
• FirstName
• LastName
• PhoneNumber
• Email

StudentClassroom Table

• StudentClassroomID (Primary Key)
• StudentID (Foreign Key referencing Students.StudentID)
• ClassroomID (Foreign Key referencing Classrooms.ClassroomID)
• EnrollmentDate

Attendance Table

• AttendanceID (Primary Key)
• StudentID (Foreign Key referencing Students.StudentID)
• ClassroomID (Foreign Key referencing Classrooms.ClassroomID)
• Date
• Status (e.g., Present, Absent)

Exam Table

• ExamID (Primary Key)
• ExamName
• CourseID (Foreign Key referencing Courses.CourseID)
• ExamTypeID (Foreign Key referencing ExamType.ExamTypeID)
• Date

ExamType Table

• ExamTypeID (Primary Key)
• TypeName (e.g., Midterm, Final, Quiz)

ExamResult Table

• ExamResultID (Primary Key)
• StudentID (Foreign Key referencing Students.StudentID)
• ExamID (Foreign Key referencing Exam.ExamID)
• Score

TeacherDepartment Table

• DepartmentID (Primary Key)
• DepartmentName

TeacherType Table

• TeacherTypeID (Primary Key)
• TypeName (e.g., Full-time, Part-time)

Departments Table

• DepartmentID (Primary Key)
• DepartmentName

Assignments Table

• AssignmentID (Primary Key)
• AssignmentName
• CourseID (Foreign Key referencing Courses.CourseID)
• DueDate

Exams Table

• ExamID (Primary Key)
• CourseID (Foreign Key referencing Courses.CourseID)
• ExamTypeID (Foreign Key referencing ExamType.ExamTypeID)
• Date

ExamScores Table

• ExamScoreID (Primary Key)
• ExamID (Foreign Key referencing Exam.ExamID)
• StudentID (Foreign Key referencing Students.StudentID)
• Score

Library Table

• LibraryID (Primary Key)
• BookTitle
• Author
• ISBN
• Quantity

BorrowedBooks Table

• BorrowID (Primary Key)
• StudentID (Foreign Key referencing Students.StudentID)
• LibraryID (Foreign Key referencing Library.LibraryID)
• BorrowDate
• ReturnDate

Fees Table

• FeeID (Primary Key)
• StudentID (Foreign Key referencing Students.StudentID)
• Amount
• DueDate
• PaidDate

Relationships

• Classrooms and Grades: ClassroomID references GradeID.
• Classrooms and Teachers: Each classroom is associated with a teacher using TeacherID.
• Students and Parents: Each student has a parent associated using ParentID.
• StudentClassroom: Relates students and classrooms (many-to-many), creating a record for each student enrolled in a specific classroom.
• Attendance: Tracks the attendance of students for each classroom.
• Courses and Teachers: Each course is taught by a teacher, linked through TeacherID.
• Courses and Departments: Each course belongs to a department.
• Exams: Each exam is associated with a course and an exam type.
• Exam Results: Stores student scores for each exam.
• Assignments: Linked to courses.
• Library: Tracks books and their availability in the library.
• BorrowedBooks: Tracks which books are borrowed by students.
• Fees: Manages student fees and payment status.

Download Now