I am slightly confused about one task regarding usage of unique constraint. I've got two tables:
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.