An Analyst Has Discovered That a Company Wishes to Hold

question 124

Multiple Choice

An analyst has discovered that a company wishes to hold information about departments and employees. A department may have many employees in it, but each employee can, at any one time, only work in one department. There is no requirement to store historical information. However, there are currently eight departments and over one hundred employees. How would this relationship be shown on an Entity Relationship diagram?

• A) As (8..100) at the Department end of the relationship.
• B) As a many-to-many between Department and Employee.
• C) As a one-to-one between Department and Employee.
• D) As a one-to-many between Department and Employee.

---

Definitions:

Legitimate Power

The authority that a person or a position holds, which is recognized as rightful by those they govern or lead, often derived from official or formal roles.

Expert Power

The influence and authority one possesses as a result of one's experience, skills, or knowledge in a specific area.

Reward Power

The capacity to influence others' behavior by offering them positive incentives.

Coalition Building

The process of assembling a group of diverse organizations or people to pursue a common goal or address a specific issue through collaboration.