Cate constrangeri sunt definite in codul SQL urmator:

CREATE TABLE departament (

id_departament integer NOT NULL generated always as identity (START with 10 increment by 10),

nume varchar(30) not null ,

manager integer,

PRIMARY KEY (id_departament), FOREIGN KEY (manager) references manager (id_manager));