Detailed Topics

Introduction

• Objectives

Oracle Method Overview

• 7 Stages of CASE*Method
• Overview of Entity Relationship Modeling
• Entities
• Attributes
• Domains
• Relationships (not Relations)
• Reading Relationships
• Recursive Relationships
• Unique Identifiers (UID)
• Resolving M:M Relationships
• Super/subtype Entity Structure
• Arcs
• Transforming E/R Model to Relational Database Design
• Super/subtype Design Choices
• Functional Hierarchy Modeling
• Elementary Functions
• CRUD

Designer/2000

• Repository Structure
• Two "Categories" of Elements
• Element Text
• Right Mouse Button (RMB) Menu
• Designer/2000 Front Panel
• Oracle Designer Analysis Tools
• Design Tools
• Generators
• Utilities
• Repository Administrator
• Repository Reports
• Report Browser
• Designer Lifecycle
• Key Analysis Element Definitions

Repository Object Navigator (RON)

• Meet RON
• Running RON
• Context Sensitive Help
• Creating New Application Systems
• Open Existing Applications
• Sorting Element Types
• Two Navigator View Modes
• Creating Elements/Objects
• Setting Properties
• Textpad for Text Properties
• Working with Multiple Elements Default View
• Multiple Elements in Spreadtable View
• Deleting Elements
• Copying and Pasting Properties
• Creating Associations/Usages
• Deleting Associations/Usages
• Right Mouse (RMB) Menu

Customizing RON

• Customizing RON
• RON Options
• Setting Fonts
• Setting Text Color
• Sorting Elements by Property
• Splitting Navigator Window
• View Group Mode
• Working with Groups
• Creating Custom Groups
• Creating New Groups
• Creating Views
• Filtering Elements
• Hierarchy View
• Collapsing/Expanding Nodes
• Navigation
• Finding Elements in Current Navigator Window
• Searching the Repository
• Results of Search
• Associated Usages
• Pinning & Multiple Property Windows
• Reminder: Right Mouse Menu
• Other Things to Explore

Entity Relationship Diagrammer

• Objectives
• Entity Relationship Diagrammer Features
• Running the Diagrammer
• Context Sensitive Help
• Shortcut Keys
• Right Mouse Menu (RMB)
• File Manipulation
• Changing Applications and Connections
• Navigating in the Diagram
• Window Manipulation
• Fonts, Colors and Lines
• Selecting Elements
• Creating Entities
• Moving and Resizing Entities
• Including Existing Elements
• Including Related Entities
• Creating Relationships
• Relationship Definition Dialog
• Moving Relationships
• Doglegging Relationship
• Creating Arcs
• Deleting Elements from Repository
• Cutting Elements from Diagram
• Requery to Consolidate Diagram with Repository

Detailed ER Information

• Entity/Attribute Detailed Dialog
• Entity Synonyms
• Unique Identifier Definition
• Attribute Definition (Part I)
• Attribute Details
• Attribute Values
• Entity/Attribute Text
• Domain Definition Dialog (Part I)
• Domain Definition (Part II)
• Domain Detail
• Domain Definition Values

Advanced Diagrammer Features

• ERD Customization
• Summary Information in ERD
• Printing Diagrams
• Navigating and Selecting by Name and Type
• Cutting, Copying and Pasting
• Autolayout
• Minimize Number of Pages
• Rescale Diagram
• Incorporating Other Objects in ERD

Function Hierarchy Diagrammer (FHD)

• Function Hierarchy Diagrammer Features
• FHD Customization
• File Menu
• Creating New Diagrams
• Creating New Functions
• Adding & Removing Hierarchies from Diagram
• Relocating Functions
• Requery
• Changing Hierarchy Focus
• Navigating by Name and Disjoint Legs
• Hybrid Layout
• Vertical Layout
• Horizontal Layout
• Vertical Layout Selection
• Horizontal Selection
• Collapsing and Expanding Legs
• Summary Information

Detailed Function Definition

• FHD Detailed Definition Dialog
• Function Entity Usage Dialog
• Function Attribute Usage Dialog
• Common Functions
• Business Function Text
• Business Function Trigger Dialog
• Business Units

Process Modeller

• Features
• "Common" Features
• Creating New Diagrams
• Customization
• Creating Organizations
• Hiding Child Organization
• Resizing and Moving Organizations
• Creating Processes
• Creating Flows
• Creating Stores
• Creating Triggers & Outcomes
• Process Specific Information
• Store Specific Information
• Flow Specific Information
• "Main" Information
• Resource Information
• Text
• View Options
• Symbol Mode
• Enhanced Symbol Mode

Multimedia Features

• Iconic Mode
• Specifying Multimedia
• Selecting Multimedia
• Configuring Multimedia
• Video
• Images
• User Commands

Animation

• Animation
• Animation Options
• Controlling Animation
• ANDed Flow Blocking

Advanced Features

• Advanced Configuration Overview
• Reports
• Exporting

CRUD and the Matrix Diagrammer

• Creating "CRUD"
• Matrix Diagrammer Features
• Creating a Diagram
• Settings for Displaying Rows & Columns
• Changing Order of Displayed Properties
• Determining Associations’ Displayed Properties
• Working with Elements
• 3-Dimensional Matrix
• Selecting Elements
• Colors and Fonts
• Pinning and Unpinning Property palette
• Iconic View
• Full Size Mode
• Summary Information (Printed, Not Displayed)
• Force Element Deletion
• Validation and Verification Reports

