DATA Modelling Using Visio

Create a data model that satisfied the following business rules... We would like to design a database to maintain information about a company, including Department, Project, employee, job, project manager, employee supervisor, and department manager. The information we need includes: Employee, including their names, addresses, date of birth, gender, salary, and social-security numbers. Every employee could have different salaries for the same job and/or different job We need to keep track of number of hours each employee has worked on different project Project, including their names, expected starting, actual starting date, expected finish date, actual finishing date, budget from participating department (many department sponsor a project and/or fund part of the project), and project leader. Department, including their names, Annual budget, address, and department manager