如何绘制e-r图并将其转换成关系数据模型（How to draw a E-R diagram and convert it into a relational data model）.docVIP

如何绘制e-r图并将其转换成关系数据模型（How to draw a E-R diagram and convert it into a relational data model） How to draw the E-R diagram and converts it into a relational data model E-R is the main tool to describe the conceptual data model, using the E-R chart method to realize the concept of structure design called E-R method; conceptual design is the first stage of database design, so E-R is a very important point. Figure E-R also known as the entity relationship model (E-----entity, R-----relation), composed of entities, attributes, the three components of contact. Graphic symbols: entity (rectangular), attributes (Tuo Yuan), contact (diamond) E-R drawing method: 1, draw data flow chart 2, analysis of the data dictionary 3, to determine the local E-R map: A, draw the part of the entity E-R B draw E-R diagram, which is the link between the entities figure: 4, the integration of complete E-R graph, namely between all entities. Methods E-R diagrams into relational model: Just remember the following conversion principle, can: (1) the conversion of an entity for a relationship, is the relationship between the attributes of the entity attribute, entity relationship code is the code (2) a link into a relationship, contact properties of contact connected entity code into a relational attribute, but the code will change according to the type of connection, if it is: 1:1, both entities have become the candidate code code 1: multiple contact end entity code has become the relationship between code How much: contact ends are combined into the relation between the entity code code (3) the same code can be combined with In the bottom-up approach to the design of the conceptual structure as an example, it is usually divided into two steps: The first step: first, according to the result of requirement analysis (data flow diagram, data dictionary and so on) of the real world data abstraction, design of each local view namely E-R map. The second step: integrated local view. The conceptual structu