Question

ER to Relational Mapping

a) i)

Reverse engineer the following schema to make an ER Diagram

A ( $\mathbf{a}$ ), B ( $\mathbf{a,b}$ ), C ( $\mathbf{a,b,c}$ )
B.a references A.a; C.ab references B.ab

ii)

EMP ( $\mathbf{ssn}$ , ename, supervisor, Dno), DEP ( $\mathbf{Dno}$ , dname)
EMP.Dno referencesDEP.Dno; EMP.supervisor references EMP.ssn

$\mathbf{bold is underline.}$ bold is underline.

Answer 1