CREATE DATABASE Universiteti

USE Universiteti

CREATE TABLE Stafi

CREATE TABLE StafiTipi(
TipiID INT PRIMARY KEY ,
Tipi VARCHAR(255)  NOT NULL,
)

CREATE TABLE Lenda(
LendaID INT PRIMARY KEY,
Lenda CHAR(4) NOT NULL,
ECTS INT NOT NULL,
)
CREATE TABLE Departamenti(
departamentiID INT PRIMARY KEY,
departamenti VARCHAR(255) NOT NULL,
Zyra INT NULL,
)

CREATE TABLE Stafi(
StafiID INT PRIMARY KEY,
Emri VARCHAR(255)NOT NULL,
Mbimeri VARCHAR(255) NOT NULL,
DataLindjes DATE NOT NULL,
NumriPersonal INT UNIQUE NOT NULL,
DepartamentiID INT NOT NULL FOREIGN KEY REFERENCES Departamenti(DepartamentiID)
)

ALTER TABLE stafi
ADD tipiID INT FOREIGN KEY REFERENCES StafiTipi(tipiID)

ALTER TABLE Stafi
ALTER COLUMN Mbimeri VARCHAR(200) NOT NULL

CREATE TABLE Studenti(
Studenti INT PRIMARY KEY,
emri VARCHAR(255) NOT NULL,
mbiemri VARCHAR(255) NOT NULL,
departamenti INT NOT NULL,
)

ALTER TABLE Studenti
ADD FOREIGN KEY (Departamenti) REFERENCES Departamenti(DepartamentiID)