Make Learning Stick

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: B
Correct Answer: A

The attribute First Name attribute is 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.