Please create an Entity Relationship Diagram (ERD) for this particular case, only include Primary keys, foreign keys and attributes, no data types required. Thanks!

 

GTA Consulting employs some 500 consultants. Each consultant has a unique id and is designated as having one and only one specialty in the IT field .The company recognises some 50 different specialties each of which has a unique specialty code and a description. All the consultants with the same specialty are billed at the same rate.

 

GTA undertakes projects for its clients. For every client a unique client number is assigned and Acme retains data on the address, phone and contact name for each client. Each project gets its own project number and has an estimated total cost and final completion date. Several consultants can be assigned to a project and recorded against each project is an estimate of the number of hours that each consult will bill to that project. One of the consultants assigned to a project will also function as the project leader. At any one time there may be several projects active for any one client and a consultant may be assigned to several different projects.

 

Each project is broken down into a number of scheduled tasks. Each task within a project will be identified and tracked as to its start and end date. Each task within a project has its own a description as well as a unique task number within that project. A particular task may only begin when certain other tasks are completed and the same particular task may in turn need to be completed before certain other tasks can also begin. This dependency structure for the scheduled tasks will need to be modeled. A project task might be worked on by more than one consultant assigned to the project and a consultant may work on several tasks. The total billable hours that a consultant spends on each task will be reported each week and retained as such for tracking purposes for the duration of the project.