Discussion about ERD to relational schema mapping

Discussion

Discussion

by Md.Jalal Uddin Rumi (Polok) -
Number of replies: 2

There are several processes and algorithms available to convert ER Diagrams into Relational Schema. Some of them are automated and some of them are manual. We may focus here on the mapping diagram contents to relational basics.

In reply to Md.Jalal Uddin Rumi (Polok)

Re: Discussion

by Md.Muktar Ali -

ER Model, when conceptualized into diagrams, gives a good overview of entity-relationship, which is easier to understand. ER diagrams can be mapped to relational schema, that is, it is possible to create relational schema using ER diagram. We cannot import all the ER constraints into relational model, but an approximate schema can be generated.

There are several processes and algorithms available to convert ER Diagrams into Relational Schema. Some of them are automated and some of them are manual. We may focus here on the mapping diagram contents to relational basics.

ER diagrams mainly comprise of −

  • Entity and its attributes
  • Relationship, which is association among entities.

Tags:
In reply to Md.Jalal Uddin Rumi (Polok)

Re: Discussion

by Nazmul Islam -
An entity relationship diagram (ERD) shows the relationships of entity sets stored in a database. An entity in this context is a component of data. In other words, ER diagrams illustrate the logical structure of databases.