Question: Using the Erwin Software construct a logical data model using the IE notation to fit the following circumstances. Acme IT Consulting employs some 500 consultants.

Using the Erwin Software construct a logical data model using the IE notation to fit the following circumstances. Acme IT 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 consultant's name and date of hire is also retained. The company recognizes some 50 different specialties. Each specialty has a code and a description. All the consultants with the same specialty are billed at the same rate. Acme undertakes projects for its clients. For every client a unique client number is assigned and Acme retains data on the address and contact for each client. Each project gets its own unique project number and has an estimated cost and completion date. Several consultants can be assigned to work on a project and stored, for each assignment for each consultant, is an estimate of the number of hours that each 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 a description as well as a unique task number within that project. A project task might be worked on by more than one consultant assigned to that project and an assigned consultant may work on several tasks. The total billable hours that each consultant spends on each task they are assigned to will be stored. Tasks may have dependencies on each other. A particular task may for example require several other tasks to have been completed before it can proceed and in turn may be a pre-requisite to additional future tasks. This inter-dependency of tasks must be modelled
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
