While each warranty policy type covers many computers

Assignment Help Operation Management

Reference no: EM132276774

Draw an ERD for the following user requirements.

Each computer manufactured in Dell Inc. has a unique serial number, CPU speed, memory size, price, and DVD speed. Each computer must belong to one warranty policy type, while each warranty policy type covers many computers. Every computer has to have a warranty, while we may have some warranty policy types not covering any computer at all. For each warranty policy type, we want to record its unique policy ID, name, and the length of coverage. Computers are assembled by assembly workers. We want to keep the following information about assembly line workers: name (including first and last name), a unique EID, phone number (s), and birth date. One worker can assemble many computers, and one computer can be assembled by many workers together. A computer has to be assembled by at least a worker, and a worker has to assemble at least one computer. For the assembling activity, we need to record how many hours each worker spent on each computer.

Reference no: EM132276774

Questions Cloud

Construct profit and loss statement : Construct a profit and loss statement using the following departmental figures and show the dollars and percentages for the net sales,

Essentially positive assumptions about human nature : Which theory is a set of essentially positive assumptions about human nature? Content theories of motivation.

What is our effective capacity utilization : You have been approached by one of the staff who works testing equipment that passes through your facility. what is our effective capacity utilization?

What change buzzwords should be used : What change "buzzwords" should be used? Which ones should be avoided? Why?

While each warranty policy type covers many computers : Each computer must belong to one warranty policy type, while each warranty policy type covers many computers.

The common pitfalls when implementing organizational change : What are the common pitfalls when implementing organizational change?

Point out the characteristics of these two types of unions : Select a craft union and an industrial union. Point out the characteristics of these two types of unions.

Calculate labor productivity in units and per dollar : Calculate labor productivity in units/per dollar, for both systems of production and compare the results.

Apply qualitative and quantitative risk analysis : Apply qualitative and quantitative risk analysis to any company.

User Account

All Pages