How to make Relations for Instructor Schedule(1-n or n-m)

ahmed salah

9y870SQL

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kranthi Vardhan Kolluru9y ago
Actually you don't need to maintain such many tables and its not the right way of analysis. There is no need to maintain Instructor and class separately i don't no the requirement you have its ok,there is no SectionID relation to the Class and it is not the right way to assign sections directly to student you must assign class to the student then class have different sections. so as i discussed before you can maintain the schedule table like that. whatever it is already you designed lets discuss on it

yes! you can get.. from 'Instructor_Class' get the classID from Instructor_Class table and Instructor details from Instructor_Class

InstructorCourses_table<== Instructor_Class_Table<=== Instructor_Table

i.e., you are taking instructor details directly from instructor Table. instead of that join the table across instructor_Class table and from Instrctor_Class table to Instructor Table. Then you will get ClassIDs.

In Instructor_Class Table maintain the classIDs and InstructorIDs multiple.

Time and days fields maintain in Instructor_Courses table
ahmed salah9y ago
I do this diagram can you please tell me
how to get schedule from this diagram according to my analysis
I will make InstructorCourses table as schedule but i need to get class id
and time and days i will add in InstructorCourses table without any problem
but i need to know
how to get class id in table InstructorCourses to make schedule
this is my analysis
every Instructor have more class(lab or class room) teach student in it
and every class(lab or class room) can have more instructor give courses in it
Kranthi Vardhan Kolluru9y ago
this is only for schedule you can't do attendance in this table. you must maintain an another table for attendance based on this schedule table.

StudentID | CourseID(show the content at frontend as Coursename+Timing ex: Sql2pm-4pm class and backend i.e., in sql store CourseID) | Month | Year | AbsentDay

or else instead of Month year AbsentDay fields you can maintain 'AbsentDate'

For attendance maintain only absent days of that month and remaining days are present..
ahmed salah9y ago
Thank you for reply
but if i make all tables id added in one table Schedule will done and it will solve problem
but in this case database will made for Schedule only
meaning if i need to make attendance for students after that i cannot do attendance for students
Kranthi Vardhan Kolluru9y ago
Hi

You have to create the table Like this

Fields To create in Schedule Table
===========================
Course | Class | Sections | Week | Timings | Date | Instructor |

and insert the all IDs in the table and Schedule the time table for the instructor. Now you can get any time of Relation.

Week, Timing and Date should additionally added

Course \|	Class \|	Sections \|	Week \|	Timings \|	Date \|	Instructor \|