BD_LAB3_QUERY_CREARE_TABEL_DEPARTAMENTE

USE companydb;

CREATE TABLE Departamente(
    DepartamentID INT NOT NULL IDENTITY(1, 1) PRIMARY KEY,
    ManagerID INT,
    NumeDepartament VARCHAR(20) NOT NULL,
    CodDepartament VARCHAR(20) NOT NULL UNIQUE
);

ALTER TABLE Angajati
ADD CONSTRAINT DepartamentID
FOREIGN KEY (DepartamentID) REFERENCES Departamente(DepartamentID);