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.



Macromedia Dreamweaver MX 2004 Web Application Recipes
Macromedia Dreamweaver MX 2004 Web Application Recipes
ISBN: 0735713200
EAN: 2147483647
Year: 2003
Pages: 131

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net