, , . , , .. . , .
, , . , , . , , .. , , .
, 1. , , "" " 1" . "" " ", , .
1 (2), (3) .. , 2, 1 , , , . 3, 2 , , ..
, , , . , "(N+1)- " , "N- ". , (N+1)- N- , . . : .
. , .
. , .
. , .
|
|
, . , " ", . , .
, " ", .
.
- , , , .
, . () . , . .
1NF - .
:
- , ().
- , . ( ).
:
1NF .
2NF - .
- . , - . 2, 1 .
3NF - .
.
X, Y, Z - .
X --> Y Y --> Z,
, .. Z -/-> Y Y -/-> X.
Z X.
3, 2 .
BCNF - -.
BCNF, 3 .
, 3NF, BCNF, , ( ) , . , , 3NF BCNF .
.
Aplicant_Represent_Table
Represent_id -> Represent_FIO Authority, Represent_Phone
Applicant_Table
|
|
Applicant_id -> Applicant_FIO, Applicant_adress, Applicant_adress_fact, Applicant_Phone, Applicant_Represent_FIO, Applicant_IK,, Applicant_Passport, Represent_id
Claim_Table
Claim_id -> Claim_Type, Claim_Date, Claim_conditions, Claim_Evidence, Claim_requirements, Claim_docs, Claim_word_doc, Applicant_id, Claim_type_id, Town_id, Respondent_id
Claim_Type_Table
Claim_type_id -> Claim_Type_Name
List_of_Towns
List_of_Towns -> Town_name
List_Representative
representative_id -> representative_name
List_Town
Town_id ->Town_name
Respondent_Table
Respondent_id -> Respondent_FIO, Respondent_adress, Respondent_adress, Respondent_adress_fact, Respondent_Phone, Respondent_IK, Respondent_IK
, , -. , -, , , , . .
Claim_Table 2.3
2.3 Claim_Table
Respondent_Table 2.4
2.4 Respondent_Table
Applicant_Table 2.5
2.5 Applicant_Table
Aplicant_Represent_Table 2.6
2.6 Aplicant_Represent_Table
Claim_Type_Table 2.7
2.7 Claim_Type_Table
List_of_Towns 2.8
2.8 List_of_Towns
2
2 , . . ER-, 6 . .
3