Procedure for Mapping ER Database Schema to a

Relational Schema

$$ Step $1$: Mapping of Regular Entity Types

$$ Step $2$: Mapping of Weak Entity Types

$$ Step $3$: Mapping of Binary $1$:$1$ Relationship Types

$$ Step $4$: Mapping of Binary $1$:N Relationship Types.

$$ Step $5$: Mapping of Binary M:N Relationship Types.

$$ Step $6$: Mapping of Multivalued attributes.

$$ Step $7$: Mapping of N$-$ary Relationship Types.

$$ Step $8$: Mapping Specialization Subentities