Backup_BD.sql

USE [master]
GO
/****** Object:  Database [Examene si proiecte]    Script Date: 22-Jan-26 9:20:30 PM ******/
CREATE DATABASE [Examene si proiecte]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'Examene si proiecte', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\Examene si proiecte.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'Examene si proiecte_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\DATA\Examene si proiecte_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
 WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF
GO
ALTER DATABASE [Examene si proiecte] SET COMPATIBILITY_LEVEL = 160
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Examene si proiecte].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Examene si proiecte] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [Examene si proiecte] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [Examene si proiecte] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [Examene si proiecte] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [Examene si proiecte] SET ARITHABORT OFF 
GO
ALTER DATABASE [Examene si proiecte] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [Examene si proiecte] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [Examene si proiecte] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [Examene si proiecte] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [Examene si proiecte] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [Examene si proiecte] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [Examene si proiecte] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [Examene si proiecte] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [Examene si proiecte] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [Examene si proiecte] SET  DISABLE_BROKER 
GO
ALTER DATABASE [Examene si proiecte] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [Examene si proiecte] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [Examene si proiecte] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [Examene si proiecte] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [Examene si proiecte] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [Examene si proiecte] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [Examene si proiecte] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [Examene si proiecte] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [Examene si proiecte] SET  MULTI_USER 
GO
ALTER DATABASE [Examene si proiecte] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [Examene si proiecte] SET DB_CHAINING OFF 
GO
ALTER DATABASE [Examene si proiecte] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [Examene si proiecte] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO
ALTER DATABASE [Examene si proiecte] SET DELAYED_DURABILITY = DISABLED 
GO
ALTER DATABASE [Examene si proiecte] SET ACCELERATED_DATABASE_RECOVERY = OFF  
GO
ALTER DATABASE [Examene si proiecte] SET QUERY_STORE = ON
GO
ALTER DATABASE [Examene si proiecte] SET QUERY_STORE (OPERATION_MODE = READ_WRITE, CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 30), DATA_FLUSH_INTERVAL_SECONDS = 900, INTERVAL_LENGTH_MINUTES = 60, MAX_STORAGE_SIZE_MB = 1000, QUERY_CAPTURE_MODE = AUTO, SIZE_BASED_CLEANUP_MODE = AUTO, MAX_PLANS_PER_QUERY = 200, WAIT_STATS_CAPTURE_MODE = ON)
GO
USE [Examene si proiecte]
GO
/****** Object:  Table [dbo].[Examen]    Script Date: 22-Jan-26 9:20:30 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Examen](
	[IDExamen] [int] IDENTITY(1,1) NOT NULL,
	[Data] [date] NOT NULL,
	[Ora] [time](7) NOT NULL,
	[Durata] [int] NULL,
	[Sesiune] [varchar](50) NOT NULL,
	[Tip] [varchar](20) NULL,
	[IDMaterie] [int] NOT NULL,
	[IDSala] [int] NULL,
 CONSTRAINT [PK_Examen] PRIMARY KEY CLUSTERED 
(
	[IDExamen] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Materie]    Script Date: 22-Jan-26 9:20:30 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Materie](
	[IDMaterie] [int] IDENTITY(1,1) NOT NULL,
	[Nume] [varchar](100) NOT NULL,
	[AnStudiu] [int] NOT NULL,
	[Semestru] [int] NULL,
	[NumarCredite] [int] NULL,
	[IDProfesor] [int] NOT NULL,
 CONSTRAINT [PK_Materie] PRIMARY KEY CLUSTERED 
(
	[IDMaterie] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Profesor]    Script Date: 22-Jan-26 9:20:30 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Profesor](
	[IDProfesor] [int] IDENTITY(1,1) NOT NULL,
	[Nume] [varchar](50) NOT NULL,
	[Prenume] [varchar](50) NOT NULL,
	[Email] [varchar](100) NULL,
	[Parola] [varchar](255) NOT NULL,
	[Departament] [varchar](100) NULL,
	[Telefon] [varchar](20) NULL,
 CONSTRAINT [PK_Profesor] PRIMARY KEY CLUSTERED 
(
	[IDProfesor] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Proiect]    Script Date: 22-Jan-26 9:20:30 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Proiect](
	[IDProiect] [int] IDENTITY(1,1) NOT NULL,
	[Titlu] [varchar](200) NOT NULL,
	[Descriere] [text] NULL,
	[Deadline] [date] NOT NULL,
	[Cerinte] [text] NULL,
	[IDMaterie] [int] NOT NULL,
 CONSTRAINT [PK_Proiect] PRIMARY KEY CLUSTERED 
(
	[IDProiect] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Sala]    Script Date: 22-Jan-26 9:20:30 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sala](
	[IDSala] [int] IDENTITY(1,1) NOT NULL,
	[Cladire] [varchar](50) NOT NULL,
	[Etaj] [int] NULL,
	[Capacitate] [int] NULL,
	[CodSala] [varchar](20) NOT NULL,
 CONSTRAINT [PK_Sala] PRIMARY KEY CLUSTERED 
(
	[IDSala] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Student]    Script Date: 22-Jan-26 9:20:30 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Student](
	[IDStudent] [int] NOT NULL,
	[Nume] [varchar](50) NOT NULL,
	[Prenume] [varchar](50) NOT NULL,
	[Email] [varchar](100) NULL,
	[Parola] [varchar](255) NOT NULL,
	[AnStudiu] [int] NULL,
	[DataInregistrare] [datetime] NULL,
 CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED 
(
	[IDStudent] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[StudentExamen]    Script Date: 22-Jan-26 9:20:30 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StudentExamen](
	[IDStudent] [int] NOT NULL,
	[IDExamen] [int] NOT NULL,
	[Status] [varchar](20) NULL,
	[DataInscriere] [datetime] NULL,
	[DataSustinere] [date] NULL,
	[Nota] [decimal](4, 2) NULL,
 CONSTRAINT [PK_StudentExamen] PRIMARY KEY CLUSTERED 
(
	[IDStudent] ASC,
	[IDExamen] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[StudentProiect]    Script Date: 22-Jan-26 9:20:30 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StudentProiect](
	[IDStudent] [int] NOT NULL,
	[IDProiect] [int] NOT NULL,
	[Status] [varchar](20) NULL,
	[DataInscriere] [datetime] NULL,
	[DataPredare] [date] NULL,
	[Nota] [decimal](4, 2) NULL,
 CONSTRAINT [PK_StudentProiect] PRIMARY KEY CLUSTERED 
(
	[IDStudent] ASC,
	[IDProiect] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Examen] ON 

INSERT [dbo].[Examen] ([IDExamen], [Data], [Ora], [Durata], [Sesiune], [Tip], [IDMaterie], [IDSala]) VALUES (1, CAST(N'2025-01-20' AS Date), CAST(N'10:00:00' AS Time), 120, N'Iarna 2025', N'Final', 1, 2)
INSERT [dbo].[Examen] ([IDExamen], [Data], [Ora], [Durata], [Sesiune], [Tip], [IDMaterie], [IDSala]) VALUES (2, CAST(N'2025-01-15' AS Date), CAST(N'14:30:00' AS Time), 90, N'Iarna 2025', N'Partial', 2, 1)
INSERT [dbo].[Examen] ([IDExamen], [Data], [Ora], [Durata], [Sesiune], [Tip], [IDMaterie], [IDSala]) VALUES (3, CAST(N'2026-02-06' AS Date), CAST(N'09:00:00' AS Time), 180, N'Restante', N'Final', 3, 3)
INSERT [dbo].[Examen] ([IDExamen], [Data], [Ora], [Durata], [Sesiune], [Tip], [IDMaterie], [IDSala]) VALUES (4, CAST(N'2025-01-22' AS Date), CAST(N'12:00:00' AS Time), 150, N'Iarna 2025', N'Final', 4, 4)
INSERT [dbo].[Examen] ([IDExamen], [Data], [Ora], [Durata], [Sesiune], [Tip], [IDMaterie], [IDSala]) VALUES (5, CAST(N'2025-06-10' AS Date), CAST(N'16:00:00' AS Time), 120, N'Vara 2025', N'Final', 5, 5)
INSERT [dbo].[Examen] ([IDExamen], [Data], [Ora], [Durata], [Sesiune], [Tip], [IDMaterie], [IDSala]) VALUES (6, CAST(N'2025-01-18' AS Date), CAST(N'11:00:00' AS Time), 90, N'Iarna 2025', N'Partial', 6, 6)
INSERT [dbo].[Examen] ([IDExamen], [Data], [Ora], [Durata], [Sesiune], [Tip], [IDMaterie], [IDSala]) VALUES (1007, CAST(N'2026-06-10' AS Date), CAST(N'10:00:00' AS Time), 120, N'Vara 2026', N'Final', 3, 6)
INSERT [dbo].[Examen] ([IDExamen], [Data], [Ora], [Durata], [Sesiune], [Tip], [IDMaterie], [IDSala]) VALUES (1008, CAST(N'2026-01-28' AS Date), CAST(N'10:00:00' AS Time), 120, N'Iarna 2026', N'Final', 7, 1)
SET IDENTITY_INSERT [dbo].[Examen] OFF
GO
SET IDENTITY_INSERT [dbo].[Materie] ON 

INSERT [dbo].[Materie] ([IDMaterie], [Nume], [AnStudiu], [Semestru], [NumarCredite], [IDProfesor]) VALUES (1, N'Structuri de Date si Algoritmi', 2, 1, 6, 1)
INSERT [dbo].[Materie] ([IDMaterie], [Nume], [AnStudiu], [Semestru], [NumarCredite], [IDProfesor]) VALUES (2, N'Arhitectura Microprocesoarelor', 3, 1, 5, 2)
INSERT [dbo].[Materie] ([IDMaterie], [Nume], [AnStudiu], [Semestru], [NumarCredite], [IDProfesor]) VALUES (3, N'Programare Orientata Obiect', 1, 2, 6, 1)
INSERT [dbo].[Materie] ([IDMaterie], [Nume], [AnStudiu], [Semestru], [NumarCredite], [IDProfesor]) VALUES (4, N'Retele de Calculatoare', 3, 2, 6, 4)
INSERT [dbo].[Materie] ([IDMaterie], [Nume], [AnStudiu], [Semestru], [NumarCredite], [IDProfesor]) VALUES (5, N'Sisteme de Operare', 2, 2, 5, 3)
INSERT [dbo].[Materie] ([IDMaterie], [Nume], [AnStudiu], [Semestru], [NumarCredite], [IDProfesor]) VALUES (6, N'Inteligenta Artificiala', 4, 1, 6, 2)
INSERT [dbo].[Materie] ([IDMaterie], [Nume], [AnStudiu], [Semestru], [NumarCredite], [IDProfesor]) VALUES (7, N'Analiza Matematica', 1, 1, 5, 1)
INSERT [dbo].[Materie] ([IDMaterie], [Nume], [AnStudiu], [Semestru], [NumarCredite], [IDProfesor]) VALUES (8, N'Baze de Date', 3, 1, 5, 1)
INSERT [dbo].[Materie] ([IDMaterie], [Nume], [AnStudiu], [Semestru], [NumarCredite], [IDProfesor]) VALUES (9, N'Matematica', 1, 2, 6, 1)
SET IDENTITY_INSERT [dbo].[Materie] OFF
GO
SET IDENTITY_INSERT [dbo].[Profesor] ON 

INSERT [dbo].[Profesor] ([IDProfesor], [Nume], [Prenume], [Email], [Parola], [Departament], [Telefon]) VALUES (1, N'Popescu', N'Andrei', N'andrei.popescu@univ.ro', N'hash123', N'Informatica', N'0722111222')
INSERT [dbo].[Profesor] ([IDProfesor], [Nume], [Prenume], [Email], [Parola], [Departament], [Telefon]) VALUES (2, N'Ionescu', N'Maria', N'maria.ionescu@univ.ro', N'hash456', N'Matematica', N'0722333444')
INSERT [dbo].[Profesor] ([IDProfesor], [Nume], [Prenume], [Email], [Parola], [Departament], [Telefon]) VALUES (3, N'Vasilescu', N'George', N'george.vasi@univ.ro', N'hash789', N'Cibernetica', N'0722555666')
INSERT [dbo].[Profesor] ([IDProfesor], [Nume], [Prenume], [Email], [Parola], [Departament], [Telefon]) VALUES (4, N'Dumitru', N'Ana', N'ana.dum@univ.ro', N'hash011', N'Informatica', N'0722666777')
INSERT [dbo].[Profesor] ([IDProfesor], [Nume], [Prenume], [Email], [Parola], [Departament], [Telefon]) VALUES (5, N'Stoica', N'Mihai', N'mihai.stoica@univ.ro', N'hash022', N'Fizica', N'0722888999')
INSERT [dbo].[Profesor] ([IDProfesor], [Nume], [Prenume], [Email], [Parola], [Departament], [Telefon]) VALUES (6, N'Gliga', N'Irina', N'irina.gliga@univ.ro', N'hash033', N'Matematica', N'0722101121')
INSERT [dbo].[Profesor] ([IDProfesor], [Nume], [Prenume], [Email], [Parola], [Departament], [Telefon]) VALUES (9, N'alina', N'ion', N'alina.ion@gmail.com', N'alina', N'Informatica', N'0766192961')
SET IDENTITY_INSERT [dbo].[Profesor] OFF
GO
SET IDENTITY_INSERT [dbo].[Proiect] ON 

INSERT [dbo].[Proiect] ([IDProiect], [Titlu], [Descriere], [Deadline], [Cerinte], [IDMaterie]) VALUES (1, N'Implementare Heap & Sort', N'Implementarea eficienta a structurii Heap si a algoritmilor de sortare.', CAST(N'2026-01-25' AS Date), N'Complexitate O(n log n)', 1)
INSERT [dbo].[Proiect] ([IDProiect], [Titlu], [Descriere], [Deadline], [Cerinte], [IDMaterie]) VALUES (2, N'Simulator de set de instructiuni', N'Dezvoltarea unui simulator simplu pentru un set de instructiuni MIPS.', CAST(N'2025-05-15' AS Date), N'Interfata CLI cu registri vizibili', 2)
INSERT [dbo].[Proiect] ([IDProiect], [Titlu], [Descriere], [Deadline], [Cerinte], [IDMaterie]) VALUES (3, N'Aplicatie CRUD in C++', N'Descriere neschimbata', CAST(N'2026-01-30' AS Date), N'Utilizarea unui design pattern (ex: MVC)', 3)
INSERT [dbo].[Proiect] ([IDProiect], [Titlu], [Descriere], [Deadline], [Cerinte], [IDMaterie]) VALUES (4, N'Protocol de Routing', N'Implementarea unui protocol simplu de routing (ex: Distance Vector).', CAST(N'2025-06-01' AS Date), N'Simularea a 5 noduri in Python', 4)
INSERT [dbo].[Proiect] ([IDProiect], [Titlu], [Descriere], [Deadline], [Cerinte], [IDMaterie]) VALUES (5, N'Shell Custom', N'Dezvoltarea unui interpretor de comenzi (shell) simplu in C.', CAST(N'2025-05-20' AS Date), N'Pipe-uri si redirectionare I/O', 5)
INSERT [dbo].[Proiect] ([IDProiect], [Titlu], [Descriere], [Deadline], [Cerinte], [IDMaterie]) VALUES (6, N'Retea Neurala pentru Clasificare', N'Antrenarea unei retele simple pentru clasificarea imaginilor (ex: MNIST).', CAST(N'2025-01-28' AS Date), N'Raport de acuratete > 90%', 6)
INSERT [dbo].[Proiect] ([IDProiect], [Titlu], [Descriere], [Deadline], [Cerinte], [IDMaterie]) VALUES (7, N'Retea Neurala pentru Clasificare', N'Antrenarea unei retele simple pentru clasificarea imaginilor (ex: MNIST).', CAST(N'2025-01-28' AS Date), N'Standard', 6)
INSERT [dbo].[Proiect] ([IDProiect], [Titlu], [Descriere], [Deadline], [Cerinte], [IDMaterie]) VALUES (1019, N'Proiect test', N'descriere', CAST(N'2026-01-22' AS Date), N'cerinte', 1)
INSERT [dbo].[Proiect] ([IDProiect], [Titlu], [Descriere], [Deadline], [Cerinte], [IDMaterie]) VALUES (1020, N'Integrale Definite', N'rezolvare 100 de integrale', CAST(N'2026-05-15' AS Date), N'', 7)
SET IDENTITY_INSERT [dbo].[Proiect] OFF
GO
SET IDENTITY_INSERT [dbo].[Sala] ON 

INSERT [dbo].[Sala] ([IDSala], [Cladire], [Etaj], [Capacitate], [CodSala]) VALUES (1, N'Corp A', 1, 50, N'A100')
INSERT [dbo].[Sala] ([IDSala], [Cladire], [Etaj], [Capacitate], [CodSala]) VALUES (2, N'Corp C', 3, 100, N'C300')
INSERT [dbo].[Sala] ([IDSala], [Cladire], [Etaj], [Capacitate], [CodSala]) VALUES (3, N'Corp B', 0, 200, N'Amf. B')
INSERT [dbo].[Sala] ([IDSala], [Cladire], [Etaj], [Capacitate], [CodSala]) VALUES (4, N'Corp C', 3, 45, N'C301')
INSERT [dbo].[Sala] ([IDSala], [Cladire], [Etaj], [Capacitate], [CodSala]) VALUES (5, N'Corp B', 2, 70, N'B205')
INSERT [dbo].[Sala] ([IDSala], [Cladire], [Etaj], [Capacitate], [CodSala]) VALUES (6, N'Corp A', 1, 30, N'A105')
INSERT [dbo].[Sala] ([IDSala], [Cladire], [Etaj], [Capacitate], [CodSala]) VALUES (7, N'Corp C', 1, 30, N'C100')
SET IDENTITY_INSERT [dbo].[Sala] OFF
GO
INSERT [dbo].[Student] ([IDStudent], [Nume], [Prenume], [Email], [Parola], [AnStudiu], [DataInregistrare]) VALUES (1, N'Radu', N'Ana', N'ana.radu@stud.ro', N'student1', 3, CAST(N'2025-11-14T22:15:58.297' AS DateTime))
INSERT [dbo].[Student] ([IDStudent], [Nume], [Prenume], [Email], [Parola], [AnStudiu], [DataInregistrare]) VALUES (2, N'Popa', N'Ionut', N'ionut.popa@stud.ro', N'student2', 1, CAST(N'2025-11-14T22:15:58.297' AS DateTime))
INSERT [dbo].[Student] ([IDStudent], [Nume], [Prenume], [Email], [Parola], [AnStudiu], [DataInregistrare]) VALUES (3, N'Gheorghe', N'Cristina', N'cristina.g@stud.ro', N'student3', 4, CAST(N'2025-11-14T22:15:58.297' AS DateTime))
INSERT [dbo].[Student] ([IDStudent], [Nume], [Prenume], [Email], [Parola], [AnStudiu], [DataInregistrare]) VALUES (4, N'Marin', N'Alexandru', N'alex.marin@stud.ro', N'student4', 3, CAST(N'2025-11-14T22:15:58.297' AS DateTime))
INSERT [dbo].[Student] ([IDStudent], [Nume], [Prenume], [Email], [Parola], [AnStudiu], [DataInregistrare]) VALUES (5, N'Florescu', N'Elena', N'elena.f@stud.ro', N'student5', 2, CAST(N'2025-11-14T22:15:58.297' AS DateTime))
INSERT [dbo].[Student] ([IDStudent], [Nume], [Prenume], [Email], [Parola], [AnStudiu], [DataInregistrare]) VALUES (6, N'Constantin', N'Vlad', N'vlad.c@stud.ro', N'student6', 1, CAST(N'2025-11-14T22:15:58.297' AS DateTime))
INSERT [dbo].[Student] ([IDStudent], [Nume], [Prenume], [Email], [Parola], [AnStudiu], [DataInregistrare]) VALUES (7, N'Oprea', N'Ioana-Antonia', N'oprea.ioana@yahoo.com', N'oprea', 1, CAST(N'2025-11-18T12:12:10.927' AS DateTime))
GO
INSERT [dbo].[StudentExamen] ([IDStudent], [IDExamen], [Status], [DataInscriere], [DataSustinere], [Nota]) VALUES (1, 1, N'Sustinut', CAST(N'2025-11-14T22:15:58.300' AS DateTime), NULL, CAST(9.00 AS Decimal(4, 2)))
INSERT [dbo].[StudentExamen] ([IDStudent], [IDExamen], [Status], [DataInscriere], [DataSustinere], [Nota]) VALUES (2, 1, N'Sustinut', CAST(N'2025-11-14T22:15:58.300' AS DateTime), NULL, CAST(8.50 AS Decimal(4, 2)))
INSERT [dbo].[StudentExamen] ([IDStudent], [IDExamen], [Status], [DataInscriere], [DataSustinere], [Nota]) VALUES (2, 4, N'Inscris', CAST(N'2026-01-20T00:43:57.850' AS DateTime), NULL, NULL)
INSERT [dbo].[StudentExamen] ([IDStudent], [IDExamen], [Status], [DataInscriere], [DataSustinere], [Nota]) VALUES (2, 5, N'Inscris', CAST(N'2026-01-20T00:22:27.163' AS DateTime), NULL, NULL)
INSERT [dbo].[StudentExamen] ([IDStudent], [IDExamen], [Status], [DataInscriere], [DataSustinere], [Nota]) VALUES (2, 6, N'Inscris', CAST(N'2026-01-20T00:25:29.283' AS DateTime), NULL, NULL)
INSERT [dbo].[StudentExamen] ([IDStudent], [IDExamen], [Status], [DataInscriere], [DataSustinere], [Nota]) VALUES (2, 1008, N'Inscris', CAST(N'2026-01-20T12:35:46.327' AS DateTime), NULL, NULL)
INSERT [dbo].[StudentExamen] ([IDStudent], [IDExamen], [Status], [DataInscriere], [DataSustinere], [Nota]) VALUES (3, 2, N'Inscris', CAST(N'2025-11-14T22:15:58.300' AS DateTime), NULL, NULL)
INSERT [dbo].[StudentExamen] ([IDStudent], [IDExamen], [Status], [DataInscriere], [DataSustinere], [Nota]) VALUES (4, 3, N'Absent', CAST(N'2025-11-14T22:15:58.300' AS DateTime), NULL, NULL)
INSERT [dbo].[StudentExamen] ([IDStudent], [IDExamen], [Status], [DataInscriere], [DataSustinere], [Nota]) VALUES (5, 4, N'Sustinut', CAST(N'2025-11-14T22:15:58.300' AS DateTime), NULL, CAST(7.50 AS Decimal(4, 2)))
INSERT [dbo].[StudentExamen] ([IDStudent], [IDExamen], [Status], [DataInscriere], [DataSustinere], [Nota]) VALUES (6, 6, N'Inscris', CAST(N'2025-11-14T22:15:58.300' AS DateTime), NULL, NULL)
GO
INSERT [dbo].[StudentProiect] ([IDStudent], [IDProiect], [Status], [DataInscriere], [DataPredare], [Nota]) VALUES (1, 1, N'Finalizat', CAST(N'2025-11-14T22:15:58.300' AS DateTime), NULL, CAST(10.00 AS Decimal(4, 2)))
INSERT [dbo].[StudentProiect] ([IDStudent], [IDProiect], [Status], [DataInscriere], [DataPredare], [Nota]) VALUES (2, 1, N'Finalizat', CAST(N'2025-11-14T22:15:58.300' AS DateTime), NULL, CAST(10.00 AS Decimal(4, 2)))
INSERT [dbo].[StudentProiect] ([IDStudent], [IDProiect], [Status], [DataInscriere], [DataPredare], [Nota]) VALUES (2, 4, N'Neinceput', CAST(N'2026-01-20T00:52:44.630' AS DateTime), NULL, NULL)
INSERT [dbo].[StudentProiect] ([IDStudent], [IDProiect], [Status], [DataInscriere], [DataPredare], [Nota]) VALUES (2, 1020, N'Neinceput', CAST(N'2026-01-20T12:36:03.797' AS DateTime), NULL, NULL)
INSERT [dbo].[StudentProiect] ([IDStudent], [IDProiect], [Status], [DataInscriere], [DataPredare], [Nota]) VALUES (3, 2, N'In lucru', CAST(N'2025-11-14T22:15:58.300' AS DateTime), NULL, NULL)
INSERT [dbo].[StudentProiect] ([IDStudent], [IDProiect], [Status], [DataInscriere], [DataPredare], [Nota]) VALUES (4, 3, N'Neinceput', CAST(N'2025-11-14T22:15:58.300' AS DateTime), NULL, NULL)
INSERT [dbo].[StudentProiect] ([IDStudent], [IDProiect], [Status], [DataInscriere], [DataPredare], [Nota]) VALUES (5, 4, N'In lucru', CAST(N'2025-11-14T22:15:58.300' AS DateTime), NULL, NULL)
INSERT [dbo].[StudentProiect] ([IDStudent], [IDProiect], [Status], [DataInscriere], [DataPredare], [Nota]) VALUES (6, 5, N'Finalizat', CAST(N'2025-11-14T22:15:58.300' AS DateTime), NULL, CAST(8.00 AS Decimal(4, 2)))
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [UKn0cxx7qsaxhxjhib2aq054nip]    Script Date: 22-Jan-26 9:20:30 PM ******/
ALTER TABLE [dbo].[Profesor] ADD  CONSTRAINT [UKn0cxx7qsaxhxjhib2aq054nip] UNIQUE NONCLUSTERED 
(
	[Email] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [UQ_Professor_Email]    Script Date: 22-Jan-26 9:20:30 PM ******/
CREATE UNIQUE NONCLUSTERED INDEX [UQ_Professor_Email] ON [dbo].[Profesor]
(
	[Email] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [UQ_CodSala]    Script Date: 22-Jan-26 9:20:30 PM ******/
CREATE UNIQUE NONCLUSTERED INDEX [UQ_CodSala] ON [dbo].[Sala]
(
	[CodSala] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [UKfe0i52si7ybu0wjedj6motiim]    Script Date: 22-Jan-26 9:20:30 PM ******/
ALTER TABLE [dbo].[Student] ADD  CONSTRAINT [UKfe0i52si7ybu0wjedj6motiim] UNIQUE NONCLUSTERED 
(
	[Email] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [UQ_Student_Email]    Script Date: 22-Jan-26 9:20:30 PM ******/
CREATE UNIQUE NONCLUSTERED INDEX [UQ_Student_Email] ON [dbo].[Student]
(
	[Email] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Student] ADD  CONSTRAINT [DF_Student_DataInregistrare]  DEFAULT (getdate()) FOR [DataInregistrare]
GO
ALTER TABLE [dbo].[StudentExamen] ADD  CONSTRAINT [DF_StudentExamen_Status]  DEFAULT ('Inscris') FOR [Status]
GO
ALTER TABLE [dbo].[StudentExamen] ADD  CONSTRAINT [DF_StudentExamen_DataInscriere]  DEFAULT (getdate()) FOR [DataInscriere]
GO
ALTER TABLE [dbo].[StudentProiect] ADD  CONSTRAINT [DF_StudentProiect_Status]  DEFAULT ('Neinceput') FOR [Status]
GO
ALTER TABLE [dbo].[StudentProiect] ADD  CONSTRAINT [DF_StudentProiect_DataInscriere]  DEFAULT (getdate()) FOR [DataInscriere]
GO
ALTER TABLE [dbo].[Examen]  WITH CHECK ADD  CONSTRAINT [FK_Examen_Materie] FOREIGN KEY([IDMaterie])
REFERENCES [dbo].[Materie] ([IDMaterie])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Examen] CHECK CONSTRAINT [FK_Examen_Materie]
GO
ALTER TABLE [dbo].[Examen]  WITH CHECK ADD  CONSTRAINT [FK_Examen_Sala] FOREIGN KEY([IDSala])
REFERENCES [dbo].[Sala] ([IDSala])
ON UPDATE CASCADE
ON DELETE SET NULL
GO
ALTER TABLE [dbo].[Examen] CHECK CONSTRAINT [FK_Examen_Sala]
GO
ALTER TABLE [dbo].[Examen]  WITH CHECK ADD  CONSTRAINT [FKd8bjfxnrvm0v8ac3vb3qwwpwl] FOREIGN KEY([IDSala])
REFERENCES [dbo].[Sala] ([IDSala])
GO
ALTER TABLE [dbo].[Examen] CHECK CONSTRAINT [FKd8bjfxnrvm0v8ac3vb3qwwpwl]
GO
ALTER TABLE [dbo].[Examen]  WITH CHECK ADD  CONSTRAINT [FKgouq96c7y7acxoop7ce0ajqjb] FOREIGN KEY([IDMaterie])
REFERENCES [dbo].[Materie] ([IDMaterie])
GO
ALTER TABLE [dbo].[Examen] CHECK CONSTRAINT [FKgouq96c7y7acxoop7ce0ajqjb]
GO
ALTER TABLE [dbo].[Materie]  WITH CHECK ADD  CONSTRAINT [FK_Materie_Profesor] FOREIGN KEY([IDProfesor])
REFERENCES [dbo].[Profesor] ([IDProfesor])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Materie] CHECK CONSTRAINT [FK_Materie_Profesor]
GO
ALTER TABLE [dbo].[Materie]  WITH CHECK ADD  CONSTRAINT [FKeagr8qkceej899y3dtlwf5e0u] FOREIGN KEY([IDProfesor])
REFERENCES [dbo].[Profesor] ([IDProfesor])
GO
ALTER TABLE [dbo].[Materie] CHECK CONSTRAINT [FKeagr8qkceej899y3dtlwf5e0u]
GO
ALTER TABLE [dbo].[StudentExamen]  WITH CHECK ADD  CONSTRAINT [FK_StudentExamen_Student] FOREIGN KEY([IDStudent])
REFERENCES [dbo].[Student] ([IDStudent])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StudentExamen] CHECK CONSTRAINT [FK_StudentExamen_Student]
GO
ALTER TABLE [dbo].[StudentProiect]  WITH CHECK ADD  CONSTRAINT [FK_StudentProiect_Proiect] FOREIGN KEY([IDProiect])
REFERENCES [dbo].[Proiect] ([IDProiect])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StudentProiect] CHECK CONSTRAINT [FK_StudentProiect_Proiect]
GO
ALTER TABLE [dbo].[StudentProiect]  WITH CHECK ADD  CONSTRAINT [FK_StudentProiect_Student] FOREIGN KEY([IDStudent])
REFERENCES [dbo].[Student] ([IDStudent])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StudentProiect] CHECK CONSTRAINT [FK_StudentProiect_Student]
GO
ALTER TABLE [dbo].[Examen]  WITH CHECK ADD  CONSTRAINT [CK_Examen_Durata] CHECK  (([Durata]>(0)))
GO
ALTER TABLE [dbo].[Examen] CHECK CONSTRAINT [CK_Examen_Durata]
GO
ALTER TABLE [dbo].[Examen]  WITH CHECK ADD  CONSTRAINT [CK_Examen_Tip] CHECK  (([Tip]='Partial' OR [Tip]='Final' OR [Tip]='Restanta'))
GO
ALTER TABLE [dbo].[Examen] CHECK CONSTRAINT [CK_Examen_Tip]
GO
ALTER TABLE [dbo].[Materie]  WITH CHECK ADD  CONSTRAINT [CK_Materie_AnStudiu] CHECK  (([AnStudiu]>=(1) AND [AnStudiu]<=(4)))
GO
ALTER TABLE [dbo].[Materie] CHECK CONSTRAINT [CK_Materie_AnStudiu]
GO
ALTER TABLE [dbo].[Materie]  WITH CHECK ADD  CONSTRAINT [CK_Materie_NumarCredite] CHECK  (([NumarCredite]>(0)))
GO
ALTER TABLE [dbo].[Materie] CHECK CONSTRAINT [CK_Materie_NumarCredite]
GO
ALTER TABLE [dbo].[Materie]  WITH CHECK ADD  CONSTRAINT [CK_Materie_Semestru] CHECK  (([Semestru]=(1) OR [Semestru]=(2)))
GO
ALTER TABLE [dbo].[Materie] CHECK CONSTRAINT [CK_Materie_Semestru]
GO
ALTER TABLE [dbo].[Sala]  WITH CHECK ADD  CONSTRAINT [CK_Sala_Capacitate] CHECK  (([Capacitate]>(0)))
GO
ALTER TABLE [dbo].[Sala] CHECK CONSTRAINT [CK_Sala_Capacitate]
GO
ALTER TABLE [dbo].[Student]  WITH CHECK ADD  CONSTRAINT [CK_Student_AnStudiu] CHECK  (([AnStudiu]>=(1) AND [AnStudiu]<=(4)))
GO
ALTER TABLE [dbo].[Student] CHECK CONSTRAINT [CK_Student_AnStudiu]
GO
ALTER TABLE [dbo].[StudentExamen]  WITH CHECK ADD  CONSTRAINT [CK_StudentExamen_Nota] CHECK  (([Nota] IS NULL OR [Nota]>=(1) AND [Nota]<=(10)))
GO
ALTER TABLE [dbo].[StudentExamen] CHECK CONSTRAINT [CK_StudentExamen_Nota]
GO
ALTER TABLE [dbo].[StudentExamen]  WITH CHECK ADD  CONSTRAINT [CK_StudentExamen_Status] CHECK  (([Status]='Absent' OR [Status]='Sustinut' OR [Status]='Inscris'))
GO
ALTER TABLE [dbo].[StudentExamen] CHECK CONSTRAINT [CK_StudentExamen_Status]
GO
ALTER TABLE [dbo].[StudentProiect]  WITH CHECK ADD  CONSTRAINT [CK_StudentProiect_Nota] CHECK  (([Nota] IS NULL OR [Nota]>=(1) AND [Nota]<=(10)))
GO
ALTER TABLE [dbo].[StudentProiect] CHECK CONSTRAINT [CK_StudentProiect_Nota]
GO
ALTER TABLE [dbo].[StudentProiect]  WITH CHECK ADD  CONSTRAINT [CK_StudentProiect_Status] CHECK  (([Status]='Finalizat' OR [Status]='In lucru' OR [Status]='Neinceput'))
GO
ALTER TABLE [dbo].[StudentProiect] CHECK CONSTRAINT [CK_StudentProiect_Status]
GO
USE [master]
GO
ALTER DATABASE [Examene si proiecte] SET  READ_WRITE 
GO