Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004

    Unanswered: Database design help

    trying to work on a new project, i need some ideas to setup this design model.
    sql 2000 database and asp.
    This is call center environment where agent bid on shift (schedules) base on most disireable to least, and it process base on seniority.

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    well, let's see, you'll need an agent table, a shift table, and a bid table | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2002
    Don't forget the junction tables....

    What you really should do is interview the users and the data source providers and model the business....

    THEN create the logical data model after all the Entites and attributes have been defined.....

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jul 2003
    San Antonio, TX
    Identifying and introducing properties is an on-going process, but of course the earlier the better
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Jan 2004
    Thanks guys
    i will let you guys knows as it goes.
    The biggest issue im looking at so far is to automate the process of assigning shitfs to agent base on seniority. Agents with higher seniorites get thier most rank shifts and so on. also there's avaibility of each shift, e.g shitA will only be given to 20 agents only and so on.
    seniority is unique number already assigned to an agent. iwant to use store procedures or function to do that manupulation if possible, after all data's has been collected.

  6. #6
    Join Date
    Jan 2004
    In a large office with bad lighting

    Talking Careful with those keys

    Need to be careful with the "t" and "f" keys. It sounds like the agents queue up at the loo based on seniority, and only the first 20 agents get the best umm ... waste matter !!

Posting Permissions

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