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)
Correct Answer:

Verified
Correct Answer:
Verified
Q39: A key that contains more than one
Q40: During the normalization process,the remedy for a
Q41: A candidate key is _.<br>A) never a
Q42: In the normalization process,if you find that
Q43: Given the below functional dependency,<br>MedicineCode → (MedicineName,ShelfLife,Manufacturer,Dosage)<br>Which
Q45: Which of the following is not true
Q46: A key must be unique.
Q47: Any table that meets the requirements of
Q48: The unique keys that are not chosen
Q49: One important relational design principle is that