locked
How to add days and time for instructor schedule RRS feed

  • Question

  • 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 question is

    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 .



    Friday, November 4, 2016 10:39 PM

Answers

  • You would need a table of dates  that would look like this

    Dates(DatesPK int identity primary key, Date datetime)

    then you would need a schedule table

    Schedules(SchedulePK int identity primary key, DatePK int references Dates(DatesPK),  instcourseID int reference Instructors_courses(instcourseID))

    Saturday, November 5, 2016 3:54 AM