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

torsNUMROWS INTEGER;

/* ERwin Builtin Trigger */

/* Good Proectors on child insert restrict */

/* ERWIN_RELATION: CHECKSUM = "00011a67", PARENT_OWNER = "", PARENT_TABLE = " Òîâàð "_OWNER =" ", CHILD_TABLE =" Proectors "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 Proectors because Good does not exist.'

); IF;

- ERwin Builtin Trigger;

/ TRIGGER tU_Proectors AFTER UPDATE ON Proectors for each row

- ERwin Builtin Trigger

- UPDATE trigger on ProectorsNUMROWS INTEGER;

/* ERwin Builtin Trigger */

/* Good Proectors on child update restrict */

/* ERWIN_RELATION: CHECKSUM = "00011d9b", PARENT_OWNER = "", PARENT_TABLE = " Òîâàð "_OWNER =" ", CHILD_TABLE =" Proectors "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 Proectors because Good does not exist.'

); IF;

- ERwin Builtin Trigger;

/ TRIGGER tI_TV_monit BEFORE INSERT ON TV_monit for each row

- ERwin Builtin Trigger

- INSERT trigger on TV_monitNUMROWS INTEGER;

/* ERwin Builtin Trigger */

/* Good TV_monit on ...