Ingredients

8 Application Pages:

• 2 User Pages

  • Add Time Card

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