| 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.
|