计算机专业英语chapt4_3Structure of the Relational Database II.ppt

Words attribute n. 属性 bonus n. 奖金 conceptualize v. 使有概念，构思 derive v. 得自，起源 enrollment n. 登记，注册，入伍，入会，入学 iterate v. 反复说，重申，重述 restrict v. 约束，限制 Phrases correspond to 相应，符合 vice versa 反之亦然 数据建模 斯科特在创建数据库的真实表之前，要经过一个称作数据建模的过程。在这个过程中，数据库创建者定义和填写数据库中的所有表。一种为数据库建模的常用方式叫作ERA，ERA可以表示出实体、实体间的关联和实体的属性。 Data Modeling Before Scott created the actual tables in the database, he went through a design process known as data modeling. In this process, the developer conceptualizes and documents all the tables for the database. One of the common methods for modeling a database is called ERA, which stands for entities, relationships, and attributes. 4.3 Structure of the Relational Database II 数据库设计者使用一个能够支持实体、实体属性和实体间关联的应用程序。通常，一个实体对应数据库中的一个表，而实体的属性对应于表中的列。 The database designer uses an application that can maintain entities, their attributes, and their relationships. In general, an entity corresponds to a table in the database, and the attributes of the entity correspond to columns of the table. 数据建模：定义实体、实体属性和实体间关联的过程，为建立物理数据库做准备。 Data Modeling：A process of defining the entities, attributes, and relationships between the entities in preparation for creating the physical database. 数据建模过程包括定义实体、定义实体间关联以及定义每个实体的属性。一个周期完成后需要不断重复，直到设计者抓住了足以建立数据库的重点。让我们进一步了解数据建模过程的各个步骤。 The data-modeling process involves defining the entities, defining the relationships between those entities, and then defining the attributes for each of the entities. Once a cycle is complete, it is repeated as many times as necessary to ensure that the designer is capturing what is important enough to go into the database. Lets take a closer look at each step in the data-modeling process. 定义实体 首先，设计者确定数据库应用程序范围内的所有实体。实体是机构中重要的且需要记录在数据库中的人、地方或事物。实体将巧妙地转化为数据表。 Defining the Entities First, the designer identifies all of the entities within the scope of the database application. The entities are the persons, places, or things that ar