I have some data like this
2010/06/26
Task A:started at 5:30AM:ended 6:00AM
Task B:started at 5:30AM:ended 7:00AM
Task C:started at 5:45AM:ended 6:00AM
Task D:started at 7:30AM:ended 11:00AM
2010/06/25
Task A:started at 1:30AM:ended 6:00AM
Task B:started at 1:30AM:ended 7:00AM
Task C:started at 2:45AM:ended 6:00AM
Task D:started at 3:30AM:ended 11:00AM
2010/06/24
Task A:started at 3:30AM:ended 6:02AM
Task B:started at 4:30AM:ended 7:04AM
Task C:started at 8:45AM:ended 12:04PM
Task D:started at 7:30AM:ended 11:01AM
I would like to do metric such as, "On 2010/06/25 what was the longest
task", "how does task B look for X number of days", etc..
I setup 2 tables, task and t. Task is for the task and t is for the time.
Now, I am getting confused on how to setup this relationship. This
should be a many-to-many relationship. Can anyone give me advise on
how to better organize this data?
TIA