Skip to main content
M
mazirra
Participant
May 26, 2011
Question

Data schema for timesheet application

  • May 26, 2011
  • 3 replies
  • 925 views

I have to design a timesheet application.
Th epurpose is to store a worker, a project, an accounting code, a date and
a duration.
How would arrange the tables and their relations to do that?

Message was edited by: Jochem van Dieten

This topic has been closed for replies.

3 replies

ilssac
ilssac
Inspiring
May 26, 2011

Anyone else feel like this might be a spam post?  That seems to be a rather complete product for somebody asking such a rudimentary basic question.

D
Dan_Bracuk
Inspiring
May 26, 2011

I wouldn't know, I didn't select the link.

D
Dan_Bracuk
Inspiring
May 26, 2011

If that's all there is to it, which is unlikely, I'd use a star schema.  Worker, project, and account would be dimension tables.  The fact table would have key fields from the dimension tables along with a start date, projected end date, actual end date, and anything else you deem useful.

Owainnorth
Owainnorth
Inspiring
May 26, 2011

Depends, how much would you pay me to design it for you?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices