An organization uses number of items of a equipment to


Draw an E_R Model for the following:

An organization uses number of items of a equipment to produce goods. Each item is at one LOCATION, of one TYPE and has a DETAILED_DISCRIPTION. Faults on the equipment are identified by a unique FAULT_ID and are reported at a TIME_REPORTED. Any number of persons may be assigned to a fault and work on the fault until it is fixed. The TIME_FIXED is recorded as is the TIME_SPENT by each person on a fault. Any number of parts may be used to repair a fault. The QTY_USED of each parts is recorded against the fault. Each part is identified by a PART_ID and has a given weight and MAX_DIMENSION and can have any number of colors.

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: An organization uses number of items of a equipment to
Reference No:- TGS01658475

Now Priced at $20 (50% Discount)

Recommended (93%)

Rated (4.5/5)