Java around the world

I have 3 tables that i want to relate together manually (no wizards) by using SQL statements. Am using Microsoft SQL Server 2005 in Visual Web Developer 2008 using VB programming (ADO.NET) The 3 tables are as follows: Floor Room Location Fields inside each of the tables can be found below: Floor Table (PK) ID (Required) Name DisplayOrder Room Table (PK) ID (Required) Name (PK, FK) FloorID ExchangeID Extension IP DeviceName Remarks (Required) Equipment (Required) Floor2ID FloorLocationX FloorLocationY Location Table (PK,FK) FloorID (Required) CountryName (Required) CityName (Required) BuildingName Intended relationships between the 3 tables are as follows: ID field in Floor table is referenced by the field named FloorID in the Room Table ID field in Floor table is referenced by the field named FloorID in the Location table Location Table serves only as an extension to Floor table thus they have a 1 to 1 relationship Floor has1:M rela with room