ER model

DRAW an Entity-Relationship model for this scenario A consulting firm currently has several on-going projects. The manager of the firm needs to keep track of the information about each project such as project's 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 sponsor(s) who provide(s) 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 name/phone/address. 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