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:

Uterine Cycle

The monthly cycle of changes that the uterus undergoes to prepare for pregnancy, including menstrual, proliferative, and secretory phases.

Menarche

The first occurrence of menstruation in a female, marking the onset of reproductive capability, typically occurring in early adolescence.

Vaginismus

A condition characterized by involuntary contraction of vaginal muscles making penetration painful or impossible, often associated with anxiety and fear of vaginal penetration.

Alveoli

Tiny air sacs in the lungs where the exchange of oxygen and carbon dioxide takes place.