Контрольная работа: по Основам объектно-ориентированного программирования

SET nomer_i = NEW.nomer

WHERE nomer_i = OLD.nomer;

END

^

CREATE TRIGGER "TRI_1" FOR "MAGAZINI"

ACTIVE AFTER DELETE POSITION 0

AS

BEGIN

DELETE FROM igruchki

WHERE igruchki.nomer_i = magazini.nomer;

END

^

COMMIT WORK ^

SET TERM ;^

Таблица игрушки

/* Table: IGRUSHKI, Owner: SYSDBA */

CREATE TABLE "IGRUSHKI"

(

"NOMER_IG" INTEGER NOT NULL,

"NOMER" INTEGER NOT NULL,

"NAZVANIE" CHAR(20) CHARACTER SET WIN1251,

"CENA" INTEGER,

"PROIZVODITEL" CHAR(20) CHARACTER SET WIN1251,

"VOZRAST" INTEGER,

PRIMARY KEY ("NOMER_IG")

);

ALTER TABLE "IGRUSHKI" ADD FOREIGN KEY ("NOMER") REFERENCES MAGAZINI ("NOMER");

Заполнение таблиц