Question $15$

In the partial ERD listed below, the ROOM entity describes all aspects of a room located in a building that is part of a small industrial complex. There are $6$ buildings in this complex. As you refine your diagram you notice a problem in this entity. What is this problem?

ROOM

$\backslash$table$[[$RoomID: VARCHAR $[$ PK $]],[$RoomNumber: VARCHAR$],[$RoomSize: VARCHAR$],[$Capacity: VARCHAR$],[$BuildingID: VARCHAR$],[$BuildingName: VARCHAR$]]$

There is a functional dependecy

RoomTypeID should not be required

There is no problem

There is a transitive dependency