ALTER TABLE PREDMET ADD CONSTRAINT FK_PREDMET_1 FOREIGN KEY (VNOM) REFERENCES VYKLAD(VNOM) ON DELETE CASCADE ON UPDATE CASCADE

CREATE TABLE PREDMET (PNOM INTEGER NOT NULL PRIMARY KEY, PNAME VARCHAR(15), VNOM INTEGER , GOD INTEGER);

CREATE DOMAIN GOD AS INTEGER DEFAULT 50 CHECK (VALUE > 10)

ALTER TABLE PREDMET (PNOM INTEGER NOT NULL PRIMARY KEY, PNAME VARCHAR(15), VNOM INTEGER, CONSTRAINT FK_PREDMET_1 FOREIGN KEY (VNOM) REFERENCES VYKLAD (VNOM), GOD INTEGER CHECK(GOD>0));

CREATE TABLE PREDMET (PNOM INTEGER NOT NULL PRIMARY KEY, PNAME VARCHAR(15), VNOM INTEGER , ONSTRAINT FK_PREDMET_1 FOREIGN KEY (VNOM) REFERENCES VYKLAD (VNOM), GOD INTEGER)