TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ahmed salah
NA
530
149.8k
How to add days and time for instructor schedule
Nov 4 2016 6:53 PM
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 .
Reply
Answers (
1
)
Are this design (ERD) is correct for the following table
update data base