er图转换成关系模型
关系 (Relations)
Relations specify that how a entity of a entity set is related to the entity of other set.
关系指定一个实体集的实体如何与另一个集的实体相关。
关系类型 (Types of Relationship)
There are following types of relationships
有以下几种关系
1) One to One
1)一对一
Every element of the first set is related to almost element of the entity set & Vice versa.
第一组的每个元素都与实体组的几乎所有元素相关,反之亦然。
2) One to Many
2)一对多
A relationship is said to be one to many if every entity of the first entity set can relate to any number of entity of other entity set. But every entity of the other entity set can relate to almost One entity of the first entity set.
如果第一个实体集的每个实体都可以与其他实体集的任何数量的实体相关,则称这种关系为一对多。 但是其他实体集中的每个实体都可以与第一个实体集中的几乎一个实体相关。
3) Many to Many
3)多对多
A relationship is said to be Many to many if any entity of the first entity set may relate to any one of the entities of other entity set and vice versa.
如果第一个实体集的任何实体可能与其他实体集的任何一个实体相关,则关系被称为“多对多”。反之亦然。