CREATE TABLE department
(
    id_department INT NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
    shortcut VARCHAR(30) NOT NULL,
    name VARCHAR(255) NOT NULL
);

CREATE TABLE students
(
    id_student INT NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
    firstname VARCHAR(30) NOT NULL,
    lastname VARCHAR(255) NOT NULL,
    id_department INT NOT NULL,
    FOREIGN KEY (id_department) REFERENCES DEPARTMENT (id_department) ON DELETE CASCADE
);

INSERT INTO ZAD5.DEPARTMENT (SHORTCUT, "NAME")
    VALUES ('KIO', 'Katedra Inzynierii Oprogramowania');
INSERT INTO ZAD5.DEPARTMENT (SHORTCUT, "NAME")
    VALUES ('KASK', 'Katedra Architektury Systemów Komputerowych');
INSERT INTO ZAD5.DEPARTMENT (SHORTCUT, "NAME")
    VALUES ('KAiMS', 'Katedra Algorytmów i Modelowania Systemów');