Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2006
    Posts
    11

    My work woes..design suggestions

    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.
    Last edited by trorion; 06-17-06 at 18:12.

  2. #2
    Join Date
    Jun 2006
    Posts
    11

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

    double post.
    Does not share or play well with others. Trorion has problems making or keeping friends...
    Last edited by trorion; 06-17-06 at 18:13.

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    isn't this the same as your other thread? i'm gonna merge them
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jun 2006
    Posts
    11
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •