$3\mathrm{.}2$ Use the reduction techniques you learned in Chapter $12$ to map the following

ER diagram to relational schemas. $(4$ points$)$

$3\mathrm{.}2$ Fill in the table below to indicate the foreign keys in the schemas you obtained in the

previous step, the schemas where they are located, the primary keys that correspond to

these foreign keys, and the schemas where they are located: $(2$ points$)$