I am trying to learn entity relationship diagram, following question is the objective.
Information consulting firm has number of offices with employees. The employees can move offices depend on the project, but location is always recorded. This consulting firm manage number of projects and have vast base of clients. The company's success is depend on assigning relative employee with relative skill and location. The time an employee spends on project is recorded each day. This include time for travel and break time etc. To reduce time for travel they try to allocate employees from the nearest office possible. Draw Entity Relationship diagram and entity listing with attributes.
I created entity relationship diagram by using Visio. Please comment on my attempt.
Office Address telephone office manager Employees name address job hourly rate start_date location etc Projects Name Manager Start Date End Date Estimated Cost Quote Actual Cost Client Name address telephone e-mail contact Assignment name Employee name Date Assigned Hours spent
Here is my attempt in this image: