Database:

Please use an editor tool. Do not provide me with a handdrawing.

---------------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------------

Map the E-R diagram to a relational schema. The E-R diagram is attached below.

indicate links from foreign key to primary key.(use Italic for foreigh key)

Draw the schema with all connected relations.

Salary Name Fname Address WORKS FOR Sex Location Mname Name DEPARTMENT EMPLOYEE Lname StartDate Bdate MANAGES CONTROLS Hours WORKS ON Supervisor Location SUPERVISION Name Number EPENDENTS OE DEPENDENT Name Relationship Sex BirchDate