Case 2 - The Outsourcing Bookkeeping and Payroll Company

Database Design




Workers and Times for Each Client Report




Clients by Zip Report



Sales Calls Query




Parameter Value for Sales Calls Query




Hours Worked per Client Query




Jobs Input Query




Client Table




Employee Table




Transaction Table

Case 1 - Misty Valley Country Inn

Revenue from Customers Query


Customers Bill Query


Rooms Booked the Week Query


Money Generated by Room Query


Rooms Table


Reservations Table


Customers Table