Register Now

Login

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Database tables for School Management System

Student  Registration:

Table No:1
Table NameSTDRegistration
Attribute nameData typeConstraintSample value
AdmissionNoIntPrimary key1
FullNamevarchar(50)Not-nullSiddartha.k
Gendervarchar(50)Not-nullmale
DOBvarchar(30)Not-null17/01/1990
Classvarchar(50)Not-null2nd
Passwordvarchar(50)Not-nullsiddu
PermanentAddvarchar(50)Not-nullH-no:1-8-547, balasamudram, hanamkonda warangal-506001
CorrespondenceAddvarchar(50)Not-nullH-no:1-8-547, balasamudram, hanamkonda warangal-506001
TelNosvarchar(50)Not-null0870-2569514
Fnamevarchar(50)Not-nullk.prabhakar
Qualificationvarchar(50)Not-nulldegree
Occupationvarchar(50)Not-nullBank manager
MbnumNumeric(18)Not-null9441085465
Addressvarchar(50)Not-nullH-no:1-8-547, balasamudram, hanamkonda warangal-506001
Emailidvarchar(50)Not-null[email protected]
Attribute nameData typeConstraintSample value
AdmissionNoIntPrimary key1
FullNamevarchar(50)Not-nullSiddartha.k
Gendervarchar(50)Not-nullmale
DOBvarchar(30)Not-null17/01/1990
Classvarchar(50)Not-null2nd
Passwordvarchar(50)Not-nullsiddu
Attribute nameData typeConstraintSample value
AdmissionNoIntPrimary key1
PermanentAddvarchar(50)Not-nullH-no:1-8-547, balasamudram, hanamkonda warangal-506001
CorrespondenceAddvarchar(50)Not-nullH-no:1-8-547, balasamudram, hanamkonda warangal-506001
Attribute nameData typeConstraintSample value
AdmissionNoIntPrimary key1
Fnamevarchar(50)Not-nullk.prabhakar
Qualificationvarchar(50)Not-nulldegree
MbnumNumeric(18)Not-null9441085465
TelNosvarchar(50)Not-null0870-2569514
Emailidvarchar(50)Not-null[email protected]

Marks:

Table No:2
Table NameMarks
Attribute nameData typesconstraintsSample values
MarksIDIntPrimary key1
namevarchar(50)Not-nullSiddartha.k
admissionnovarchar(50)Foreign key1
classvarchar(50)Not-null2nd
rollnoIntNot-null1
testnamevarchar(50)Not-nullunit test-1
englishvarchar(50)Not-null46
teluguvarchar(50)Not-null44
hindivarchar(50)Not-null45
sciencevarchar(50)Not-null39
mathsvarchar(50)Not-null50
socialvarchar(50)Not-null44
Attribute nameData typesconstraintsSample values
MarksIDIntPrimary key1
namevarchar(50)Not-nullSiddartha.k
admissionnovarchar(50)Foreign key1
classvarchar(50)Not-null2nd
rollnoIntNot-null1
testnamevarchar(50)Not-nullunit test-1
Attribute nameData typesconstraintsSample values
MarksIDIntPrimary key1
englishvarchar(50)Not-null46
teluguvarchar(50)Not-null44
hindivarchar(50)Not-null45
sciencevarchar(50)Not-null39
mathsvarchar(50)Not-null50
socialvarchar(50)Not-null44

Assignments:

Table No:3
Table NameAssignments
Attribute nameData typesconstraintsSample values
assignmentsidIntPrimary key1
admissionnoIntForeign key1
rollnoIntNot-null1
classvarchar(50)Not-null2nd
juneIntNot-nullAll submitted
julyvarchar(50)Not-nullAll submitted
augustvarchar(50)Not-nullAll submitted
septembervarchar(50)Not-nullAll submitted
octobervarchar(50)Not-nullAll submitted
novembervarchar(50)Not-nullEnglish,scoial not submitted
decembervarchar(50)Not-nullAll submitted
januaryvarchar(50)Not-nullAll submitted
februaryvarchar(50)Not-nullMaths not submitted
marchvarchar(50)Not-nullAll submitted
aprilvarchar(50)Not-nullAll submitted
Attribute nameData typesconstraintsSample values
assignmentsidIntPrimary key1
admissionnoIntForeign key1
rollnoIntNot-null1
classvarchar(50)Not-null2nd
Attribute nameData typesconstraintsSample values
assignmentsidIntPrimary key1
juneIntNot-nullAll submitted
julyvarchar(50)Not-nullAll submitted
augustvarchar(50)Not-nullAll submitted
septembervarchar(50)Not-nullAll submitted
octobervarchar(50)Not-nullAll submitted
novembervarchar(50)Not-nullEnglish,scoial not submitted
decembervarchar(50)Not-nullAll submitted
januaryvarchar(50)Not-nullAll submitted
februaryvarchar(50)Not-nullMaths not submitted
marchvarchar(50)Not-nullAll submitted
aprilvarchar(50)Not-nullAll submitted

Attendance:

Table No:4
Table NameAttendance
Attribute nameData typesconstraintsSample values
attendenceidIntPrimary key1
admissionnoIntForeign key1
namevarchar(50)Not-nullSiddartha.k
rollnoIntNot-null1
classvarchar(50)Not-null2nd
junevarchar(50)Not-null56.00%
julyvarchar(50)Not-null76.40%
augustvarchar(50)Not-null88.22%
septembervarchar(50)Not-null56.66%
octobervarchar(50)Not-null99.00%
novembervarchar(50)Not-null88.72%
decembervarchar(50)Not-null76.32%
januaryvarchar(50)Not-null91.22%
februaryvarchar(50)Not-null76.66%
marchvarchar(50)Not-null22.34%
aprilvarchar(50)Not-null68.81%
Attribute nameData typesconstraintsSample values
attendenceidIntPrimary key1
admissionnoIntForeign key1
namevarchar(50)Not-nullSiddartha.k
rollnoIntNot-null1
classvarchar(50)Not-null2nd
Attribute nameData typesconstraintsSample values
attendenceidIntPrimary key1
junevarchar(50)Not-null56.00%
julyvarchar(50)Not-null76.40%
augustvarchar(50)Not-null88.22%
septembervarchar(50)Not-null56.66%
octobervarchar(50)Not-null99.00%
novembervarchar(50)Not-null88.72%
decembervarchar(50)Not-null76.32%
januaryvarchar(50)Not-null91.22%
februaryvarchar(50)Not-null76.66%
marchvarchar(50)Not-null22.34%
aprilvarchar(50)Not-null68.81%

Complaints:

Table No:5
Table NameComplaints
Attribute nameData typesconstraintsSample values
ComplaintidIntPrimary key1
admissionnoIntForeign key1
namevarchar(50)Not-nullSiddartha.k
rollnoIntNot-null1
classvarchar(50)Not-null2nd
complaintvarchar(50)Not-nullVery good boy

Login table

Table No:6
Table NameLogin
Attribute nameData typesconstraintsSample values
usernamevarchar(50)Primary key1
passwordvarchar(50)Not-nullsiddu

Leave a reply

About StudentProjects.Live

A collection of source codes that I wrote in Android, ASP.NET, PHP, C#.NET, VB.NET and JAVA in a course of my career as web developer and software engineer that I would like to share to my fellow programmers. Some of the codes here is not my original work that I found over the Internet and Books while I'm learning how to program. I hope you find my work useful in your learning in programming. Please share my work to other people also who interested to learn the basics of web development and programming. Thank you very much and Happy Productive Programming Everyone.

Follow Me