Macromedia Dreamweaver MX 2004 Web Application Recipes

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.