• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Ingredients

7 Application Pages:

  • 5 User Pages

    • Employee Search

    • Advanced Employee Search

    • Employee Results

    • Employee Details

    • Update Employee

  • 2 Administration Pages

    • New Job

    • New Employee

2 Data Sources:

  • 1 Database with:

    • 3 Tables

      • 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.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint