Ingredients

4 Application Pages:

  • 2 User Pages

    • In/Out Dashboard

    • Update Status

  • 2 Administration Pages

    • Manage Announcements

    • Add Announcement

1 Data Source:

  • 1 Database with:

    • 3 Tables

      • Dashboard Dashboard tracks each entry in the Dashboard by employee ID, the current status, and each time the status is changed.

      • Announcements Announcements maintains the announcement text, its active date, and whether or not it should be displayed.

      • Status Status contains each of the available status options, by ID and name. This table is used primarily to populate list elements.

      • Employees Reference is made to this table, so it needs to be included here for clarity.

    • 1 View

      • EmployeeDashboard This is a virtual table joining the Announcements, Dashboard, and Status tables.



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