What structure to use to store the group schedule in the database? How to display on the outside?

Question

SQLite

I'm making a web application that will display today's schedule (of a selected group) with a scale and current time.

I will use the MVC concept.
★ What structure should I use to store the group schedule chain? How is it stored in the database?
★ How to parse and display this data (on request) on an external page?

Answer 1

IMHO, any database is suitable here, the main thing is a table with records and api with a select to it. But the structure must be built separately, Excel will not work. You need a central table linking group, audience, subject and time IDs, then options like subject, and auxiliary tables with information about groups, audiences and subjects.