1) what are the ways you could implement this constraint and which is the best and why: For the resource table ensure that the restype is restricted to values held in the resource_type table. (where restype is a primary key in resource_type table and a foriegn key in resource table)

-- Daniel Hockney (danielhockney@hotmail.com), May 23, 2003