Question: Database ERD using visio Please flollow instructions. Create a data model that satisfied the following business rules... We would like to design a database to

Database ERD using visio

Database ERD using visio Please flollow instructions. Create a data model that Please flollow instructions.

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!