Problem: (Dell Inc.) Each computer manufactured in Dell has a unique serial number, its CPU speed, memory size, price, and DVD speed. Each computer belongs to one warrantee policy type, while each warrantee policy type covers many computers. Every computer has to have a warrantee, while we may have some warrantee policy types not covering any computer at all. For each warrantee policy type, we want to record its unique policy ID, name, and the length of coverage. 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.
a) Identify the entity types:
b) Identify attributes of each entity type:
c) Determine identifier attribute of each entity type:
d) Identify the attributes of an associative entity, if any:
e) State the relationships among the entities
f) Draw relational data model.