In ER Model constructs, which type of attribute is most suitable to represent…
2024
In ER Model constructs, which type of attribute is most suitable to represent the skill(s) of an employee for an organization?
- A.
Derived attribute
- B.
Composite attribute
- C.
Atomic attribute
- D.
Multivalued attribute
- E.
Question not attempted
Attempted by 1265 students.
Show answer & explanation
Correct answer: D
In ER Model, attributes describe properties of entities. To represent skills of an employee, we need an attribute that can hold multiple values. Derived attribute: Calculated from other attributes, not stored directly. Not suitable for skills as skills are not derived. Composite attribute: Made of multiple sub-attributes (e.g., name). Skills are not composed of smaller parts, so not suitable. Atomic attribute: Holds a single, indivisible value. Skills can be multiple, so atomic attribute cannot represent them. Multivalued attribute: Can store multiple values for a single entity. This is suitable for skills as an employee can have multiple skills. Thus, multivalued attribute is the most suitable for representing skills.