2024年4月22日发(作者：)

Getting Started with ER

win

(Erwin

入门)

by Dr. Peter Wolcott

Department of Information Systems and Quantitative Analysis

College of Information Science and Technology

University of Nebraska at Omaha（由内布拉斯加州的奥马哈大学信息科学与

技术学院门的信息系统和定量分析博士彼得著）

Introduction （介绍）

ER

win

is a popular data modeling tool used by a number of major companies

in Omaha and throughout the world. （Erwin是受奥马哈和世界各地的一些

主要的公司欢迎的数据模型工具） The product is currently owned, developed,

and marketed by Computer Associates, a leading software developer.（该

产品是由具有领导地位的CA软件开发公司拥有、开发和销售） The product

supports a variety of aspects of database design, including data modeling,

forward engineering (the creation of a database schema and physical

database on the basis of a data model), and reverse engineering (the

creation of a data model on the basis of an existing database) for a wide

variety of relational DBMS, including Microsoft Access, Oracle, DB2,

Sybase, and others.该软件为多种多样的关系型数据库管理系统,包括

Microsoft Access,甲骨文,Sybase,DB2,和其他人提供支持数据库设计的各个方

面，包括数据建模、正向工程（在现有的数据模型的基础上创建数据模式和物理

数据库） 和逆向工程（在现在的数据库基础上创建数据模型）

This brief tutorial steps you through the process of creating a data model

using ER

win

.（你可以通过这个简单教程中的步骤运用Erwin来创建数据模

型） It will not explain all aspects of ERwin, but will show you the

minimum necessary to create and use data models for this class. （这个

课程不可能全面地讲解Erwin，但它向你展示了必要的最基本的创建和使用数据

模型的知识） It consists of three major segments, which correspond to the

project-related assignments in your class: （这个课程由三个主要部分组

成，它与有关项目任务相符）

1. Creation of a basic data model (Conceptual data model) 创建一个

基本的数据模型(概念数据模型)

2. Creation of a database schema 建立数据库模式

3. Creation of the database 创建数据库

This tutorial is a static one, suitable for printing.

本教程是一个静态

的,适合印刷A tutorial using screen captures and narration is also

available. 一个指南使用屏幕捕捉和叙述是可用的。

Section 1. Creation of a basic data model

You will be creating a data model similar to that created for the Heartland

Properties case study used in class.教程中你将创建一个和研究心脏地带个

案相似的数据模型 The Entities involved in this model include: Employee,

Office, Property, and Inspection. 参与本次的实体模型包括:员工、办公、

财产、及检验。

First, invoke ER

win

from Start->Programs->Computer Associates->All

Fusion-> ERwin Data Modeler-> Erwin首先，从开始——程序——CA——所

有程序——ERwin Data Modeler

You will first encounter a dialog box entitled "ModelMart Connection

Manager"（经理ModelMart连接）. Simply click on Cancel.

将首先遇到一

个对话框题为“ModelMart Connection Manager”。只需点击“取消”。You will

be asked to choose between creating a new model, and opening an existing

model, as shown in Figure 1你将被要求之间作出选择,创造了一种新的模式,

开放一个现有的模型,如图1所示. For this exercise, create a new model.

通过这个练习,创建一个新的模型

Figure 1: Create a new model

The next dialog box, shown in Figure 2, will ask you to choose the template

to be used to create the new model. 下一个对话框,如图2所示,会让你选择

的模板可以被用来创造新的模型 At this point, you may associate the model

with a target DBMS product, such as Microsoft Access, Oracle, DB2, etc.