You are required to design and implement a database for the HR department of a company using either CHEN or Crow’s foot notation. To do this, use a visual database design or administration tool, such as draw.io and MySQL Workbench.
The HR department needs to record information about its employees, job titles, and the departments that they work at. You are given the following requirements that need to be stored:
- Employees should have a unique identifier, date of birth, name, gender, salary, title and hire date.