Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Which of the following functional dependency specifications accurately represents the following situation: A campus has many buildings. Each building has a unique name. Each building
Which of the following functional dependency specifications 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
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.
BuildingName CapacityDepartment RoomNumber
BuildingName RoomNumber Capacity, Department
BuildingName RoomNumberCapacity Department
RoomNumber BuildingName Department, Capacity
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started