How to design an online DBMS?

Question

Database

Good day.
Briefly, my task can be described as follows: an online service in which the user can create a "schedule" of some event. In a simple way - a table of a certain structure: each event is divided into parts (stages), each part is a record in the table, the table fields: the name of the part, duration, etc. The fields in each schedule are the same.
Question: what is the best way to design a database?
The option to create a table for each event is somehow not very good. Just like with storing "parts of events" in a PostgreSQL array field.
A variant with the creation of an event table and a table of "event parts" with the event_id (FK) field for a specific event. But how fast will it work when the size of the "parts of events" table is large?
There was an idea to use a NoSQL database for this, but how efficient and fast is it?
Thanks

Answer 1

The second option with a relational structure is quite viable. A well indexed table will work without problems and on large volumes. You can test this ahead of time by creating a structure and populating it with lots of test data.
As for NoSQL, decide for yourself, there are a lot of materials, for example, here and here .