INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

How to add days and time for instructor schedule

How to add days and time for instructor schedule

(OP)
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 .

RE: How to add days and time for instructor schedule

How about extending the Instructors_courses table:

Instructors_courses

instcourseID
InstractorID
CourseID
StartDate
EndDate
Day_Of_Week
(1-Sunday, 2-Monday, etc.)
StartTime
EndTime

Have fun.

---- Andy

There is a great need for a sarcasm font.

RE: How to add days and time for instructor schedule

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: How to add days and time for instructor schedule

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close