2 User Pages
In/Out Dashboard
Update Status
2 Administration Pages
Manage Announcements
Add Announcement
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.