How to add days and time for instructor schedule

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 .

In my opinion, you will need tables at every step of the way. The tables that you represented just now will work only as template tables. From these there will be tables where no date is mentioned by just from date and to date is mentioned.

Then you will also need a table with date and time and all other details to indicate (may be) present count for that instance of course. It may so happen that the session will not take place because instructor was sick, etc.

Basically, any information that you cannot accommodate at a level you already are, you will need separate table where more dimension attributes get added.

In short, in Employee table, you may have DateOfJoining and DateOfLeaving, but if you want to record about each day if employee was present of not, you will need another table with Employee Id, Date, Time In, Time Out, etc.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
In my opinion, you will need tables at every step of the way. The tables that you represented just now will work only as template tables. From these there will be tables where no date is mentioned by just from date and to date is mentioned.

Then you will also need a table with date and time and all other details to indicate (may be) present count for that instance of course. It may so happen that the session will not take place because instructor was sick, etc.

Basically, any information that you cannot accommodate at a level you already are, you will need separate table where more dimension attributes get added.

In short, in Employee table, you may have DateOfJoining and DateOfLeaving, but if you want to record about each day if employee was present of not, you will need another table with Employee Id, Date, Time In, Time Out, etc.