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

Home/ Database tables for School Management System

Database tables for School Management System

StudentProjects.Live December 27, 2020 Project Ideas 0 Comments 2 views

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	2^nd
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	2^nd

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	2^nd
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	2^nd

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	2^nd
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

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