Question

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)

Answer

This answer is hidden. It contains 1 characters.