Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
Depends, how much would you pay me to design it for you?
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
I wouldn't know, I didn't select the link.
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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/
Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
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."