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

thepracticaldev profile image

Join us for the Open Source AI Challenge with pgai and Ollama: $3,000 in Prizes!

dev.to staff -

maurine profile image

Employee Management System Using SQL

Maurine Nyongesa -

silvio_riveros_49b5505866 profile image

Migrar de SQLite a MySQL.

Silvio Riveros -

mcadariu profile image

Hierarchical data with PostgreSQL and Spring Data JPA

Mircea Cadariu -