MySQL

Construct an Entity$-$Relationship $($E$-$R$)$ diagram and the resulting normalized tables to address the scenario provided below. You should

present your results beginning with a Conceptual E$-$R Diagram $($your initial

impression of the scenario$)$ and the corresponding Dependency Diagrams.

Continue to normalize until you have a complete set of related tables.

Develop the database design for a small company$$s personnel office. The

goal is to track the assignment history of employees and capture necessary bio$-$demographic data. This includes data to identify employees $($name$,$

address$($es$),$ gender, contact information, DOB, salary$),$ jobs $($title$,$ description$),$ and departments $($code$,$ description, contact information$).$

The system must be able to report on:

$$ Department Staffing

$$ Employee breakdown by city$/$state

$$ Assignment history

$$ Vacant jobs