ER- 1 .
ER- 2 , .
ER- 3 , .
ER- 4 .
, . ER- , 3.7.
ER- (. 3.8).
ER- .
ER- .
3.7 ER
() | () | |
() | (_) | |
() | ||
() | ||
() | ... (_) | |
() | () | |
() | (_) |
3.8
. .
http://www.site-do.ru/db/db4.php -
http://www.site-do.ru/db/db5.php - ( )
4.
, . , :
,
( ),
.
.
, .
, . :
(First Normal Form INF);
(Second Normal Form 2NF);
(Third Normal Form 3NF);
|
|
(BriceCodd Normal Form
BCNF);
(Fourth Normal Form 4NF);
, -
(Fifth Normal Form 5NF, PJ/NF).
.
: ; ; ; ; .
, . .
, .
. , . , , ( ) ( ), : 1, 2, 3, 4, 5, .. .
, , ; .
. , .
. , .
. , . (), ().
4.1
4.2
. , , , .
, , .
, . , .
, , . , .
|
|
4.3 -
, , (. . 4.3).
, . .
.
, - , .
. 4.4.
4.4 - ,