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, current status, and times the status is changed.

    • Announcements Announcements maintains the announcement text, its active date, and whether 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.

  • 1 View

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