CREATE 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)

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

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

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); ALTER TABLE PREDMET ADD CONSTRAINT FK_PREDMET_1 FOREIGN KEY (VNOM) REFERENCES YKLAD(VNOM) ON DELETE CASCADE ON UPDATE CASCADE