ER
diagrams can be mapped to relational schema, that is, it is possible to
create relational schema using ER diagram.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.