ahmed salah

ahmed salah

  • NA
  • 530
  • 148.4k

How to add days and time for instructor schedule

Nov 4 2016 6:53 PM
Problem

I need to get schedule for every instructor weekly or daily .

And which time it give course for training center .
 
And what course it will give .
 
Example
 
Instructor martin give course c# in Monday and Saturday for period 12 pm - 03 pm and
 
SQL in Sunday and Wednesday for
 
period 12 pm - 03 pm .
 
Details
 
So that i designed the following tables :
 
Instructors table (InstractorID,InstractorName)
 
Courses table (CourseID,CourseName)
 
Instructors_courses (instcourseID,InstractorID,CourseID)
 
And relation between instructors table and Courses table many to many so that i do
 
another table is Instructors_Courses table .
 
My questions are
 
1- How to represent days and time for every course added
 
Can i add table for time and table for days and make relation with Instructors_courses
 
table by adding day id and time id (one to many)
 
OR do it programming from user interface .
 
2- course start date and course end date these two fields how to represent in table
 
Instructors_courses table .
 
i can added but it will repeated with every course are this correct or what .
 

Answers (1)