Back
/*
View: MasterSuperDepts

Columns:
    superID int
    super_name var_char
    dept_ID int

Depends on:
    SuperMinIdView (view)
    superDeptNames (table)

Use:
A department may belong to more than one superdepartment, but
has one "master" superdepartment. This avoids duplicating
rows in some reports. By convention, a department's
"master" superdepartment is the one with the lowest superID.
*/
Back