Jack,

Thanks for the reply. It makes sense to add the ID identity column in Rooms table. My question is, does this design looks too normalized?