Oracle Designer Tutorial |
The database design created by the Database Design Transformer from the entity relationship model consists of a set of interrelated tables, columns and constraints. This is often referred to as the ‘first-cut database design’. The design objects that make up the first-cut database design can be represented on one or more server model diagrams and refined to a level ready for implementation.
After you have produced the first-cut database design, you can begin to make improvements to the design itself, and to establish defaults for how generated applications will use data. The process of amending and enriching the database design is one of the most important tasks in the application system development lifecycle.
The Design Editor, one of the Oracle Designer tools, enables you to model database designs on server model diagrams. Each server model diagram represents a collection of database objects that can be distributed physically between one or more databases. Using the Design Editor, you can add more information to the first-cut design produced by the Database Design Transformer.
During this lesson, you will refine the definition of tables that you created in the previous lesson.
The Database Design Transformer has converted the entity relationship model into design-level table and constraint definitions held in the repository.
To prepare the default design for implementation, you now add extra information that was not relevant during the analysis phase of development.
To refine the definition of tables that you created in the previous lesson.
An alternative method is to drag and drop the relational table definition names into the blank area of the Design Editor window.
A server model diagram is created in a separate window within the Design Editor. You may have to zoom out to see all of the diagram.
Note that PRICED_PRODUCTS now has a primary key (PP_ID).
The following steps will add a column that could be used to record which user created the order. This is to familiarize you with the tool and will not be part of the form that you generate in later lessons.
The new column name appears in the diagram object representing the ORDERS table.
The property names for a particular object are listed in the cells in the left column. The values for the properties are listed in the cells in the right column. When you click on a values cell, it changes to an appropriate input control. The controls you will be using are the text box and the drop-down box.
Keep the Design Editor running, ready for the next lesson.
In this lesson you used the Design Editor to refine the definition of tables that were created by the Database Design Transformer.
|
|