SQLTeam.com | Weblogs | Forums

How to make Relations for Instructor Schedule(one to many and many to many between tables)




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 (Section,Class,Instructor,Courses,Student)

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

  • Training center Have more instructors .

  • 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 .

*Training center have 10 classes and every courses can given in more classes within week .

*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 **

Instructor Michel give Courses C# And SQL from time 2 to time 4 Every Sunday And Wednesday weekly in class A1 And B1 And C1

For section A And B and C And D (Relation between each table and others)