Oracle Designer Tutorial |
When you record an entity model in the repository, you are specifying the things the business needs to manipulate and about which information has to be stored. The next stage is to design a database in which to hold this information.
The Database Design Transformer, one of the Oracle Designer tools, enables you to create and maintain a database design based upon the entity model recorded in the repository. The resulting database design comprises a number of database object definitions including table definitions (to record instances of entities), column definitions (to store attributes), and foreign key constraint definitions (to implement relationships between entities). The Database Design Transformer also creates and maintains additional elements to support the design.
Like the entity model, the database design generated by the Database Design Transformer is stored in the repository. Later in the tutorial, you will use other Oracle Designer tools to create the database itself, based on this design.
During this lesson, you will use the Database Design Transformer to create new table and column definitions in the repository from the entity and attributes that you defined in the previous lesson (and from the supplied entities).
The Database Design Transformer maps entities to tables to create table definitions, and creates column definitions from attributes.
Note: The instructions below direct you to start the Database Design Transformer from the Entity Relationship Diagrammer. However, you can also start the Database Design Transformer directly from the Oracle Designer Window using the Database Design Transformer button.
To create table definitions in the repository from the design information on the entity-relationship diagram.
Note that the PRICED PRODUCT entity has no unique identifier (i.e., no attribute marked with a #). This will be created later by the Database Design Transformer.
A progress box, then the Database Design Transformer dialog box, appears.
The Design Transformer Output window appears, detailing the operations performed by the Database Design Transformer.
The Database Design Transformer creates table and column definitions from the entities and attributes. The name of the table definition is the plural version of the entity name, with spaces converted to underscores. The names of the column definitions are the attribute names with spaces converted to underscores.
In the next lesson, you will use the Design Editor to view the definitions created by the Database Design Transformer.
In this lesson you used the Database Design Transformer to create new table and column definitions in the repository from entities and attributes.
|
|