Looks like it would work. One of my preferences is to to use an identity column as the primary key (adding a unique constraint on the true primary key) and then use that id column as the foreign key in other tables. If you do not do this and room names can change you need to make sure CASCADE updates on your relationships.