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

Trigger */

/* Good TV_monit on parent update cascade */

/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = " Òîâàð "_OWNER =" ", CHILD_TABLE =" TV_monit "C_VERB_PHRASE =" ", C2P_VERB_PHRASE =" ", _CONSTRAINT =" is_a ", */

/*% JoinPKPK (:% Old,:% New, "<>", "OR") */

: old.ID_good <>: new.ID_goodTV_monit

/* % JoinFKPK (TV_monit,:% New, "=", "," ) */_monit.ID_good =: new.ID_good, _monit.Price =: new.Price, _monit.Producer =: new.Producer, _monit.Model =: new.Model, _monit.Others =: new.Others

/* % JoinFKPK (TV_monit,:% Old, "=", "AND") */_monit.ID_good =: old.ID_good AND_monit.Price =: old.Price AND_monit.Producer =: old.Producer AND_monit.Model =: old.Model AND_monit.Others =: old.Others; IF;

/* ERwin Builtin Trigger */

/* Good Players on parent update cascade */

/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = " Òîâàð "_OWNER =" ", CHILD_TABLE =" Players "C_VERB_PHRASE =" ", C2P_VERB_PHRASE =" ", _CONSTRAINT =" is_a ", */

/*% JoinPKPK (:% Old,:% New, "<>", "OR") */

: old.ID_good <>: new.ID_goodPlayers

/* % JoinFKPK (Players,:% New, "=", "," ) * /. ID_good =: new.ID_good,. Price =: new.Price,. Producer =: new.Producer,. Model =: new.Model,. Others =: new.Others

/* % JoinFKPK (Players,:% Old, "=", "AND") * /. ID_good =: old.ID_good AND.Price =: old.Price AND.Producer =: old.Producer AND.Model =: old.Model AND.Others =: old.Others; IF;

/* ERwin Builtin Trigger */

/* Good Camera on parent update cascade */

/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = " Òîâàð "_OWNER =" ", CHILD_TABLE =" Camera "C_VERB_PHRASE =" ", C2P_VERB_PHRASE =" ", _CONSTRAINT =" is_a ", */

/*% JoinPKPK (:% Old,:% New, "<>", "OR") */

: old.ID_good <>: new.ID_goodCamera

/* % JoinFKPK (Camera,:% New, "=", "," ) * /. ID_good =: new.ID_good,. Price =: new.Price,. Producer =: new...