Question

Given the business rule "an employee may have many degrees," discuss its effect on attributes, entities, and relationships. (Hint: Remember what a multivalued attribute is and how it might be implemented.)

Answer 1

Answer:

Executing multivalued attribute in

database:

Multivalued attributes are not directly

implemented in Relational Database,

instead of that follow the below possible

actions:

Explanation:

Multivalued Attributes

A multivalued attribute of an entity is an attribute that can have more than one value associated with the key of the entity. ... If attributes are restricted to be single valued only, the later design and implementation decisions will be simplified.

Example:

Consider a person can have multiple

degrees values like BSC, MCA and these

values can be stored in single attribute in a

database.