Make Learning Stick

Reflective Learning

Question

Which of the following sets of attribute characteristics defines the attribute First Name for the entity Employee?

  1. Non-unique, mandatory, not multi-valued
  2. Unique, mandatory, not multi-valued
  3. Unique, optional, not multi-valued
  4. Non-unique, mandatory, multi-valued

You Answered: A
Correct Answer: A

Correct! It’s non-unique because the value for First Name does not uniquely identify an instance of Employee. It’s mandatory because a value must be assigned to the attribute when the Employee is created. It’s not multi-valued because there can be only one value for the attribute in each instance of Employee.