An employee can have several phone numbers, and the design records all of them against the same employee. In ER terms, what type of attribute is phone_number?
Correct answer C. Multivalued attribute
Explanation
A multivalued attribute can hold a set of values for a single entity, like several phone numbers for one employee. When mapped to tables it normally becomes a separate relation, such as EmpPhone(emp_id, phone_number), to keep values atomic. A composite attribute is different: it has internal parts, such as an address made of street, city and postcode, but still only one value per entity.
Answer checked How we write and check questions
Discussion