How To Add Days And Time For Instructor Schedule

Posted by Ahmedsa under Sql Server on 11/4/2016 | Points: 10 | Views : 140 | Status : [Member] | Replies : 0
Problem

I need to make design database(ERD) for displaying schedule for every instructor

include

day of course(Saturday or Monday,etc)

And which time it will give course(period FROM 12 PM TO 03 PM ) .

And what course it will give(c# or SQL) .

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 table (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 .




Responses

(No response found.)

Login to post response