Which of the Following Functional Dependency Diagrams Accurately Represents the Following

question 44

Multiple Choice

Which of the following functional dependency diagrams accurately represents the following situation:
•A campus has many buildings.
•Each building has a unique name.
•Each building has many rooms.
•All rooms in any given building are numbered sequentially starting at "101."
•Each room has a certain capacity,although many rooms in the same building or different buildings may have the same capacity.
•Each room is assigned to a single department.
•A department may have many rooms in one or more buildings,each with the same or different capacities.

• A) BuildingName → (RoomNumber, Capacity, Department)
• B) RoomNumber → (BuildingName, Department, Capacity)
• C) (Department, Capacity) → (BuildingName, RoomNumber)
• D) (BuildingName, Capacity) → (Department, RoomNumber)
• E) (BuildingName, RoomNumber) → (Capacity, Department)

---

Definitions:

Cardiopulmonary Resuscitation

A lifesaving technique used in emergencies when someone's heartbeat or breathing has stopped, which includes chest compressions combined with artificial ventilation.

Near-Death Experience

A personal experience associated with impending death, often characterized by certain perceptions or sensations, such as seeing a light.

Nonjudgmental

An approach that involves accepting and respecting others' choices and behaviors without moral judgment.

Aftereffects

Consequences or outcomes that follow an event, often referring to the residual or lingering effects.