How to make relations for instructor schedule(one to many and many to many between tables)

Question

1.00/5 (2 votes)

See more:

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)

What I have tried:

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

Posted 25-Nov-16 4:55am

ahmed_sa

Updated 25-Nov-16 5:22am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2016-11-25T05:22:00

So write down sample data for each table, and establish what the relationships are.
For example, if you have an Invoices table and a InvoiceItems table:
Invoices:

Id       Date         Customer
1        2016-11-01   JS bits
2        2016-11-02   JS Bits
3        2016-11-03   Mikes parts

InvoiceItems:

Id       InvoiceId    Item
1        1            A bit
2        1            A bigger bit
3        1            A tiny bit
4        2            A tiny bit
5        3            A Part
6        3            B Part

Then it's obvious you have a one-to-many relations ship between the two tables, with InvoiceId being a Foreign key to Invoices.Id

Work out what relationships you need, and establish them in SSMS via "Database Diagrams" branch of the database in the Object Explorer pane.