How to add days and time for instructor schedule

[ahm1985]

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

 

[Andrzejek]

How about extending the Instructors_courses table:
[tt]
Instructors_courses
instcourseID
InstractorID
CourseID
StartDate
EndDate
Day_Of_Week[/tt] (1-Sunday, 2-Monday, etc.)[tt]
StartTime
EndTime[/tt]

Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[SkipVought]

Ahm1985, you've started 71 threads since you became a member in 2012 and have received many good tips, but it seems you have never awarded a Little Purple Star to anyone.

These not only show your appreciation but also identify worthy posts to other members looking for good information.

I hope that you will take these things into mind from this point forward.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[SkipVought]

Ahm1985, you awarded the wrong person a Little Purple Star.

I added nothing to you original post. Review your thread to see who could ntributed.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]