Table Structure Suggestion Needed

[lmmoorewi]

Hello -

I would like to know if I created a table correctly. I have a main table where data is stored for Ta 0ask and Time tracking system.

I have several small tables:
Analyst - list of Technicians
Week Date - list of Dates for each Week End


Then..there is a large table (Hours) that stores the Analyst ID,Week DateID and Task and Hours for each day of the week.

Field Names:
HoursID
AnalystID
Sunday Task 1
Sunday Hours 1
Sunday Task 2
Sunday Hours 2
Sunday Tasks 3
Sunday hours 3

..and this goes on for each day of the week.

My concern is, it's a big table and also I have a problem when creating reports (How do I lump all similar tasks to get a total of Hours)

Any suggestions would be greatly appreciated.

 

[PHV]

Have a look here:

http://www.nuigalway.ie/bis/mlang/l...undamentals_of_Relational_Database_Design.pdf

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MasterRacker]

Follow PHV's suggestion. You haven't finished normalizing your data. (Hint: At a minimum you want to separate out a tasks table.)

Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]

 

[kjv1611]

Do post back with your results, progress, but if you end up needing to expand the question further, by all means, post it here:
forum700

 

[lmmoorewi]

Hi there -
Thanks to all who responded!!

Perfect!! Page 9+ was EXACTLY what I needed.

I need to 'normalize' the data a little more.

Thanks again!