Oracle Designer 6i First Class: Analysis

This is the first course in a two part series which covers the same material as the first half of the Instructor Led course Oracle Designer 6i: First Class. The course takes students along a streamlined path through the Oracle Designer development environment. It covers recording business requirements into the Repository including process modeling entity relationship modeling and function modeling. This course is part of an Oracle integrated curriculum and forms the core course to all the Oracle Designer courses.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

Targeted audiences for this course are: Business Analysts; Project Leaders; Designer/Developers; Web Application Developers; Data Administrators and Database Administrators. There are no prerequisites for this course.

Objective

• Identify and perform the primary tasks to implement an Oracle Designer project.
• Input business system requirements into the Oracle Designer Repository.

Topics Include

Unit 1: Oracle Designer: Introduction

• Identify the phases of the development life cycle.
• Identify the features of Oracle Designer.
• Identify the uses of the Process Modeller within Oracle Designer.
• Identify the uses of the Entity Relationship Diagrammer.
• Identify the uses of the Function Hierarchy Diagrammer.
• Identify the uses of the Matrix Diagrammer.
• Identify the uses of the Dataflow Diagrammer.
• Identify the uses of the Applications Design Transformer.
• Identify the uses of the Database Design Transformer.
• Identify the uses of the Design Editor.
• Identify the characteristics of the techniques involved in system development.
• Identify the components of a Process Model.
• Identify the components of a Function Hierarchy Diagram.
• Identify the components of an Entity Relationship Diagram.
• Identify the components of a Matrix Diagram.
• Identify the structural components that Oracle Designer uses for storing information in the Repository.
• Perform the steps required to create a work area.
• Perform the steps required to invoke the Repository Object Navigator using the Front panel icon.
• Perform the steps required to create an application within the Repository Object Navigator.
• Perform the steps required to view the details of a Repository element using the Repository Object Navigator window.
• Perform the steps required to rename an element in the Properties window.
• Perform the steps required to create an Element in the Repository using the Repository Object Navigator.

Unit 2: Analysis Models

• Perform the steps required to create a process model using the Process Modeller.
• Perform the steps required to create an organization unit using the Process Modeller.
• Perform the steps required to create a process step using the Process Modeller.
• Perform the steps required to create a flow line using the Process Modeller.
• Perform the steps required to decompose a process step in a process diagram using the Process Modeller.
• Perform the steps required to create an event using the Process Modeller.
• Identify how a process model reflects a business scenario.
• Perform the steps required to create an empty entity relationship diagram using the Entity Relationship Diagrammer.
• Perform the steps required to create an entity using the Entity Relationship Diagrammer.
• Perform the steps required to create a relationship between two entities using the Entity Relationship Diagrammer.
• Perform the steps required to define an attribute for an entity using the Edit Entity dialog box in the Entity Relationship Diagrammer.
• Perform the steps required to define a domain using the Entity Relationship Diagrammer.
• Perform the steps required to associate an attribute with a domain using the Entity Relationship Diagrammer.
• Perform the steps required to assign a unique identifier to an entity using the Entity Relationship Diagrammer.
• Identify how an entity relationship model reflects a business scenario.
• Perform the steps required to create a function hierarchy diagram using the Function Hierarchy Diagrammer.
• Perform the steps required to create a business function using the Function Hierarchy Diagrammer.
• Identify the functions in a business that should be automated.
• Perform the steps required to define how a specific function uses data using the Function Hierarchy Diagrammer.

Unit 3: Checking the Analysis Models

• Perform the steps required to create a cross-checking matrix using the Matrix Diagrammer.
• Perform the steps required to use the Settings option in the Matrix Diagrammer to modify a matrix.
• Perform the steps required to update a function entity usage matrix using the Matrix Diagrammer.
• Validate a function entity usage matrix using a given business scenario.
• Perform the steps required to create a matrix which cross-checks analysis-related elements using the Matrix Diagrammer.
• Identify the benefits of checking the quality of an analysis model.
• Identify the checks that need to be applied to the work of the analysis phase.
• Perform the steps required to create a quality-check report using Oracle Designer Repository Reports.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

• Oracle Designer 6i First Class: Design and Generate