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

* /. ID_good =: old.ID_good AND.Price =: old.Price AND.Producer =: old.Producer AND.Model =: old.Model AND.Others =: old.Others;

/* ERwin Builtin Trigger */

/* Good Proectors on parent delete cascade */

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

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

- ERwin Builtin Trigger;

/ TRIGGER tU_Good AFTER UPDATE ON Good for each row

- ERwin Builtin Trigger

- UPDATE trigger on GoodNUMROWS INTEGER;

/* ERwin Builtin Trigger */

/* Good Delivery on parent update restrict */

/* ERWIN_RELATION: CHECKSUM = "0008c572", PARENT_OWNER = "", PARENT_TABLE = "Good" _OWNER = "", CHILD_TABLE = "Delivery" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_3", FK_COLUMNS = "ID_good" */

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

: old.ID_good <>: new.ID_goodcount (*) INTO NUMROWSDelivery

/* % JoinFKPK (Delivery,:% Old, "=", "AND") * /. ID_good =: old.ID_good; (NUMROWS> 0) _application_error (

,

'Cannot update Good because Delivery exists.'

); IF; IF;

/* ERwin Builtin Trigger */

/* Good Ord on parent update restrict */

/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = "Good" _OWNER = "", CHILD_TABLE = "Ord" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_4", FK_COLUMNS = "ID_good" */

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

: old.ID_good <>: new.ID_goodcount (*) INTO NUMROWSOrd

/* % JoinFKPK (Ord,:% Old, "=", "AND") * /. ID_good =: old.ID_good; (NUMROWS> 0) _application_error (

,

'Cannot update Good because Ord exists.'

); IF; IF;

/* ERwin Builtin ...