2. .
. (Relationship Verb Phrases) (. 1). - , :
<> ;
<> .
.1 - Relationship Verb Phrases
, . . , , , , Display Options/Relationship Verb Phrase.
--, -- -- ( ).
IDEF1X . . ( ) ( ) . , ERwin . ( . 2). , . . . 2 , . . . - (FK).
. 2.
, , NOT NULL, .
(. 3) , . .
. 3.
- , . . , - .
(. . 2), - (. 3).
|
|
:
( ) ;
, .
. , .
, -- .
"" Relationship Editor.
General , (. 4).
(Cardinality) - .
(. 5):
, 0, 1 - ;
, 1 ( );
Z , 0 1 ( );
, .
. 4. Relationship Editor
, , . , , , , Display Options/Relationship Cardinality.
(Verb Phrase) - , . -- , (Parent-to-Child). -- Parent-to-Child Child-to-Parent.
. 5.
(/). (Nulls). (No Nulls) NOT NULL, . (Nulls Allowed) NULL. (. . 3).
. 6. Rolename/RI Actions Relationship Editor
Definition , .
Rolename/RI Actions .
( ) - , , .
. 7.
|
|
, . 7, " ", , . . ( , ) , , , , Display Options/Entities Rolename/Attribute (. 6). , (. . 7).
, , . . , . . 8 , - . . , - . , ( ), ( ). . 8 .
. 8.
( " " - fish hook), . . , . . 7 . , . ( . 7 /) (""). , . NOT NULL. - - , .
/ . 7 . (hierarchical recursion) , ( ) ( ), (. 9).
. 9.
(network recursion), , , . . , --. -- ( -- ).
. 10.
. 10 . . "-", "-", "-", "-", "-" . . , . "" "". , , .
|
|
, ( + ), - . . 11 , , , , , , . " ".
. 11.
, , ( ).
(referential integrity, RI) - , - , . , Rolename/RI Actions, , , , . , , (INSERT, UPDATE DELETE). . 11 . , ? ( . NULL), , , ( ), . "" "" (Parent RESTRICT Parent CASCADE, . . 6). , , , , . , . , , , , .
. 7 . ( . NULL). - SET NULL. - . NULL. , - .
( ):
|
|
SET DEFAULT - . , .
NONE - . " ", . . . "" . , dbf-, , " " , . - , , .
, . , , . , , , . :
, "One or more" - 1 ( ). , .
RI- "Parent Insert-CASCADE" , .
RI- "Parent Delete-CASCADE" , .
ERwin , , . RI, ERwin , Referential Integrity Default, , RI Defaults Target Server ( Server/Target Server).
-- . . 12 --. , . .
. 12. --
, , .
-- - ( "/"). . . 12 <> " , <> " .
ERwin --, -- (. 13, ). ' 1 2".
. 13. --
-- . Doctor_Patient , - Visit. , , , Visit , - (VisitDatetime, . 14).
. 14. --
, , , . 12.