September 22, 2023 at 12:00 am
Comments posted to this topic are about the item How Would You Design This: Scheduling Classes
October 1, 2023 at 11:23 am
I would probably start with something like this:
October 1, 2023 at 11:23 am
I would probably start with something like this:
October 1, 2023 at 6:17 pm
Interesting. What about students that are also teachers? TAs, someone seeking a second cert?
October 1, 2023 at 6:38 pm
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.
October 1, 2023 at 7:12 pm
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
Change is inevitable... Change for the better is not.
October 2, 2023 at 6:39 am
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? 🙂
October 2, 2023 at 1:59 pm
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.
October 2, 2023 at 2:04 pm
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
October 2, 2023 at 2:32 pm
Good idea to add location and time to the schedules.
October 2, 2023 at 4:18 pm
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
Change is inevitable... Change for the better is not.
October 2, 2023 at 5:42 pm
@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.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 2, 2023 at 5:59 pm
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