如何绘制E-R图并将其转换成关系数据模型(国外英文资料).docVIP

如何绘制E-R图并将其转换成关系数据模型(国外英文资料) How do you draw an e-r diagram and transform it into a relational data model The e-r diagram is the main tool for describing conceptual data models, using e-r diagrams for conceptual structural design approaches called e-r methods; Conceptual design is the first stage of database design, so e-r is an extremely important test point. The e-r graph is also known as an entity-contact model (e-entity, r-e-s), consisting of entities, attributes, and associations. Graphic symbol: entity (rectangle), attribute (ellipse), contact (rhombus) How to draw the e-r diagram: 1, draw data flow charts Data dictionary analysis 3, identify the local e-r diagram: A, and draw some of the entities e-r B, draw the e-r diagram, the link between the entities: 4, integrate the complete e-r diagram, which is the contact diagram between the entire entities E-r diagrams are transformed into relational models: Just remember the following transformation principles: (1) an entity is transformed into a relationship, the property of the entity is the property of the relationship, the entitys code is the code of the relationship (2) a contact also converted to a relationship, contact properties of the connected entity code is converted to the relationship between the attributes, but the relationship between the code will vary according to the type of the connection, if it is: The one-to-one connection, the code of the two entities is the candidate code for the relationship 1: multiple connections, the code of the end entity becomes the code of the relationship More: multiple connections, the combination of the two body codes becomes the code for the relationship A relationship that has the same code can be merged For example, the approach of designing conceptual structures from the bottom up is usually divided into two steps: The first step: first of all, according to the result of requirement analysis (data flow diagram, data dictionary, etc.) to the real world data abst