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:

Testamentary Capacity

The legal competence of an individual to make a will, including the understanding of the nature of the document, the assets to be disposed of, and the identity of the beneficiaries.

Sound Mind

A state of mental capacity in which an individual can effectively understand and manage their affairs.

Lucid Period

A temporary phase of clear-mindedness or rationality that interrupts a longer period of impaired mental state.

Will Substitutes

Non-probate methods for transferring assets upon death, such as trusts, joint tenancies, and payable-on-death accounts, designed to avoid the probate process.