Tutorial for Designer/2000
and Developer/2000

Lesson 7

In this lesson you will learn to create matrix diagrams using the Function Hierarchy Diagrammer and the Matrix Diagrammer. Specifically, this will involve:

What is a Matrix Diagram?

It actually consists of one 2-dimensional table. In the context of our project using Designer/2000, the matrix is the CRUD matrix. CRUD stands for Create, Retrieve, Update and Delete. The matrix displays the entity names in the columns and the function names in the rows. The intersection cell of the row and the column will show you the entity that will be manipulated in order to accomplish a particular function and will display the CRUD properties for that intersection.

See Figure 7.1 to view the graphical representation of the matrix diagram and its various components.

Figure 7.1

Figure 7.1: Graphical Representation of the Matrix Diagram

  1. The first step in creating the CRUD matrix is to establish the relationships among the functions and entities that we have defined in Lessons 4 and 5 respectively. To do this, invoke the Function Hierarchy Diagrammer (See lesson 4), and open the diagram FHDSRS that we had saved earlier. (See Figure 7.2).

    Figure 7.2

    Figure 7.2: Selecting the FHDSRS diagram from the Function Hierarchy Diagrammer

  2. You will now see the FHDSRS diagram that you had created in Lesson 4. (See Figure 7.3).

    Figure 7.3

    Figure 7.3: The FHDSRS diagram created in Lesson 4

  3. Now, double click on the function Insert Student Records (SRS1.1). You will immediately come to the Edit Function window. Click on the tab, Entity usages. (See Figure 7.4).

    Figure 7.4

    Figure 7.4: The Edit Function window

  4. You should now see the Entity Usages window. Click on the down arrow under entity and you will see the two entities that you created in Lesson 5. Since the function we are modifying is the Insert Student Records, it will be using the Student entity. So, click on Student. (See Figure 7.5).

    Figure 7.5

    Figure 7.5: The Entity Usages window

  5. Now click on the checkbox under Create and click OK. (See Figure 7.6).

    Figure 7.6

    Figure 7.6: selecting the CRUD properties

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