mysql - Database design for the Lectures Scheduling for a Single Course -

I want to store lecture time information in 3 Normalized databases. The ER diagrams of lecture information are as follows:

Since lecture-payer has more than one value attribute, I have prepared the database as follows:

Lecture Time:

_ID | | Lecture start time Lecture end time. Lecture prohibition | Course Id FK

LectureDeTable:

_ID | Lecture time ID FK | Course ID FK | Lecturer days

The questions to ask for these tables are as follows:

  Make Table Lecture TimeTable (_id INTEGER, not startTime text faucet, end time text NULL, Course_ID_FK Integer, Foreign Key (course_ID_f) Reference Course (_ID), Primary Key (_id, Course_ID_FK)); Table Lectures DataTable (_id Integer, ClassEday integer, ClassTime_ID_fk Integer, Course_ID_fk indigree, Foreign key (Course_ID_fk, Class Time_ID_fk) Reference lecture time-time (course_id_fk, _id), primary key (_id, class time_id_fk, course_id_fk) );   
 Now the user joins the new program for the course by giving lecture space, start time, end time and lecture days. I'm adding this information separately to tables:    Write the timetable value in the lecture (1, "12:00", "1:00", 1); // To insert the day as I am using the following types for the loop, here (i = 0; i & lt; = selectedDays.length (); i ++) {insert in the lecture table Value (1, selected day [i], 1, 1); }   
 I'm worried about adding / retrieving data from these tables so I want to make sure my database design is not bad.  
 Thanks   
 
 
   
 You can design a table named  Timetable  This table can catch your weekly program. You can fill it with a block of time and 2-dimensional array of rooms altogether. This allows you to print a schedule on a screen without computing a grid. The grid has already been loaded in the table. You can then assign them to a  timetable     from a table of  lecture