Question: A consulting firm currently has several on - going projects. The manager of the firm needs to keep track of the information about each project
A consulting firm currently has several ongoing projects. The manager of the firm needs to keep track of the information about each project such as projects ID or code client, project title, description, leader of the project, total number of employees working on this project, and project starting date and ending date, budget, etc. The manager also needs to keep track of the information of all employees in this firm, including employee's ID name, job title, salary, telephone, etc. The manager needs to know which employee participates in what project. Assuming each project can have many employees working on it an employee can work on more than one project. Each project has some sponsors who provides funding or technical support for the project development. Once a project is successfully completed. It will benefit some of the clients of the consulting firm. The consulting firm needs to keep track the information about projects' sponsors and clients, such as contact namephoneaddress It also need to keep track of the amount of fund and the budget of project development. Employees who work on a project form a team for project development. The team members maybe from different offices of the firm. These HR office of the firm needs to keep track of employees' office information such as office name, phone, office manager's name, etc.
Create an EntityRelationship model for this scenario. YOU MUST follow the drawing convention IDEFx
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
