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

.Producer,. Model =: new.Model,. Others =: new.Others

/* % JoinFKPK (Camera,:% 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 Proectors on parent update cascade */

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

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

: old.ID_good <>: new.ID_goodProectors

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

/* % 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; IF;

/* ERwin Builtin Trigger */

/* Warehouse Good on child update restrict */

/* ERWIN_RELATION: CHECKSUM = "00000000", PARENT_OWNER = "", PARENT_TABLE = "Warehouse" _OWNER = "", CHILD_TABLE = "Good" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_2", FK_COLUMNS = "ID_warehouse" */count (*) INTO NUMROWSWarehouse

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

: new.ID_warehouse = Warehouse.ID_warehouse; (

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

) _application_error (

,

'Cannot update Good because Warehouse does not exist.'

); IF;

- ERwin Builtin Trigger; TRIGGER tD_Internet_store AFTER DELETE ON Internet_store for each row

- ERwin Builtin Trigger

- DELETE trigger on Internet_storeNUMROWS INTEGER;

/* ERwin Builtin Trigger */

/* Internet_store Warehouse on parent delete restrict */

/* ERWIN_RELATION: CHECKSUM = "0000d752", PARENT_OWNER = "", PARENT_TABLE = "Internet_store" _OWNER = "", CHILD_TABL...