1 Replies - 378 Views - Last Post: 04 November 2016 - 05:36 PM

#1 ahmedba  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 141
  • Joined: 24-January 14

How to add days and time for instructor schedule

Posted 04 November 2016 - 05:06 PM

Problem

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

include the following

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 .

Is This A Good Question/Topic? 0
  • +

Replies To: How to add days and time for instructor schedule

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 13400
  • View blog
  • Posts: 53,482
  • Joined: 12-June 08

Re: How to add days and time for instructor schedule

Posted 04 November 2016 - 05:36 PM

Quote

1- How to represent days and time for every course added

A table that has columns for an id, day of the week, and time. Relate that to the course id.

Quote

i can added but it will repeated with every course are this correct or what .

What will repeat? Maybe course is only half a semester, or maybe it is a year long class. Start/end in the course info isn't a bad idea.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1