ERwin使用说明(中英文)

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.