Database schema and logic for this

Database schema and logic for this

I am trying to create a timetable for classes in MySQL. The columns are
the days of the week and the rows are the time intervals ( i.e. 7:00 -
8:00 ). I am also trying to have 30-minute time intervals and when a
particular subject is 2 hours, it will span 4 rows. Each cell contains the
name of the course and room. This is part of a small program I am trying
to develop. So far, I know what data to insert but I'm stuck on creating
the right database schema. Really need the logic on how to get this
started (i.e. what data types should I use ). Thanks!