, , .. , .
. ( ) . 4.27.
. 4.25. ,
, , :
( - , , , (peer-to-peer) ..);
;
;
;
- .
. 4.28
. 4.26. ,
. 4.27.
. 4.28.
4.4.2.
:
;
;
.
, . , , , . 4.7 4.8, , . 4.29 4.30.
CourseRegBDManager . 4.29 (, , ).
:
;
;
;
.
. , . , , , .
- . . , , .
. 4.29.
, , . , ( , ..).
|
|
.
. 4.30. -
. , , , . :
, ;
( , UML;
, ;
: public, private protected;
: ( ) ( );
( -, ).
:
, ();
, ;
: public, private protected;
() .
. 4.31.
. , . - . , , ( ) .
, , . .
, , CourseOffering. :
1. . . , CourseOffering Open ( ) , 10, 10, Closed ( ). , CourseOffering Unassigned ( , .. - Professor) Assigned ( ).
. 4.31. Student
2. . , , . , CourseOffering addProfessor removeProfessor, ( ) ( ). - addProfessor removeProfessor.
|
|
3. . . , Unassigned Assigned (. 4.32).
. 4.32.
CourseOffering , . 4.33. , (composite state) (history state). Open Closed, Unassigned, Assigned, Cancelled ( ), Full ( ) Committed ( ). , .
( ͻ) , . Open , (Unassigned Assigned) Open, , Open (add student remove student) , .
. 4.33.
:
(, , , , addstudent removestudent CourseOffering);
;
(, , (numStudents), CourseOffering ).
. (, ) .
, . , .
, .
, (. . 2.4.2), .
. 4.34.
, . 4.34. . Student Schedule . Schedule CourseOffering : , - , .
. 4.35.
. , , .. Student . . , , . 4.35.
|
|
- . , - . - . , , ER-. , , , . 4.1. RUP, , Data Modeler. - - SQL.
UML ( UML):
Table;
View;
;
Non-Identifying ( IDEF1X );
Identifying ( IDEF1X );
Schema, -;
SP Container;
, - ʻ (Primary key), FK (Foreign key), Unique, Check, Index Trigger;
Database.
. 4.36.
, Data Modeler, . 4.36 - 4.38.
. 4.36 -, Schedule CourseOffering (. . 4.16), --.
T_Student T_Schedule . 4.37 Student Schedule . 4.34.
. 4.38 , . 4.35. ( . 4.1). . 4.1). , , , Data Modeler.
. 4.37.
. 4.38.
!
- . .
|
|
, , , , , .
?
1. ERM.
2. ?
3. ?
4. ?
5. Rational Unified Process.
5