, . . , ( ) . , , , .
. . . - . , . ( , , !)
, , , , . , , , . , , , - , . , .
, , . , , .
, . .
ap
(entity-relationship model, E-R model) . 1976 . . , (xtended E-R: model). , , -, .
, , , . , :
|
|
- ( 1990 , );
- IDEF1X (Integrated Definition I, stended , 1, ); 1993 . , . IDEF1X , , .
, , . - UML (Universal Modeling Language ) , - .
, , , IDEF1X UML.
, , .
(entity) , . : , , , , . (entity classes). , .
. , , . (entity instance) , 12345. . : - .
(attributes), , , (pro perties), . , . , .
(composite attributes) (multi-valued butes). , {, , , }. , . , , , {, }. , .. , , .
(identifiers) , , . , , . , , , . , .
|
|
. (unique) (nonunique). , . , . , , , .
, , (composite identifiers). {, }, {, } {, , }.
(relationships). cy . (relationship classes) , (relationship instances) . .
. , , (relationship degree). . ֗ 2, . . 3, , . 2 , (binary relationships).
. . 1:1 ( ) . . _ . , , .
. , 1:N ( N ). , ŗ, . , , .
, 1 N. , , N , T. 1 N N:l, , ,
. , N:M ( N ̻ ). җ, . , .
, , . , (maximi cardinality) . , , . , , 1:N. , 1 N. , _ 1:5, , .
|
|
, . һ, (HAS-A relationships). , , , .
, ., (entity-relationship diagrams, ER-diagrams). , , , . , . .
, . ? , . , , , - .
(minimum cardinality) . , . : , , , , ( ) , . , . , , . , , , . , , , .
. ep, __. . , . , . (recursive relationships).
, , . . ŗ . , , , , . ŗ , .
, . ( -).
, (weak entity). , , . , (strong entity).
|
|
, , . , , , - . . , , - .
: - -; -
. , . , , , .
, - (ID-dependent entities). , . . cy , {, }. , -- .. - : , , . .
- . , , . , {, }. . , {, }.