.


:




:

































 

 

 

 





, , .. , .

. ( ) . 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





:


: 2015-11-05; !; : 892 |


:

:

.
==> ...

1967 - | 1848 -


© 2015-2024 lektsii.org - -

: 0.038 .