108.     Ah!! What a moron!! I forgot to tell you to make sure that two (or more) classroom numbers are assigned to the same building. Add the constraint (without dropping the table) to do this.

 

alter table department

add unique (building, roomnum);