/*
Table: subdepts

Columns:
    subdept_no smallint
    subdept_name varchar
    dept_ID smallint

Depends on:
    departments (table)

Use:
A department may contain multiple subdepartments.
In most implementations I've seen, invidual products
can be tagged with a subdepartment, but that
setting doesn't go into the final transaction log
*/