从简单词汇开始理解ERWin:Attribute, Entity, Logical Model, Physical Model, Domain, Cardinality

1. Attribute : [普] 属性, 品质, 特征

Represents[表现,描绘] a type of characteristic or property with a set of real or abstract things(People, Places, Events and so on);
个人理解: Attribute对应着数据库中的Column, 对应OOP中的Propertie

2. Entity: [普] 实体

An Entity represents a set of real or abstract things(People, Places, Event and so on) that have common attributes or characteristics.
个人理解: Entity对应着数据库中的Table, 在OOP端, 则对应着一个Class.

3. Logic Model\Physical Model: [普] 逻辑模型\物理模型

由于数据库厂商实在太多, 如MS SQL, MySQL, DB2, Oracle等, 在DataType, SQL语句, 命名原则方面, 各有不同,
在设计数据库时也许要考虑到日后数据库的更换, 着眼于长远,我们需要设计一个与具体厂商无关的Model,, 这便是Logic Model.

同时又需要设计一个具体的Model, 这个Model直接与某个厂商某个数据库版本相适应, 这便是Physical Model

4. Domain, Cardinality

…待续…

This entry was posted in 计算机英语 and tagged , , . Bookmark the permalink.

One Response to 从简单词汇开始理解ERWin:Attribute, Entity, Logical Model, Physical Model, Domain, Cardinality

  1. GarykPatton says:

    I have been looking looking around for this kind of information. Will you post some more in future? I’ll be grateful if you will.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>