Convert the following ERD to relational schema $($Mapping to schema$)$ and follow the steps $(1-8)$ in Unit$3$

Part$2.$ Before proceeding with any of the steps numbered $1$ through $8,$ start by handwriting the details.

Include entity names, attribute names, relationship names, sub entities, and any additional information.

Write your answers on paper by hand

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