Employees The core employee data table with fields for first name, last name, job, email address, phone number, cell phone number, and cubical number.
Departments A listing of all the departments in the organization.
Jobs Each of the current job titles, with fields to identify the corresponding department and manager; all jobs, whether presently filled or not, are listed here.
3 Views (ASP and ColdFusion)
EmployeeLookup A virtual table joining the Employees, Jobs, and Departments tables.
Jobs WithDepartments A combined listing that shows each job and its matching department, in parentheses.
ManagersByDepartment Displays only the managers, sorted by their department.