How To Break Down Many To Many Relationships Table into One To Many Relationship..

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi To All

I am Stuck in these Task....and I Seriously need Help as fast as possible otherwise my mentors....So Please any of u Please Help...

There are 2 Tables.....
First Table

Table Name : Student
Primary Key : Stu_Number

3 Fields Are There Stu_Number , Stu_Name , Class_Code

Second Table

Table Name : Class
Primary Key : Class_Code
Foreign Key : Stu_Number

4 Fields Are There Class_Code , Stu_Number , Course_Code , Time

The Above One is Having Many to Many Relationship and "My Task Is To Break It Into One To Many Relationship" So Which Field Can i Eliminate or Give me any Other Solutions.....
Please Help ME......

Posted 6-Jul-11 5:53am

Matrix 3

Updated 1-Apr-18 9:11am

Add a Solution

Comments

Аslam Iqbal 6-Jul-11 12:29pm

There is no many-to-many relationship in your schema. No one can solve your problem when you can't understand what is your problem. AND NEVER ask anything about to solve your home task. PLEASE try it your self.

2 solutions

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2011-07-06T06:05:00

No one. You can never create a relationship by eliminating a field. :-)

Create additional table: Student_Class_Assignment with the key Student_Class_Assignment_Id and two foreign keys: Stu_Number and Class_Code. Replace Class_Code from Student with Student_Class_Assignment_Id, remove Stu_Number from Class. It would by much easier to show on a UML diagram. The idea is: break the many-to-many relationship between Student and Class, add a middleman object between them.

—SA

Member 13757419 · Answer 2 · 2018-04-01T09:12:00

A many-to-many relationship must be broken down into multiple one-to-many relationships. In this example, each student could be in many classes and each class could have many students. Breaking down this requires adding a 'join table'. Perhaps an enrollment table?
Each student can enroll to many classes, for each class an enrollment ID is assigned.
So the student table can have the enrollment IDs as foreign keys, the enrollment table can have both the student ID and the class ID as foreign keys leaving the class table as only having course id and enrollment ID.

How To Break Down Many To Many Relationships Table into One To Many Relationship..

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0