/*
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
*/