, , . Microsoft VisualStudio C# SQL.
.
, . , , , , , .
UML.
.
, . , , . , . . , , .
: Microsoft Visual Studio C# SQL.
:
1. : 06.03.2012.
2. : 10.03.2012.
3. : .
4. , , : 25.05.2012
: ( , , , , , , , , ), ( , , ), ( , ), ( , , , , ), ( , , , , , ), ( , , . ), ( , , , , , , ).
:
,
,
,
,
( , , ).
, , .
. Windows.
|
|
() . , . , , , . , .
, , "MS SQL Server 2008 R2: Express" : 1.1-1.7.
.
1.1 -
Student | id_student | - | ||||
fio | ||||||
date_birth | - | |||||
obrazovanie | ||||||
adres | ||||||
telephone | - | |||||
Nbileta | - | |||||
id_group | - | |||||
other_info | ||||||
.
1.2 -
Chlenstvo | Nbileta | - | ||
data_vstypleniya | - | |||
data_vihoda | - | |||
id_oplaty | - | |||
id_student | - |
.
1.3 -
Faculty | id_faculty | - | ||
name_faculty |
.
1.4 -
Group | id_group | - | ||
name_group | ||||
id_faculty | - |
.
1.5 -
Oplata | id_oplaty | - | ||
summa | - | |||
god_oplaty | ||||
status_oplaty |
1.5
id_perioda | - | |||
Nbileta | - |
.
1.6
Period_oplaty | id_perioda | - | ||
nazvanie_period | ||||
nachalo_per | - | |||
konec_per | - |
.
1.7 -
Pytevka | id_pytevki | |||
Nbileta | - | |||
Nzaezda | - | |||
god | - | |||
nachalo_zaezda | - | |||
konec_zaezda | ||||
status_oplaty |
1 .
|
|
1 - "MS SQL"
, ( ) ( ), .
, .
, . , - .
:
1.
2.
3.
4.
5.
6.
7.
8.
34.602-89 . ѻ
.
- , . , . (. ).
. , . . , () .
, :
;
.
, . . , .
, , . - , - . . .
UML (Unified Modeling Language - - . ), , - .
UML , :
;
;
;
;
;
;
;
;
.
, ,
|
|
3.1
, . . . , , . 2.
2
. : , , , (, ) .
3.1-3.33
3.1 -
3.2 -
3.3 -
3.4 -
3.5 -
3.6 -
3.7 -
3.8-
3.9 -
, |
3.10 -
|
|
3.11 -
3.12 -
3.13 -
3.14 -
3.15 -
3.16 -
3.17 -
3.18
3.19 -
3.20 -
3.21 -
3.22 -
3.23 -
3.24 -
.
:
3.25
1. , . | 2. . |
3. , | 4. . |
5. | 6. |
:
3.26
1. , . | 2. . |
3. , | 4. . |
5. | 6. |
|
|
:
3.27
1. , . | 2. . |
3. , | 4. . |
5. | 6. |
:
3.28
1. , . | 2. . |
3. , | 4. . |
5. | 6. |
:
3.29
1. , . | 2. . |
3. , | 4. . |
5. | 6. |
:
3.30
1. , . | 2. . |
3. , | 4. . |
5. | 6. |
3.31
1. , . | 2. . |
3. . | 4. . |
5. | 6. |
: .
3.32
1. , . | 2. . |
3. . | 4. . |
5. \ | 6. |
: .
3.32
1. , . | 2. . |
3. . | 4. . |
5. | 6. |
: .
3.34
1. , . | 2. . |
3. , . | 4. . |
5. | 6. |
: .
3.35
1. , . | 2. . |
3. , . | 4. . |
5. | 6. |
: .
3.36
1. , . | 2. . |
3. , . | 4. . |
5. | 6. |
3.2
- - , . , . , UML :
, , , ;
, , . . ;
, .
3.
3
3.3
4 .
4
3.37 3.40.
3.37 -
- - - |
3.38 -
, - - - |
3.39 -
- - - |
3.40 -
- - - |
5 .
5
3.41,3.42.
3.41 -
3.42 -
6 .
6
3.43 - 3.45.
3.43 -
- |
3.44 -
- |
3.45 -
- |
7 .
7
3.46,3.47.
3.46 -
- - - |
3.47 -
- - |
3.4
. , , . .
(), . . , .
8.
8
9.
9
10.
10
11.
11
12.
12
13.
13
14.
14
15.
15
16.
16
17.
17
18.
18
19.
19
20.
20
21.
21
22.
22
23.
23
/ 24.
24 /
25.
25
25.
25
:
( , , );
(, , ).
. , , . , , , . IBM PC Intel Core CPU . C Windows XP .Net Framework, SQL , .
4.1
SQL Server Management Studio SQL Server, .
, (. 26).
26
MDF- LDF- SQL Server, .
Management Studio SQL Server, .
(. 27).
27
, MDF- LDF- , (. 28).
28
connectionstring
SQL connectionstring . Microsoft VisualStudio C# , project windowsformsapplication1 properties 29
29
Settings, connectionstring value ... (. 30) SQL .
30 connectionstring
.
4.2
. , , . . . 31, 32 33 , : , , .
31 ,
32 ,
33 ,
, .
34
, , , (. 35).
35
\ 2 , , 36
36
, , , , 37.
37
. , (. 38).
38
. . DOC . DOC 39.
39 DOC
, , . 34.602 - 89 , 34.201 - 89. . . , . , , .