$1.$ Data Modeling Ex$1.$ Data Modeling Exercises

$2$a$.$ 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 projects. Assuming each project can have many employees working on it$,$ an employee can work on more than one project. The firm also needs to hire short$-$term contractors in some projects$$ development. The firm also needs to keep track of these contractors' contact information such as name, email, phone number, etc. 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 needs to keep track of the amount of funds and the budget of project development. Employees who work on a project form a team for project development. The team members may be from different offices of the firm. The 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 Entity$-$Relationship model for this scenario. $($It is strongly recommended that you use a computer$-$diagramming tool to draw this model$).$ Note YOU MUST follow the drawing convention $($IDEF$1$x$)$ shown in my ppt presentation.ercises

$2$a$.$ 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 projects. Assuming each project can have many employees working on it$,$ an employee can work on more than one project. The firm also needs to hire short$-$term contractors in some projects$$ development. The firm also needs to keep track of these contractors' contact information such as name, email, phone number, etc. 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 needs to keep track of the amount of funds and the budget of project development. Employees who work on a project form a team for project development. The team members may be from different offices of the firm. The 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 Entity$-$Relationship model for this scenario. $($It is strongly recommended that you use a computer$-$diagramming tool to draw this model$).$ Note YOU MUST follow the drawing convention $($IDEF$1$x$)$ shown in my ppt presentation.