How to correctly implement the schedule database structure for the university?

Question

MySQL

How to correctly implement the structure of the database timetable for the university?
Is there any example, article, diagram, diagram, book?

Answer 1

I don't see a problem:
schedule
============
id
group - group name
lesson - pair number (according to the pair number, count time if necessary)
title - subject name
teacher - teacher name
room - audience number
if necessary , scatter among different directories, for example, replace group with group_id and make a separate table about the group