oracle intro to designer abridged

Oracle Designer Tutorial

By Anna Sidorova 1

Oracle 10G Developer SuitepOracle 10G Designer

By Anna Sidorova

Start Oracle Designer

Starting Oracle Designer 2


By Anna Sidorova 2

Log into Oracle (Connect)

• Enter your username and password

• Type ‘oracle10g’ in the Connect


String box

Tools

• Data Flow Diagrammer• Entity Relationship Diagrammer

P Di• Process Diagrammer• Functional Hierarchy Diagrammer• Matrix Designer• Database Design Transformer• Application Design Transformer


• Design Editor• Repository Object Navigator• Repository Reports


By Anna Sidorova 3

Oracle Designer Screen

To launch a specific click once on a respective icon.

Double clicking will cause the


application to shut up.

Types of objects• Business unit

– used in process modeling• Business function

– Used in process modeling, data flow modeling and functional hierarchy modeling

– Will have data flows as subordinate objects• Data store

– Used in data flow modeling– Will have data flows as subordinate objects

• Entity Has attributes relationships and primary keys as


– Has attributes, relationships and primary keys as subordinate objects

• Diagram – contains all the diagrams and matrices• External Entities (sources and sinks)• Table definitions, etc


By Anna Sidorova 4

You can view your objects through the Repository object navigator


• Open the Entity Relationship Diagramer• Click New Diagram, select a container the same way as

for DFD

Creating a Entity Relationship Diagram

for DFD• Add entities and relationships using the icons at the top

of the screen


• Name your elements using the dialog boxes that pop up• To modify information about each of the elements,

double click on the element and use the dialog window


By Anna Sidorova 5

Your ERD should look something like this …


• In order to specify subtype-supertype relationship, you place the subtype inside of the supertype

Modify information about entities, add attributes



By Anna Sidorova 6

Modify information about relationships, including Min and Max cardinalities


• You can change the font and color of your elements using the

Formatting diagrams

elements using the following icons.

• You can drag elements on the diagram in order to better reposition them

• You can add summary


You can add summary information to the diagram by selecting File/Summary Information


By Anna Sidorova 7

• Open the Matrix Diagrammer• Click New Diagram, select a container the same way as

for the other diagrams

Creating a Matrix

for the other diagrams• Select element that you would like to appear as rows and

as columns


• For a Crud Matrix, select functions as rows, and entities as rows

• Select information to appear as column and row labels

Creating a CRUD Matrix

• Select information to appear as column and row labels and on the intersection or columns and rows



By Anna Sidorova 8

Your final CRUD Matrix will look like this


• Open the Repository report tool• Select the appropriate report type and double click on the

report name

Viewing and printing reports

report name



By Anna Sidorova 9


Database Design Transformer

• Allows to transform an ERD into a database (server model)

• Produces Server model and Table definitions• In order to run transformer

– Open Database Design Transformer– Select the container



By Anna Sidorova 10

Transforming the Database design• On the database design transformer dialog box view and

modify settings and then click Run


Editing the Database design

• Open the database design editor• Select Server model• Select container and click Create/Edit

DB objects• Select Tables and Columns



By Anna Sidorova 11

Editing the Database design (cont’d)

• Select all tables and click Diagram

• Now you can view and edit the database design


Generating tables• Once you are satisfied with your DB design you can use

the Design Editor tool to generate table for you r oracle DatabaseDatabase

• Go to Menu/Generate/Generate Database from Server model

• You will need to provide login information for the DB once again


• Click Start


By Anna Sidorova 12

Generating tables• Somewhere along the way a message will pop up …

• Click View DDL (Data Definition Language)

• A number of text files ill


will open. • Make sure you save all

of them!!!• You can now click

Execute DDL

Generating tables (cont’d)• A progress report will tell you if tables were created successfully

• You can now check if the tables have been created bytables have been created by logging into the SQL*Plus, typing – DESCRIBE [TableName];


oracle intro to designer abridged

Documents

rowsstarting oracle

oracle designer screento

data flow modeling

subordinate objects

matrix diagrammer

data flows

subordinate objects

subordinate objects