Реферат Розробка Бази даних та! Застосування для інтернет-магазину продаж МУЗИЧНИЙ інструментів

TION: CHECKSUM = В«000119f9В», PARENT_OWNER = »», PARENT_TABLE = "Інструменти" _OWNER = »», CHILD_TABLE = В«DyhovueВ» C_VERB_PHRASE = »», C2P_VERB_PHRASE = »», _CONSTRAINT = В«is_aВ», FK_COLUMNS = В«nom_postВ» В«post_noВ» В«inv_numbВ» */count (*) INTO NUMROWSInstrymentu

/*% JoinFKPK (:% New, Instrymentu, В»=В», В»ANDВ») */

: new.nom_post = Instrymentu.nom_post AND

: new.post_no = Instrymentu.post_no AND

: new.inv_numb = Instrymentu.inv_numb; (

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

) _application_error (

,

'Cannot insert Dyhovue because Instrymentu does not exist.'

); IF;

ERwin Builtin Trigger;

/TRIGGER tU_Dyhovue AFTER UPDATE ON Dyhovue for each row

ERwin Builtin Trigger

UPDATE trigger on DyhovueNUMROWS INTEGER;

/* ERwin Builtin Trigger */

/* Instrymentu Dyhovue on child update restrict */

/* ERWIN_RELATION: CHECKSUM = В«000118b6В», PARENT_OWNER = »», PARENT_TABLE = "Інструменти" _OWNER = »», CHILD_TABLE = В«DyhovueВ» C_VERB_PHRASE = »», C2P_VERB_PHRASE = »», _CONSTRAINT = В«is_aВ», FK_COLUMNS = В«nom_postВ» В«post_noВ» В«inv_numbВ» */count (*) INTO NUMROWSInstrymentu

/*% JoinFKPK (:% New, Instrymentu, В»=В», В»ANDВ») */

: new.nom_post = Instrymentu.nom_post AND

: new.post_no = Instrymentu.post_no AND

: new.inv_numb = Instrymentu.inv_numb; (

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

) _application_error (

,

'Cannot update Dyhovue because Instrymentu does not exist.'

); IF;

ERwin Builtin Trigger;

/TRIGGER tI_Instrymentu BEFORE INSERT ON Instrymentu for each row

ERwin Builtin Trigger

INSERT trigger on InstrymentuNUMROWS INTEGER;

/* ERwin Builtin Trigger */

/* Sklad Instrymentu on child insert restrict */

/* ERWIN_RELATION: CHECKSUM = «00011048», PARENT_OWNER = »», PARENT_TABLE = «Sklad» _OWNER = »», CHILD_TABLE = «Instrymentu» C_VERB_PHRASE = »», C2P_VERB_PHRASE = »», _CONSTRAINT = «R_28», FK_COLUMNS = «nom_post» «post_no» «inv_numb» */count (*) INTO NUMROWSSklad

/*% JoinFKPK (:% New, Sklad, В»=В», В»ANDВ») */

: new.nom_post = Sklad.nom_post AND

: new.post_no = Sklad.post_no AND

: new.inv_numb = Sklad.inv_numb; (