Practical Approaches of Transforming ER Diagram into Tables

Design is the first and best step to start a good database system, also understanding system’s requirements will lead to a good design. Additionally, having a robust design will create a robust system. One of the most common methodologies for designing relational database is Entity Relationship (ER) model. However, converting ER into relations is the point of view which should be concerned by database designers. This paper will explain what ER model is and argue the approaches of mapping ER diagram into tables, in addition it decides which approach is the most suitable in term of implementation.