Default Database Design

• Database Design Overview
• Database Design Steps
• Transformation from E/R Model to Database Design
• Database Design Transformer Welcome
• Database Design Transformer Dialog
• Transformer Settings - Database
• Transformer Settings – Keys
• Transformer Settings - Other
• Transformer Run Options
• Examine Run Set
• Run Dialog
• Column Attribute Mappings
• UID Primary Key Mappings
• Relationship Foreign Key Mappings
• Foreign Key Index Mappings

Intro to Design Editor

• Design Editor Overview
• Tailoring for Professional Use
• Wizalogs
• Disabling Dialogs
• Property Palette
• Property Palette Customization
• Property Palette Spread Table
• Design Editor Navigator
• Navigator Usages
• Creating Elements
• Fast Creation
• Deleting Elements

Detailed Database Design

• Schema Metamodel
• Database Definition
• User/Schema Definition
• Adding Schema Objects to User/Schema
• Sequence Definition Dialog (Server Model)
• Sequence Implementation (DB Admin)
• Table Definition Properties (Various)
• User Help Text
• Table Implementation (DB Admin)
• Column Definition (Server, Module)
• Column Display Properties
• Column Derivation, Autogeneration
• Column Derivation, Validation, Help
• Column Allowable Values
• Primary Key Constraint
• Primary Key Columns
• Foreign Key - Referential Integrity and Actions
• FK Columns
• Check Constraint
• Access
• Indexes
• Defining Views
• View Definition Properties
• View SELECT Text
• View WHERE Text
• View Column Properties
• Selecting Base Column
• Server Model (Data) Diagram)
• Creating Diagrams from Existing Objects

Database Generation

• Server/DDL Generator Features
• DDL Generator Object Selection Tab
• DDL Generator Options Tab
• Additional Options
• Generator Message Windows
• Generator for Reference Tables
• User Help Text
• Generating Help

Application Design

• Features of Generated Forms
• Application Design Transformer
• Module Acceptance

Refining Module Detail

• Module Definition Properties
• User Help
• Module Meta-Model
• Basic Component Properties
• Detailed Table Usage
• Detailed Column Usage
• DCU Display Properties
• Ordering, Help

Form Generation

• Basic Form Generation
• Form Option (Source Destination)
• Compile Tab (Destination of Executable)
• Run Options Tab
• Template Options Tab
• Other Options Tab
• Generator Runtime Dialog
• Error Processing
• Basic User Preferences
• Generator Preference Palette
• Sample Preferences

Table Links

• Anatomy of a Form
• Master/Detail with Lookups
• Table Links Overview
• Define Basic Functionality in Module Diagram
• More Features
• Display View
• Navigator Tips
• Tips for Display Mode
• Displaying Additional Properties
• Generate Default Links
• Descriptors
• More on DCU/Items and Foreign Keys
• Employee with Lookups
• Department/Employee Master/Detail
• Master/Detail Detail
• Chained Lookups
• Chained Lookup Notes
• Matrix Form
• Overview of Block Positioning and Layout

Generating Oracle Reports

• Report Features
• Report Module Properties
• DTU Properties
• Report Column Properties
• Copying Modules (and Other Elements)
• Report Linking
• Generating Reports
• Report Generator Options
• Report User Preferences
• Sample Preferences for Reports
• Overview of Summary Functions

Default Menu Design and Generation

• Menu Overview
• Default Menu Design
• Module Acceptance
• Generate Application Menu
• Problems with Menu Generation?
• Menu Customization via Structure Diagrammer

In 5 Days

• You built a complete application system with database, Forms, Reports and Menus
• What You Didn’t Do...

Lab Exercises

Introduction to Labs

• Lab 1 - Objectives
• Lab 2 - CONSART Systems

Strategy and Analysis Stage Labs

• Lab 1 - Introduction
• Lab 2 - Create and Set Working Directory
• Lab 3 - Meet RON
• Lab 4 - Examine User Interface Features (Optional)
• Lab 5 - Create E/R Diagram
• Lab 6 - Add Detailed Information, Attributes and Domains
• Lab 7 - Experiment with ERD User Interface (Optional)
• Lab 8 - Create Function Hierarchy Diagram
• Lab 9 - Experiment with Function FHD User Interface (Optional)
• Lab 10 - Detailed Function Definition
• Lab 11 - Process Modelling
• Lab 12 - Create and Refine Function/Entity CRUD
• Lab 13 - Create and Refine Function/Attribute CRUD
• Lab 14 - Define Business Units
• Lab 15 - Run Quality Assurance Reports

Database Design Stage Labs

• Lab 1 - Create Default Database Design
• Lab 2 - Refine Database Design
• Lab 3 - Run Quality Assurance Reports
• Lab 4 - Generate Database

Application Design Stage Labs

• Lab 1 - Create and Refine Application Design

Application Generation Labs

• Lab 1 - Generate Simple Forms
• Lab 2 - Generate Complex Forms
• Lab 3 - Generate Reports
• Lab 4 - Design and Generate Menu Application

Copyright © 1999 Jeffrey Jacobs & Associates
Last modified: June 17, 2003