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?

I guess there is no way to paste a database diagram here, so here is my idea:

CREATE TABLE [dbo].[tblClass](

[ClassName] [nchar](10) NULL,

[RoomName] [nchar](10) NULL

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[tblClass] ADD CONSTRAINT...

I wanted to paste the database diagram picture here. Is there a way to paste it.