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:

Fluid Matrix

Refers to the liquid component of various tissues and substances, where other parts are suspended or dissolved.

Blood

A type of bodily fluid in humans and other animals that delivers necessary substances such as nutrients and oxygen to the cells and transports metabolic waste products away from those same cells.

Cardiac Muscle

A specialized form of muscle found in the heart, characterized by its ability to contract involuntarily and rhythmically.

Heart

A muscular organ in most animals, including humans, which pumps blood through the circulatory system by rhythmic contractions.