This table provides information on the organization of
the company.
Each row represents a department. The columns are as follows:
DEPTNUMB
Number of the department (must be unique)
DEPTNAME
Descriptive name of the department
MANAGER
Employee number of the manager of the department
DIVISION
Division to which the department belongs
LOCATION
Name of the city in which the department is located
The Q.ORG table is shown in the following figure: Figure 1. The Q.ORG table
DEPTNUMB DEPTNAME MANAGER DIVISION LOCATION
-------- -------------- ------- ---------- -------------
10 HEAD OFFICE 160 CORPORATE NEW YORK
15 NEW ENGLAND 50 EASTERN BOSTON
20 MID ATLANTIC 10 EASTERN WASHINGTON
38 SOUTH ATLANTIC 30 EASTERN ATLANTA
42 GREAT LAKES 100 MIDWEST CHICAGO
51 PLAINS 140 MIDWEST DALLAS
66 PACIFIC 270 WESTERN SAN FRANCISCO
84 MOUNTAIN 290 WESTERN DENVER