Project Summary (also accessed by the administrator)
6 Administration Pages
Add Project
Add Job Code
Hours Breakdown
Task Detail
Task Update
View Time Cards
1 Data Source:
1 Database with:
4 Tables
TimeCard Includes records for all time cards entered in the application with fields for the ID, employee, project, date logged, assigned date, hours, and description.
Projects Tracks the available projects, their managers, estimated hours, and actual hours logged.
JobTypes A listing of the tasks available to be assigned on a time card; each job type includes a short description, ID, and billing rate.
Employees This is the standard employee table used throughout the book, used when a new time card is created.
6 SQL Queries
ProjectTimeCards A virtual table joining the TimeCard and Projects tables.
HoursBreakdown A SQL statement that combines the ProjectTimeCards query and JobTypes table.
ProjectSummary A SQL statement that extracts data from the HoursBreakdown query.
DailyHours, WeeklyHours, and MonthlyHours Three separate SQL statements, each of which derives summaries from the HoursBreakdown query.