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:

Sustainable Development

Meets the needs of the present without hurting future generations.

Earth Summit

A conference held to address global environmental problems and encourage sustainable development, notably the 1992 UN Conference on Environment and Development.

Pillars

Fundamental principles or structures that support or hold up a system, organization, or ideology.

Business Sustainability

refers to the strategies and practices a company employs to manage its environmental, social, and economic impacts while ensuring longevity and success.