What is the difference between the many-to-many relationship between the three geometries and the three-to-many relationship between the two

Source: Internet
Author: User

Definition:

When there are many-to-many connections between an entity set and other entity sets between more than two entity sets, and there is no connection between other entity sets, this association is called the many-to-many association between multiple entity sets.

 
 
 
For example, there are three entity sets: suppliers, projects, and parts. One supplier can supply multiple parts for multiple projects. Each project can use parts from multiple suppliers; each part can be provided by different suppliers.

But there is no connection between the project and the part.

 
. Therefore, the supplier, project, and parts are multiple-to-multiple links. Supplier <---> Project: many-to-many, supplier <---> parts: many-to-many, the project has no clear contact with the parts.
 
 
 
Certificate ----------------------------------------------------------------------------------------------------------------------------------------

One question can help you better understand:

GiveEIRFigure, requires three solid types, and3There are many-to-many relationships between physical entities.3Is the multi-to-many relationship between physical entities equivalent to the three multi-to-many connections between the three physical entities? Why?

A:

 

3Multiple-to-multiple connections and3Real-size3Multiple-to-multiple connectionsIs not equivalentBecause they have different semantics.3Shows three multiple-to-multiple connections between two real-size instances.

 

The first question is the relationship between Middle School Students and courses and classrooms (Class), While the classroom has nothing to do with the course. Each of the second two has its own relationship.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.