How Would You Design This: Scheduling Classes

  • This app looks quite interesting, sessionize.com.

    To me, I wanted to explore the memaid tool. It has some nice integration with Github. ( usually I am thinking like simple to complex)

    I have not thought that much from a design or use case perspective. I just hope it evolves little by little. We shall see ...

    I think we have some more entities now 🙂    sessions , reviews , volunteers ,  registrations

     

  • Enriching the evolutionary mermaid exercise  with three more entities: sessions, volunteers and reviews. Maybe we shall include some registrations. Though not sure how the flow will be for registrations.

    We shall probably register users, then assign roles of instructor, student, volunteer; in which case the design might change a bit.

    Screenshot 2023-10-02 at 21.18.31

  • Hi @Iulian-207023, I'm curious to know why your id fields are all strings, rather than an integer type of some sort.

    Kindest Regards, Rod Connect with me on LinkedIn.

  • There is a chapter in Kimball on Education, that sounds like quite a complex use case. It is from a dimensional modeling perspective, probably focused on analytics more than operational. I will probably have a look at it.

    On the diagram exercise started, you are right, I switched the ids to int.

    Screenshot 2023-10-04 at 21.56.29

  • Something like this:

     

    Attachments:
    You must be logged in to view attached files.
  • Nice, I see you added also PK & FK.

  • Good basics, though what about scheduling classes multiple times?

  • Here is my first draft.

    I call it the UEvent (Universal Event) data model, because it is abstract enough to accommodate anything from IT conferences,  university classes, webinars, book club meetups at a coffee shop, and more.

    UMember has 3 types: Space Owner, Event Organizer, and Meeting Attendee

    UEvent is composed of one or more Meetings and is linked to an Organizer and Space. For example, a school class or conference is an Event and each session is a Meeting.

    UMeeting occurs for a specific Time and Space.

    USpace uniquely identifies a physical Space (for example an office or coffee shop) or virtual space (for example a website or Zoom call). It is also linked to an Owner.

    USchedule links an Attendee to a Meeting. For example, a conference Attendee can schedule one or more sessions (Meetings).

    UEvent

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • That looks really nice and universal to me 🙂 from both drawing and design perspectives.

    What have you used for drawing?

  • Iulian -207023 wrote:

    That looks really nice and universal to me 🙂 from both drawing and design perspectives.

    What have you used for drawing?

    If you're asking me, it's just Visio.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 10 posts - 16 through 24 (of 24 total)

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