Macromedia Dreamweaver MX 2004 Web Application Recipes

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.

Related

Категории