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

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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