Practice mode DBMS and SQL

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.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.