Database tables for School Management System describes the different types of tables that are typically included in a database for a school management system. These tables are used to store and organize information related to the school’s students, teachers, classes, and other aspects of school management.
The first table mentioned is the “Students” table, which contains information about each student, such as their name, ID number, address, contact information, and enrollment status.
The “Teachers” table contains information about the school’s teachers, including their name, ID number, subject(s) taught, and contact information. The “Classes” table contains information about the classes offered at the school, including the class name, ID number, teacher assigned, and list of students enrolled in the class.
The “Enrollments” table keeps track of which classes each student is enrolled in and links the class ID and student ID. The “Users” table is to track the system’s users, including their login credentials and user type, such as administrator, teacher, student.
The “Attendance” table keeps track of student attendance, including the date, class, and students who were present or absent. The “Grades” table contains information about student grades, including the class, assignment, and grade received.
The “Billing” table contains information about student billing and payments, including the student ID, billing amount, and payment history. The “Events” table contains information about school events, such as the name, date, location, and attendees. Finally, the “Resources” table contains information about school resources, such as name, location, and availability.
Database tables for School Management System Student Registration :
Table No: 1 Table Name STDRegistration Attribute name Data type Constraint Sample value AdmissionNo Int Primary key 1 FullName varchar(50) Not-null Siddartha.k Gender varchar(50) Not-null male DOB varchar(30) Not-null 17/01/1990 Class varchar(50) Not-null 2nd Password varchar(50) Not-null siddu PermanentAdd varchar(50) Not-null H-no:1-8-547, balasamudram, hanamkonda warangal-506001 CorrespondenceAdd varchar(50) Not-null H-no:1-8-547, balasamudram, hanamkonda warangal-506001 TelNos varchar(50) Not-null 0870-2569514 Fname varchar(50) Not-null k.prabhakar Qualification varchar(50) Not-null degree Occupation varchar(50) Not-null Bank manager Mbnum Numeric(18) Not-null 9441085465 Address varchar(50) Not-null H-no:1-8-547, balasamudram, hanamkonda warangal-506001 Emailid varchar(50) Not-null [email protected]
Attribute name Data type Constraint Sample value AdmissionNo Int Primary key 1 FullName varchar(50) Not-null Siddartha.k Gender varchar(50) Not-null male DOB varchar(30) Not-null 17/01/1990 Class varchar(50) Not-null 2nd Password varchar(50) Not-null siddu
Attribute name Data type Constraint Sample value AdmissionNo Int Primary key 1 PermanentAdd varchar(50) Not-null H-no:1-8-547, balasamudram, hanamkonda warangal-506001 CorrespondenceAdd varchar(50) Not-null H-no:1-8-547, balasamudram, hanamkonda warangal-506001
Attribute name Data type Constraint Sample value AdmissionNo Int Primary key 1 Fname varchar(50) Not-null k.prabhakar Qualification varchar(50) Not-null degree Mbnum Numeric(18) Not-null 9441085465 TelNos varchar(50) Not-null 0870-2569514 Emailid varchar(50) Not-null [email protected]
Marks:
Table No: 2 Table Name Marks Attribute name Data types constraints Sample values MarksID Int Primary key 1 name varchar(50) Not-null Siddartha.k admissionno varchar(50) Foreign key 1 class varchar(50) Not-null 2nd rollno Int Not-null 1 testname varchar(50) Not-null unit test-1 english varchar(50) Not-null 46 telugu varchar(50) Not-null 44 hindi varchar(50) Not-null 45 science varchar(50) Not-null 39 maths varchar(50) Not-null 50 social varchar(50) Not-null 44
Attribute name Data types constraints Sample values MarksID Int Primary key 1 name varchar(50) Not-null Siddartha.k admissionno varchar(50) Foreign key 1 class varchar(50) Not-null 2nd rollno Int Not-null 1 testname varchar(50) Not-null unit test-1
Attribute name Data types constraints Sample values MarksID Int Primary key 1 english varchar(50) Not-null 46 telugu varchar(50) Not-null 44 hindi varchar(50) Not-null 45 science varchar(50) Not-null 39 maths varchar(50) Not-null 50 social varchar(50) Not-null 44
Assignments:
Table No: 3 Table Name Assignments Attribute name Data types constraints Sample values assignmentsid Int Primary key 1 admissionno Int Foreign key 1 rollno Int Not-null 1 class varchar(50) Not-null 2nd june Int Not-null All submitted july varchar(50) Not-null All submitted august varchar(50) Not-null All submitted september varchar(50) Not-null All submitted october varchar(50) Not-null All submitted november varchar(50) Not-null English,scoial not submitted december varchar(50) Not-null All submitted january varchar(50) Not-null All submitted february varchar(50) Not-null Maths not submitted march varchar(50) Not-null All submitted april varchar(50) Not-null All submitted
Attribute name Data types constraints Sample values assignmentsid Int Primary key 1 admissionno Int Foreign key 1 rollno Int Not-null 1 class varchar(50) Not-null 2nd
Attribute name Data types constraints Sample values assignmentsid Int Primary key 1 june Int Not-null All submitted july varchar(50) Not-null All submitted august varchar(50) Not-null All submitted september varchar(50) Not-null All submitted october varchar(50) Not-null All submitted november varchar(50) Not-null English,scoial not submitted december varchar(50) Not-null All submitted january varchar(50) Not-null All submitted february varchar(50) Not-null Maths not submitted march varchar(50) Not-null All submitted april varchar(50) Not-null All submitted
Attendance:
Table No: 4 Table Name Attendance Attribute name Data types constraints Sample values attendenceid Int Primary key 1 admissionno Int Foreign key 1 name varchar(50) Not-null Siddartha.k rollno Int Not-null 1 class varchar(50) Not-null 2nd june varchar(50) Not-null 56.00% july varchar(50) Not-null 76.40% august varchar(50) Not-null 88.22% september varchar(50) Not-null 56.66% october varchar(50) Not-null 99.00% november varchar(50) Not-null 88.72% december varchar(50) Not-null 76.32% january varchar(50) Not-null 91.22% february varchar(50) Not-null 76.66% march varchar(50) Not-null 22.34% april varchar(50) Not-null 68.81%
Attribute name Data types constraints Sample values attendenceid Int Primary key 1 admissionno Int Foreign key 1 name varchar(50) Not-null Siddartha.k rollno Int Not-null 1 class varchar(50) Not-null 2nd
Attribute name Data types constraints Sample values attendenceid Int Primary key 1 june varchar(50) Not-null 56.00% july varchar(50) Not-null 76.40% august varchar(50) Not-null 88.22% september varchar(50) Not-null 56.66% october varchar(50) Not-null 99.00% november varchar(50) Not-null 88.72% december varchar(50) Not-null 76.32% january varchar(50) Not-null 91.22% february varchar(50) Not-null 76.66% march varchar(50) Not-null 22.34% april varchar(50) Not-null 68.81%
Complaints:
Table No: 5 Table Name Complaints Attribute name Data types constraints Sample values Complaintid Int Primary key 1 admissionno Int Foreign key 1 name varchar(50) Not-null Siddartha.k rollno Int Not-null 1 class varchar(50) Not-null 2nd complaint varchar(50) Not-null Very good boy
Login table
Table No: 6 Table Name Login Attribute name Data types constraints Sample values username varchar(50) Primary key 1 password varchar(50) Not-null siddu
Refer Database design to download all project database tables.
Post navigation
