After designing an ER Diagram, ER diagram is converted into the tables in relational model. This is because relational models can be easily implemented by RDBMS like MySQL , Oracle etc. Following rules are used for converting an ER diagram into the tables-. In this blog, we learned about ER models and ER diagrams. We learn about entity and relationship sets, then some geometric shapes that are used to draw ER diagrams. And then we learn how to convert the ER diagram into a table. We learn the four cases of conversion of ER diagram to table with their suitable examples.
Entity relationship diagram is the graphical representation of entities and relationships among those entities in the database. Example. Conversion of ER diagrams to tables. Follow the steps given below for the conversion of the ER diagrams to tables in the database management system (DBMS) −. Step 1 − Conversion of strong entities. Relationship Set ) Table Let us rst consider binary relationship sets. To convert R as shown below A R B we create a table whose attributes include: the candidate keys of both A and B the attributes of R (if any). The candidate key of the table, however, depends on the cardinality constraint of R. See the next few slides. Converting ER Diagrams.