Tutorial for Designer/2000
and Developer/2000

Lesson 4

In this lesson, you will learn to create a Function Hierarchy using the Function Hierarchy Diagrammer. Specifically, this will involve:

What is a Function Hierarchy Diagram?

A Function Hierarchy diagram is a diagram that shows all the functions involved in your system in a hierarchical manner like in an organizational chart. Unlike the process model or the data flow diagram, it does not show the organizational units involved in the functions, the datastores or the data flows. It just specifies the Parent Function (the function at the very top) and the sub or child functions underneath it. Each child function can also be broken down into further sub functions.

A Narrative of the Functions involved in the Function Hierarchy Diagram Since you have already created a dataflow diagram with four processes and have further decomposed those processes using the Dataflow Diagrammer and the Process Modeller, you will notice that Oracle has automatically generated for you a function hierarchy diagram with the above mentioned processes. However, using the Function Hierarchy Diagrammer, you can further decompose the existing functions showing a modified hierarchy.

  1. In this case, the function hierarchy diagram will be based on the Student Registration System that we created and decomposed using the dataflow Diagrammer and the Process Modeller. So the Student Registration System will be our Parent Function and will have the label SRS (as in the DFD and the process model).

  2. This parent function will involve four sub or child functions, Maintain Student Records, Maintain Course Information, Maintain Course Enrollment and List Schedule. As in the DFD, they will have labels of SRS1, 2, 3 & 4 respectively.

  3. The initial function hierarchy diagram that Oracle will generate will show the decomposition of Maintain Course Records into Validate Course Data and Update Course being offered Records and the decomposition of Maintain Course Enrollment in to Check Student Status, Check Course Details and Update Enrollment. In the course of this lesson we will decompose the process Maintain Student Records into Insert Student Records, Update Student Records and Delete Student Records.

  4. See Figure 4.1 for a graphical representation of the function hierarchy diagram that we will generate in the course of this lesson.

Figure 4.1

Figure 4.1: A graphical Representation of the Functions in a Function Hierarchy Diagram

To create a Function Hierarchy:

You can select the Function Hierarchy Diagrammer in two different ways, First Method (Steps 1 and 2) and Second Method (Steps 1 and 2).

First Method

  1. Go to the Repository Object Navigator and select Function Hierarchy Diagrammer. (See Figure 4.2a).

    Figure 4.2a

    Figure 4.2a: Selecting the FHD from the Repository Object Navigator

  2. By default the Function Hierarchy Diagrammer window will open with a new diagram by the name FHD1. (See Figure 4.3a).

    Figure 4.3a

    Figure 4.3a: The Function Hierarchy Diagrammer Window

On to page two

Page 1, Page 2, Page 3, Page 4 / Back to the tutorial index.

Main Page About the Book Student Resources Oracle Resources Instructor Resources Contact Us

1999 Prentice-Hall, Inc., A division of Pearson Education, Upper Saddle River, New Jersey 07458 Legal Statement
Comments should be directed to webmaster@prenhall.com