Create Operation Containers

Whilst the default method of modeling Database Functions, Procedures and Sequences is to create them as individual elements, you can also represent a number of each type of structure as operations of a container Class. You add a stereotype to the Class which specifies:

·Which type of data structure the Class will contain
·The stereotype that will be automatically assigned to each operation created in the Class (for a given data structure, the operations can only be of one stereotype)

 

Access     Diagram Toolbox | Drag the Class icon onto the diagram

Create the Container Class

Step

Action

See also

1

Right-click on the Class element on the diagram and select the Properties Page | General menu option.

The element Properties dialog displays, showing the General tab.

 

 

2

In the Name field, type an appropriate name for the container.

 

 

3

In the Stereotype field (in the Table at the right edge of the dialog) type:

·functions for a Database Function container
·procedures for a Stored Procedure container
·sequences for a Sequence container

 

The s at the end of the stereotype name is important.

 

 

4

Click on the OK button to save the setting and close the dialog.

 

 

 

Create database structures as operations of the Class

Step

Action

See also

1

Click on the Class element on the diagram and press F10.

The Database <Structure> container: <Classname> dialog displays.

 

 

2

Right-click in the Functions (Procedures or Sequences) list and select Add New <structure>.

 

 

3

In the Name field, type an appropriate name for the operation, such as:

·fn_WorkDays
·sp_AddOrder  or
·seq_AddressID

 

 

4

In the Notes field type any supporting comments or explanation of the operation.

In the Function definition field (or Procedure definition, or Sequence definition) type the appropriate text.

 

 

5

Repeat steps 2 to 4 until you have defined all the operations you require.

 

 

6

Click on the list and then on the Close button to close the dialog and show the operations within the Class on the diagram and in the Project Browser.

 

 

Learn more