Suggestions for tables..(not homework; not important)

trorion · #1 (**permalink**) 06-17-06, 13:37

I have the following fields which were at one time organized every month, then every week, now every day. When it was monthly (which they would send me every 6 months so I could spend a day with eyestrain) it was for 20 employees. It started in Excel and I decided to put it in a DB because it was easier for me that way.

I could give my whine story here but I'll shut up...

Mostly I want to do it right because I want to, not because it's needed and I want to get out of my current phone monkey position. Here are my fields I'm getting in my stats which I get daily:

employeeID (foreign key)
LoginTime
UnavailableTime
TalkTime
CallsAnswered
CallsRefused

On every day each employee will or will not have an entry. This is where i'm getting backed up. Since there might be many entries for each day it seems like this should be seperated out or I will end up with something like this:

Code:

DATE           EID   LoginTime     Unavailble    Talk          call    refused
2006-01-01      1      0:30:50      00:12:25      00:10:00      5      1
2006-01-01      2      1:22:50      00:30:25      00:12:00      8      0
2006-01-01      3      1:48:50      00:15:01      00:18:00      9      3
2006-01-01      5      8:30:50      00:12:15      01:32:40    133      15
2006-01-01      9      2:30:50     00:18:25       00:45:00     90      0
2006-01-01      4      3:42:50      00:03:25      00:45:00      17     0
2006-01-01      8      1:18:50      00:30:25      00:45:00      45     1
2006-01-02      1      0:30:50      00:12:25      00:10:00      5      1
2006-01-02      2      1:22:50      00:30:25      00:12:00      8      0
2006-01-02      3      1:48:50      00:15:01      00:18:00      9      3
2006-01-02      5      8:30:50      00:12:15      01:32:40     133     15
2006-01-02      9      2:30:50     00:18:25       00:45:00     90      0
2006-01-02      4      3:42:50      00:03:25      00:45:00      17     0
2006-01-02      7      1:18:50      00:30:25      00:45:00      45     1

(made up numbers)

OK, so I don't think that's right since each day is represented dozens or hundreds of times. The reports that I get won't give me login-logout times but rather just tell me total time logged in daily (LoginTime).

The real db administrator has said that basically he will do nothing more for reports than he's doing now and if I want to give something more useful to the management staff I can figure it out on my own and no, I can't access the main DB to get real numbers.

What other information would help you help me? No, it's not homework, no it's not really important, no i'm not a db administrator.

trorion · #2 (**permalink**) 06-17-06, 13:38

double post.
Does not share or play well with others. Trorion has problems making or keeping friends...

r937 · #3 (**permalink**) 06-17-06, 15:57

Quote:

Originally Posted by trorion

SO HOW SHOULD I BREAK THIS UP?

i would leave it as a single table and not break it up

r937 · #4 (**permalink**) 06-17-06, 15:57

isn't this the same as your other thread? i'm gonna merge them

trorion · #5 (**permalink**) 06-17-06, 17:10

Quote:

Originally Posted by r937

isn't this the same as your other thread? i'm gonna merge them

Yeah, it is. the other thread said "invalid forum" or some such since I wasn't logged in.

Like I said, don't need to fix the tables to be right but I'd like to do it the right way. If they ever get their act together (incidentally, this is a huge company) I'm hoping I can extend this to a little over 2500 employees. Already some whispers about that.

Guess I can cross that bridge later. I tried a sample table with 2,000,000 entries on a desktop computer and it ran fine with almost no slowdowns so I suppose there is no real rush.

Internet Services

Web Development

Digital Marketing

Consumer Tech