Question

Discuss the steps you would take to transform an ER Model into various
relations of Relational Data Model. Give suitable examples.

Answer 1

Steps to transform ER Model into Relational Data Model.

Explanation:

ER Model gives a good overview of the entity-relationship when conceptualized into diagrams. We can build a relational schema using ER diagrams.

The following are the key points to generate a relational database schema using the ER diagram.

• The entity is converted into Table, with all the attributes in the table becoming fields (columns).
• The relationship between entities is also converted into a table with the related entities ' primary keys also stored in it as foreign keys.
• Primary Keys should be properly set for each table.
• For any Weak Entity relationship, a foreign key restriction must be established if the primary key of any other entity is included in a table.