
Table Normalization and Windows Azure SQL Database ◾ 91
CLASSROOM relates to BUILDING through the column BuildingId. For a given class-
room ID, you will be able to find the related building ID located in the same row in the child
relation. By matching the building ID found in the child relation to the building ID in the
parent relation, you can get the building name in the relation BUILDING. On the other
hand, for a given building ID, you can look for all the classrooms in that specified building
in the CLASSROOM relation. In Windows Azure SQL Database, these two relations are
constructed as shown in Figures 3.9 and 3.10.
As seen in Figu ...