Database Answers Sample Timesheet

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Timesheets
Back to the Data Model.
The Area being Modelled is :-
Timesheets

The Specifications have been defined in the following terms by Adnan khan (aak007 at hotmail.com) :- 

Subject: Time Tracking / IT charge back Data Model
Hello Barry, 

First of all thanks for the awesome "database answers" web site, 
It's a great resource for peoples for learning database data modeling. 

I have a specific questions for you, 

I am working on a project in which i have to design a dimensional data model for 
mainly storing time sheet data which involve time sheets, projects, tasks, activities, 
employees, cost centers etc.. also this has to be used as a source to provide data to GL 
for iT charge backs across multiple biz units etc .. 

Some business rules are 
1) there can be multiple time sheets for the same period for the same employee 
2) also involve retro fixing the data if the cost center id's changes 
3) time can be reported to a project or project task or an activity in a project or a project task. 
4) time can be charged to an asset 
5) project or tasks or activity can be charged back to multiple cost center with different % totaling 100% 

I would be very thankful if you can help me with a starter dimensional data model along with anything you feel helpful. 

Thanks 

Adnan 

C. The Things of Interest C.1 Activities C.2 Projects C.3 People C.4 Timesheets


© DataBase Answers Ltd. 2009
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map