Overview of Oracle Designer Database Development Process Business

Overview of Oracle Designer

Database Development Process Business Information Requirements Conceptual Data Modeling Business view Logical Database Design Systems view Physical Database Build Operational Database

Application Development Process Business Process Requirements Systems Modeling Application Design Application Build Operational Database Business view Systems view

Database Development Process Business Requirements Process Function hierarchy, function definition Module (screen, report, menu, PL/SQL utility) Cross-checking Conceptual Data Modeling System Modeling Application Design Information Cross-checking Application Build Database Design Database Build Application Database Operational System ER model, entity definition Table, index, view

Oracle Designer Analysis Information Applications Design

Function hierarchy diagramer Modeling the Enterprise Analysis Information Applications Business Functions Business process modeler Design

Function hierarchy diagrammer Modeling the Information Analysis Entity-Relationship Diagrammer Information Applications Business Functions Business process modeler Design

Matrix Diagrammer Function hierarchy diagrammer Correlating Functions & Data Analysis Entity-Relationship Diagrammer Information Applications Business Functions Business process modeler Design

Matrix Diagrammer Function hierarchy diagrammer First Cut at the DB Design Analysis Entity-Relationship Diagrammer Applications Information Business Functions Database Design Transformer Business process modeler Server Model Diagram Design

Matrix Diagrammer Function hierarchy diagrammer Generating the Database Analysis Entity-Relationship Diagrammer Applications Information Business Functions Database Design Transformer Business process modeler Server Model Diagram Generate Database Design

Matrix Diagrammer Function hierarchy diagrammer Defining Display Properties Analysis Entity-Relationship Diagrammer Applications Information Business Functions Database Design Transformer Business process modeler Server Model Diagram Generate Database Design Editor

Matrix Diagrammer Function hierarchy diagrammer Designing Applications Analysis Entity-Relationship Diagrammer Applications Information Business Functions Database Design Transformer Business process modeler Server Model Diagram Application Design Transformer Modules Generate Database Design Editor

Matrix Diagrammer Function hierarchy diagrammer Generating Applications Analysis Entity-Relationship Diagrammer Applications Information Business Functions Database Design Transformer Business process modeler Server Model Diagram Application Design Transformer Modules Application Generators Generate Database Design Editor

The Repository Analysis Information Applications Repository Reports Repository Object Navigator Repository Administration Design