How Would You Design This: Scheduling Classes

  • Comments posted to this topic are about the item How Would You Design This: Scheduling Classes

  •  

    I would probably start with something like this:

    Screenshot 2023-10-01 at 14.08.58

  •  

    I would probably start with something like this:

    Screenshot 2023-10-01 at 14.08.58

  • Interesting. What about students that are also teachers? TAs, someone seeking a second cert?

  • I don't think a student would teach a course that they're currently in.

    Kindest Regards, Rod Connect with me on LinkedIn.

  • They wouldn't, though you might register them for counting purposes. We see conferences that require speakers to register, and they count in the room for things like fire codes and meals.

    It's less that an instructor needs to be in the class, but they can be a student in another class. In this design, I think I'd need to enter them twice, duplicating their name, contact, etc. Might be a reason to have this separated, but it's also not necessarily a design I'd pick. I could accept it either way, but I'd want to an explanation of why or how this works.

  • I see your point, Steve.

    Kindest Regards, Rod Connect with me on LinkedIn.

  • Surely, someone has already done this (although I've not actually looked for such a thing).  Wouldn't it be easier to find something that already works and buy it?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Good point!   Separating Contact Information so that they are not duplicated.

    Can be edited and previewed here: https://github.com/icozma/Scheduling-Classes

    Will this model evolve enough to be an alternative to AdventureWorks? 🙂

    Screenshot 2023-10-02 at 09.30.24

  • Jeff Moden wrote:

    Surely, someone has already done this (although I've not actually looked for such a thing).  Wouldn't it be easier to find something that already works and buy it?

    It's very hard to find designs. The Internet is so vast. I was hoping to get some responses here that might not only include original designs, but point to others.

  • Also with some "why" this is a good or bad design. A debate.

     

    I like the above design for the people entities, but not sure about the scheduling. Scheduling has a lot to it with locations, times, etc

  • Good idea to add location and time to the schedules.

    Screenshot 2023-10-02 at 17.29.17

  • Steve Jones - SSC Editor wrote:

    Jeff Moden wrote:

    Surely, someone has already done this (although I've not actually looked for such a thing).  Wouldn't it be easier to find something that already works and buy it?

    It's very hard to find designs. The Internet is so vast. I was hoping to get some responses here that might not only include original designs, but point to others.

    Ah... got it and I totally agree.  It's the same reason why I miss the good ol' local "Yellow Pages".

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • @steve-2 Jones...

    Have you taken a look at the "business end" of Sessionize?  I've not.  I've only been on the receiving end as a speaker but their write-up seems encouraging and might be worth evaluating for next year's PASS summit and could be pretty good for SQLSaturdays in the future.

    https://sessionize.com/

     

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Most SQL Saturdays use sessionize, in fact, most conferences do. PASS Summit used it last year (2022), but not this year. I think because the platform they use already has a CFS in there and it's easier for session review by volunteers.

    I like sessionize, but they are slightly pricey, and I wish they integrated some reg stuff in there. Or really, I wish a reg site had better speaker features. Partially this design idea was kicking around the idea of building something that would compete with sessionize a bit for SQL Sat and other events, but include some integrations with registration for people. I thought some people might create data models that considered things I hadn't thought about.

Viewing 15 posts - 1 through 15 (of 24 total)

You must be logged in to reply to this topic. Login to reply