To take a simple example of an Order and associated CustomerAddress:

Order {OrderNum*, t1, CustomerNum, ...}

CustomerAdddress {CustomerNum*, t2*, Address}

* = key

For this generic example, t1,t2 are the temporal elements - they...

David,

I'm appreciating all answers as I'm learning a lot. Lynn's and Sean's responses made sense to me as did the customer purchase example. But what you've done is state...

Paul Berzukov,

Thank you again for your helpful responses (and sorry it took me awhile to get back). I can see it's going to take me some time before I...

Paul,

I greatly appreciate your answer as I am trying to learn - to make sure I do things in a good way. Do the guidelines (rules) allow flexibility? ...

Given that I don't see significant database operations on buildings and floors, I wouldn't isolate them.

Therefore, two tables work nicely and cleanly.

1) create a table for rooms (room_id, room_name, building_name,...