NEEDED IN DATABASE DESIGN

Indicate if a check constraint or additional programming is needed to enforce the relationship in the database. Under each table diagram, write the conditions that the check constraint or program has to ensure.

For example:

To enforce exclusive relationships, a check constraint is needed to make sure that (column A is not null and column B is null) OR (column A is null and column B is not null).

To enforce a nontransferable relationship, additional programming is needed to make sure that the cannot be updated.