Draw an Entity Relation Diagram (ERD) that captures the relations in the Instance Diagram in Figure below. The solid black lines represent the relation Reports To and the dashed red lines represent the relation Belong to department. Your ERD should capture both the Employee and Department relations and also include any other relevant attributes of these Entities. Also write queries to create the corresponding tables for these entities (including any required weak entities) being sure to include any relevant constraints, especially primary keys and foreign keys.

Alice Finance Management Dev Mary John Kate