Tutorial for Designer/2000
In this lesson we will learn to transform the conceptual data model (the E-R model created in lesson 5) to actual tables in the database.
To do this:
- While your E-R model is still open, go to Utilities Database Design Transformer. (See Figure 6.1).
Figure 6.1: The Utilities Drop-Down Menu in the E-R Diagrammer
- The dialog box for the database Design Transformer will appear. Make sure that "Run the transformer" and "All entities" are selected and press the Run button. (See Figure 6.2).
Figure 6.2: The Run Transformer Window
- You will notice that the Database Design Transformer Output Window will pop up showing you the status of the transformation. When it will show "Waiting for Close to be pressed", press the Close button. (See Figure 6.3).
Figure 6.3: The Database Design Transformer Output Window
- Now go to the Designer/2000 launchpad once again and select the Design Editor. (See Figure 6.4).
Figure 6.4: The Designer/2000 Launchpad
- You will see the Design Editor Welcome Screen. Select the Server Model Option, and click OK. (See Figure 6.5).
Figure 6.5: The Welcome to the Design Editor Screen
On to page two
Page 1, Page 2, Page 3 / Back to the tutorial index.
About the Book
©1999 Prentice-Hall, Inc., A division of Pearson Education, Upper Saddle River, New Jersey 07458 Legal Statement
Comments should be directed to firstname.lastname@example.org