T-SQL tests

project.sql

USE [test];
GO

IF OBJECT_ID (N'dbo.Enrollments', N'U') IS NOT NULL
DROP TABLE [dbo].[Enrollments]
GO
IF OBJECT_ID (N'dbo.Students', N'U') IS NOT NULL
DROP TABLE [dbo].[Students]
GO
IF OBJECT_ID (N'dbo.Courses', N'U') IS NOT NULL
DROP TABLE [dbo].[Courses]
GO

CREATE TABLE Students(
	Id int PRIMARY KEY,
	Full_Name nvarchar(255),
	Age int
);
CREATE TABLE Courses(
	Id int PRIMARY KEY,
	Course_Name nvarchar(255)
);
CREATE TABLE Enrollments(
	Id int PRIMARY KEY,
	Id_Course int,
	Id_Student int,
	CONSTRAINT FK_Courses FOREIGN KEY (Id_Course) REFERENCES dbo.Courses(Id),
	CONSTRAINT FK_Student FOREIGN KEY (Id_Student) REFERENCES dbo.Students(Id) 
);