DEV Community

Cover image for Converting ER-Diagram to Relational Model
hebaShakeel
hebaShakeel

Posted on

Converting ER-Diagram to Relational Model

#database #computerscience

Rule 1: Conversion of an entity set into a table
a) Representation of Strong Entity set with simple attributes.
Alt Text

b) Representation of Strong entity set with Composite Attributes.
Alt Text

c) Representation of Strong entity set with a multi-valued attribute.
Alt Text
Alt Text

d) Representation of Weak entity set.
Alt Text

Rule 2: Conversion of Relationship into Relation.
Alt Text

Thank You!
See you soon again.

Top comments (0)

Read next

fleek_ profile image

Introducing Fleek Machines (Early Access): One Click Verified and Private Compute

Fleek -

lorebrada00 profile image

The Medallion Architecture: Refining Data from Bronze to Gold 🏅

Lorenzo Bradanini -

pedrohgoncalves profile image

Designing robust and scalable relational databases: A series of best practices.

Pedro H Goncalves -

megha_shivhare_5038dc1047 profile image

Which AWS Database Service is Best and Cheapest : A comparison guide

Megha Shivhare -