Data schema for timesheet application

[mazirra]

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

[Owainnorth]

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

[Dan_Bracuk]

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.

[ilssac]

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.

[Dan_Bracuk]

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

[-__cfSearching__-]

Anyone else feel like this might be a spam post?

Yep. I was thinking along similar lines as soon as I saw the question vs descriptive url 😉 But did not have time to visit the site.

[Dave Watts]

My interpretation was that the OP wanted to build an application like that, not that he had.

Dave Watts, CTO, Fig Leaf Software

http://www.figleaf.com/

http://training.figleaf.com/

[-__cfSearching__-]

Maybe I am too suspicious but in that case I would have expected the link to be prefaced with ".. something similar to this site". Plus the question is way to broad to answer effectively.

-Leigh

[ilssac]

My suspicious interpretation was:  "Lets put some key words for a product and a link to said product in a vaguely worded question on a well traveled discussion forum to see how much page ranking goodness I can siphon off."