Question: Design 00 conceptual representations for an engineering company, using the following requirements: . A customer has a customer identifier. Other important attributes of each customer

Design 00 conceptual representations for an engineering company, using the following requirements: . A customer has a customer identifier. Other important attributes of each customer include name and address. They can request any number of work orders from the company The company maintains a list of materials. The data about materials include a material identifier, a name and cost. A work order has a work order number, a creation date, a completion date, a work address and a set of (one or more) tasks. In addition, each work order has one optional supervising employee. Each employee has a number assigned by the company. Other important attributes of each employee include name and skill. Each work order also has a collection of materials. The same material can be used by any number of work orders. Material requirement includes material quantity. Each task has a task identifier, a task name, an hourly rate and estimated hours. Tasks are standardized across work orders so that the same task may be performed on many work orders. We have to keep record of actual hours of each task on a work order. Please draw the design and save and submit it as a file. Only one copy need to be submitted by each group. Please indicate your group members in the submission
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
