Masnakykentaky

Data Modeling
and Database
Design
Using ERwin

PRACTICAL
DATA MODELING and DATABASE
DESIGN USING ERWIN
• ERWIN and Its Main Features
• Data Modeling Using ERWIN
• Before Database Design
• Transforming Data Model To Database Design
• Reverse Engineering
• ERWIN Reports
• Samples

Assoc.Prof.Dr.B.G.Çetiner 2000

ERWIN and Its Main Features

Assoc.Prof.Dr.B.G.Çetiner 2000ERWIN and Its Main Features

Erwin*; A Data Modeling and Database Design Application
CASE Tool working on Windows

What is ERWIN?

* CopyRighted by Logic Works and Platinum Inc.
Assoc.Prof.Dr.B.G.Çetiner 2000

ERWIN and Its Main Features

Assoc.Prof.Dr.B.G.Çetiner 2000

ERWIN and Its Main Features
Main Features: Supported DBMSs

Main Features
Forward Engineering: TransformingData Model into Database
Reverse Engineering: Obtaining Design Info and Data Model From a Relational
Database

Relational
Data Model
Forward
Engineering

Reverse
Engineering

Relational
Database
Assoc.Prof.Dr.B.G.Çetiner 2000

Assoc.Prof.Dr.B.G.Çetiner 2000

1

ERWIN and Its Main Features

ERWIN and Its Main Features

Main Features: ORACLE Designer Data Modeling ToolMain Features: Importing Entities from BPwin

ORACLE Designer
2000 Compatible

BPWin is an activity
(process) modeling, and
data flow diagramming
tool

Assoc.Prof.Dr.B.G.Çetiner 2000

Assoc.Prof.Dr.B.G.Çetiner 2000

ERWIN and Its Main Features

ERWIN and Its Main Features

Main Features: BPWin ve ERWin

Main Features: Working Levels

STRATEGY
ANALYSIS

BPWin AnalysisProgram

DESIGN

ERWin Data Modeling
and Database Design Tool

IMPLEMENTATION

1. Logical (Conceptual) Level (Data Modeling)
2. Physical Level

DOCUMENTATION

TEST
FEEDBACK

System Development Life Cycle

Assoc.Prof.Dr.B.G.Çetiner 2000

ERWIN and Its Main Features

ERWIN and Its Main Features

Main Features: Working Levels (for Version 3.5.2)
1. Logical Level (Data Modeling)Exclusive Sub-Category

Adding Entity

Assoc.Prof.Dr.B.G.Çetiner 2000

Main Features: Working Levels

(For Version 4 )

1. Logical Level (Data Modeling)

Adding Text

Adding Entity

Exclusive Sub-Category

Non-identifying
Relationship

Selection
Non-identifying
Relationship

Changing Attributes

Identifying
relationship

Selection

Identifying
relationshipmany-to-many
relationship

many-to-many
relationship
Assoc.Prof.Dr.B.G.Çetiner 2000

Assoc.Prof.Dr.B.G.Çetiner 2000

2

ERWIN and Its Main Features

ERWIN and Its Main Features

Working Levels

Working Levels

2. Physical Level

(Version 3.5.2)

View

Independent
Table

Adding Text

2. Physical Level

Independent
Table

(Version 4)

View

SelectionNon-identifying
Relationship

Changing Columns

Identifying
Relationship

View
Relationship

Selection

Identifying
Relationship

View
Relationship

Assoc.Prof.Dr.B.G.Çetiner 2000

ERWIN and Its Main Features

Non-identifying
Relationship

Assoc.Prof.Dr.B.G.Çetiner 2000

Data Modeling Using ERWIN

Modeling and Design Stages for ERwin

Representing Entities and Attributes(Logical Level)

PRODUCE DATA MODEL

Logical Level

DESCRIBE DATA TYPES

Physical Level

ENTITY NAME
Unique Identifier Attributes
SETTINGS FOR ACCESSING DATABASE

Native or ODBC

Other Attributes
VIA SQL SCRIPTS

BY CONNECTING
TO DATABASE

REVERSE ENGINEERING

Foreign KeyAttribute

Forward
Engineering

Assoc.Prof.Dr.B.G.Çetiner 2000

Data Modeling Using ERWINAssoc.Prof.Dr.B.G.Çetiner 2000

Data Modeling Using ERWIN

Representing Entities and Attributes (Logical Level)
Composite Unique Identifiers
Entity Name
Key Area
Composite Unique Identifier
Non-Key Area

Assoc.Prof.Dr.B.G.Çetiner 2000

Other Attributes

Assoc.Prof.Dr.B.G.Çetiner 2000

3

Data Modeling Using ERWIN

Data Modeling Using ERWIN

Optionality in Attributes...