Реферат Розробка Бази даних та! Застосування для Інтернет-магазину відеотехнікі

align="justify"> TRIGGER tI_Players BEFORE INSERT ON Players for each row

- ERwin Builtin Trigger

- INSERT trigger on PlayersNUMROWS INTEGER;

/* ERwin Builtin Trigger */

/* Good Players on child insert restrict */

/* ERWIN_RELATION: CHECKSUM = "0001219d", PARENT_OWNER = "", PARENT_TABLE = " Òîâàð "_OWNER =" ", CHILD_TABLE =" Players "C_VERB_PHRASE =" ", C2P_VERB_PHRASE =" ", _CONSTRAINT =" is_a ", */Count (*) INTO NUMROWSGood

/*% JoinFKPK (:% New, Good, "=", "AND") */

: new.ID_good = Good.ID_good AND

: new.Price = Good.Price AND

: new.Producer = Good.Producer AND

: new.Model = Good.Model AND

: new.Others = Good.Others; (

/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0

) _application_error (

,

'Cannot insert Players because Good does not exist.'

); IF;

- ERwin Builtin Trigger;

/ TRIGGER tU_Players AFTER UPDATE ON Players for each row

- ERwin Builtin Trigger

- UPDATE trigger on PlayersNUMROWS INTEGER;

/* ERwin Builtin Trigger */

/* Good Players on child update restrict */

/* ERWIN_RELATION: CHECKSUM = "0001232a", PARENT_OWNER = "", PARENT_TABLE = " Òîâàð "_OWNER =" ", CHILD_TABLE =" Players "C_VERB_PHRASE =" ", C2P_VERB_PHRASE =" ", _CONSTRAINT =" is_a ", */Count (*) INTO NUMROWSGood

/*% JoinFKPK (:% New, Good, "=", "AND") */

: new.ID_good = Good.ID_good AND

: new.Price = Good.Price AND

: new.Producer = Good.Producer AND

: new.Model = Good.Model AND

: new.Others = Good.Others; (

/*% NotnullFK (:% New, "IS NOT NULL AND") */= 0

) _application_error (

,

'Cannot update Players because Good does not exist.'

); IF;

- ERwin Builtin Trigger; TRIGGER tI_Proectors BEFORE INSERT ON Proectors for each row

- ERwin Builtin Trigger

- INSERT trigger on Proec...