Problem
How to make database design for Instructor Schedule(only relations between every table and other one to many AND Many to Many)
Tables already created but relation not make Tables created (Section,Class(lab),Instructor,Courses)
I need to make Tables Relation for Instructors schedule working in Training center give courses for Microsoft products
as ACCESS ,EXCEL,C#,SQL as following
-
Every instructor give more courses in ACCESS ,EXCEL,C#,SQL weekly from Sunday to Thursday .
-
Every instructor give Courses ACCESS ,EXCEL,C#,SQL in more classes inside Training center .
-
Every courses ACCESS ,EXCEL,C#,SQL can given by more instructor .
-
Every instructor give more sections .
-
Section mean group of student every group of student classified to A,B,C,D,E,F.
-
Every section can given by more instructor within week .
-
Every section can given more courses in week .
-
Every section can get more courses in more classes .
So that i need to know
How to make schedule for every instructor as following
show courses taken in which classes for which section based on date time as following
