Hello,

I am slightly confused about one task regarding usage of unique constraint. I've got two tables:

TABLE ROOM
TABLE BUILDING

The requirement is that table ROOM has room code which must be unique only within a particular building (i've got 4 buildings). Not really sure how to do that. Any ideas?

Thanks is advance.