How to store data (class schedule)?

Question

Database

There is an xls file that is converted to .json and only then parsed.
The structure is like this:

There is a group. 6 days, 6 lessons, each lesson has a name, an audience, a teacher.
1. Make a lot of .json, one for each group (about 1000 in total) and pull them when needed.
2. Store in the database: id-group-array of values ​​3. Store
in the database: id-group-day-pair-name-audience-teacher times, not just one day. 2. It will be necessary to update this schedule once a month (sometimes more often) (sometimes only one group, sometimes all) What is the best way to store data?

Answer 1

json was not invented for storing data, it is a format for packing data, transferring it in one piece, on the other hand, unpacking it while preserving the structure.
Therefore, of course, it is better to store in the database, from where to pull the necessary data. You can design a database in any way convenient for you. One table, ten tables...