Here I will show you how you can create Database and Table in sql server for school management system.

Steps:

Step-1: create Database & tables   in SQL Server.

• Go to SQL Server 2014 > Click New Query Button>   with writing the below highlight code.
• Open Sql Server managment studio for running your sql server database and  table creation codes.

create database dbStudentMangeSystem
go
use dbStudentMangeSystem
go
 


create table tblBatch(
BatchId int Identity primary key,
BatchName nvarchar(max)
)

create table tblSection(
SectionId int Identity primary key,
SectionName nvarchar(max),
BatchId int,
foreign key (BatchId) references tblBatch(BatchId)
)

create table tblCourse(
CourseId int Identity primary key,
CourseName nvarchar(max),
BatchId int,
SectionId int,
foreign key (BatchId) references tblBatch(BatchId),
foreign key (SectionId) references tblSection(SectionId)
)

create table tblTrimesterInfo(
TrimesterInfoId  int Identity primary key,
TrimesterInfoName nvarchar(max)
)



create table tblStudent(
StudentId int Identity primary key,
StudentIdNO nvarchar(max),
BatchId int,
SectionId int,
DOB datetime,
Age decimal(18,2),
Gender  nvarchar(max),
Religion  nvarchar(max),
Image  nvarchar(max),
FatherName  nvarchar(max),
MotherName  nvarchar(max),
PresentAddrees  nvarchar(max),
PermanentAddress  nvarchar(max),
AddmittedDate datetime,
Status bit,
foreign key (BatchId) references tblBatch(BatchId),
foreign key (SectionId) references tblSection(SectionId)
)



create table tblStudentCourseOffer(
StudentCourseOfferId  int Identity primary key,
CourseId int,
TrimesterInfoId int,
StudentId int,
CourseOfferDate datetime,
foreign key (CourseId) references tblCourse(CourseId),
foreign key (TrimesterInfoId) references tblTrimesterInfo(TrimesterInfoId)

)


create table tblStudentMarksEntry(
StudentMarksEntryId int Identity primary key,
CourseId int,
TrimesterInfoId int,
StudentId int,
Marks decimal(18,2),
MarksOutOf  decimal(18,2),
foreign key (CourseId) references tblCourse(CourseId),
foreign key (TrimesterInfoId) references tblTrimesterInfo(TrimesterInfoId),
foreign key (StudentId) references tblStudent(StudentId)

)



create table tblNoticeBoard(
NoticeBoardId  int Identity primary key,
NoticeBoardSubject nvarchar(max),
Description  nvarchar(max),
CreatedDate datetime
)


create table tblUser(
UserId  int Identity primary key,
UserName nvarchar(max),
LoginName nvarchar(max),
Password nvarchar(max),
UserType nvarchar(max)
)

• Press ctrl+f5 for Execute Query in sql server managment studio