Using QMF

Q.ORG

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

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