Understanding What to Model

Documenting the Business Background

Building a Process Model (Data Flow Diagram)

Using Oracle SQL Developer Data Modeler to Create Your Process Model (Data Flow Diagram)

Validating Your Process Model (Data Flow Diagram)

Identifying Entities and Attributes

Identify Relationships

Assign Unique Identifiers

Using Oracle SQL Developer Data Modeler to Create the Entity Relationship Diagram

Validating your Entity Relationship Diagram

Normalizing your Data Model

Validating Relationships

Adding and Using Data Types

Put It All Together

Map Your Entity Relationship Diagram to a Relational Database Design

Engineering Your Entity Relationship Diagram to a Relational Database Design in Oracle SQL Developer Data Modeler

Defining Your Physical Model

Generating Your Database

Altering an Existing Design

Working in a Collaborative Environment


＂