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

child insert restrict */

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

); IF;

- ERwin Builtin Trigger;

/ TRIGGER tU_TV_monit AFTER UPDATE ON TV_monit for each row

- ERwin Builtin Trigger

- UPDATE trigger on TV_monitNUMROWS INTEGER;

/* ERwin Builtin Trigger */

/* Good TV_monit on child update restrict */

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

); IF;

- ERwin Builtin Trigger;

/ TRIGGER tI_Warehouse BEFORE INSERT ON Warehouse for each row

- ERwin Builtin Trigger

- INSERT trigger on WarehouseNUMROWS INTEGER;

/* ERwin Builtin Trigger */

/* Internet_store Warehouse on child insert restrict */

/* ERWIN_RELATION: CHECKSUM = "0000f534", PARENT_OWNER = "", PARENT_TABLE = "Internet_store" _OWNER = "", CHI...