Getting Started with ERwin (Erwin入门)
by 临汾攻坚战Dr. Peter Wolcott
Department of Information Systems and Quantitative Analysis
College of Information Science and Technology
University of Nebraska at Omaha（由内布拉斯加州的奥马哈大学信息科学与技术学院门的信息系统和定量分析博士彼得著）
Introduction （介绍）
ERwin is a popular data modeling tool ud 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 databa design, including data modeling, forward engineering (the creation of a databa schema and physical databa on the basis of a data model), and rever engineering (the creation of a data model on the 数学小报图片
basis of an existing databa) for a wide variety of relational DBMS, including Microsoft Access, Oracle, DB2, Syba, and others.该软件为多种多样的关系型数据库管理系统,包括Microsoft Access,甲骨文,Syba,DB2,和其他人提供支持数据库设计的各个方面，包括数据建模、正向工程（在现有的数据模型的基础上创建数据模式和物理数据库） 和逆向工程（在现在的数据库基础上创建数据模型）
This brief tutorial steps you through the process of creating a data model using ERwin.孜然羊肉家常做法（你可以通过这个简单教程中的步骤运用Erwin来创建数据模型） It will not explain all aspects of ERwin, but will show you the minimum necessary to create and u data models for this class. （这个课程不可能全面地讲解Erwin，但它向你展示了必要的最基本的创建和使用数据模型的知识） It consists of three major gments, which correspond to the project-related assignments in your class: （这个课程由三个主要部分组成，它与有关项目任务相符）
1. Creation of a basic data model (Conceptual data model) 创建一个基本的数据模型(经济学好就业吗概念数据模型)
2. Creation of a databa schema 建立数据库模式
3. Creation of the databa 创建数据库
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 ca study 梁子湖风景区ud in class.教程中你将创建一个和研究心脏地带个案相似的数据模型 The Entities involved in this model include: Employee, Office, Property, and Inspection. 参与本次的实体模型包括:员工、办公、财产、及检验。
南园遗爱First, invoke ERwin 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 choo between creating a new model, and opening an existing model, as shown in Figure 1你将被要求之间作出选择,创造了一种新的模式,开放一个现有的模型,如图1所示. For this exerci, create a new model. 通过这个练习,创建一个新的模型
Figure 1: Create a new model防火安全教育知识
The next dialog box, shown in Figure 2, will ask you to choo the template to be ud 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. 在这一点上,你可以把这个模型与如Microsoft Access,甲骨文,DB2等目标数据库产品联系在一起 You will have the opportunity to change this choice later, but for now choo Microsoft Access. 你之后将有机会改变这种选择,但是现在选择Microsoft Access。 Also, choo Logical/Physical as the new model type. 同时,选择的逻辑或者物理作为新模型形式 This choice will allow us to switch back and forth easily between a logical model (ER Diagram) and a physical model (databa schema). 这个选择将让我们轻易之间来回切换逻辑模型(ER创造性思维的核心图)和物理模型(资料库)
