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

, PARENT_OWNER = "", PARENT_TABLE = " Òîâàð "_OWNER =" ", CHILD_TABLE =" Camera "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 Camera because Good does not exist.'

); IF;

- ERwin Builtin Trigger;

/ TRIGGER tD_Courier AFTER DELETE ON Courier for each row

- ERwin Builtin Trigger

- DELETE trigger on CourierNUMROWS INTEGER;

/* ERwin Builtin Trigger */

/* Courier Ord_del on parent delete restrict */

/* ERWIN_RELATION: CHECKSUM = "000102b6", PARENT_OWNER = "", PARENT_TABLE = "Courier" _OWNER = "", CHILD_TABLE = "Ord_del" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_8", FK_COLUMNS = "N_S_cour" "Phone_cour" "ID_courier" */count (*) INTO NUMROWSOrd_del

/* % JoinFKPK (Ord_del,:% Old, "=", "AND") */_del.ID_courier =: old.ID_courier AND_del.N_S_cour =: old.N_S_cour AND_del.Phone_cour =: old.Phone_cour; (NUMROWS> 0) _application_error (

,

'Cannot delete Courier because Ord_del exists.'

); IF;

- ERwin Builtin Trigger;

/ TRIGGER tU_Courier AFTER UPDATE ON Courier for each row

- ERwin Builtin Trigger

- UPDATE trigger on CourierNUMROWS INTEGER;

/* ERwin Builtin Trigger */

/* Courier Ord_del on parent update restrict */

/* ERWIN_RELATION: CHECKSUM = "00012249", PARENT_OWNER = "", PARENT_TABLE = "Courier" _OWNER = "", CHILD_TABLE = "Ord_del" C_VERB_PHRASE = "" ;, C2P_VERB_PHRASE = "", _CONSTRAINT = "R_8", FK_COLUMNS = "N_S_cour" "Phone_cour" "ID_courier" */

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

: old.ID_courier <>: new.ID_courierc...