SQL ER关系集

The participation constraint specifies whether the existence of an entity depends on its being related to another entity via the relationship type. This constraint specifies the minimum number of relationship instances that each entity can participate in.
There are two types of participation constraints: Total and Partial
Total Participation
Total Participation is when each entity in the entity set occurs in at least one relationship in that relationship set.
For instance, consider the relationship borrower between customers and loans. A double line from loan to borrower, as shown in figure below indicates that each loan must have at least one associated customer.

enter image description here

Partial Participation
Partial Participation is when each entity in the entity set may not occur in at least one relationship in that relationship set. For instance, If a company policy states that employee (manager) must manage a department, However every employee may not manage a department, so the participation of EMPLOYEE in the MANAGES relationship type is partial, meaning that some or part of the set of employee entities are related to some department entity via MANAGES, but not necessarily all.
Note: Partial Participation is represented by single line connecting entities in relationship.

最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容

  • PLEASE READ THE FOLLOWING APPLE DEVELOPER PROGRAM LICENSE...
    念念不忘的阅读 14,595评论 5 6
  • 差不多有五年的国庆节都没有感受过这种人车聚集的宏大场面了,不得不再次感慨一下,我国真是一个人口数额相当的泱泱大国。...
    miumiuli阅读 1,807评论 0 0
  • 文章转自和菜头(本人绝不将之用做任何商业用途,只为复制粘贴留作欣赏) 专门为老人家们写一篇文章的想法由来已久,新年...
    三阶微分阅读 1,709评论 0 0
  • 在面对一些突发事件或者无法掌控全局的时候,我们是否能做够很好的控制自己,在理智的清醒下,我们的脾气也许能够立刻...
    星涵阅读 1,443评论 0 0
  • 先推荐这本书《影像中的生死课》,作者陆晓娅 推荐理由:近两年被两本书深深打动,第一本书是柴静的《看见》,被孟老师称...
    星魁的实验室阅读 4,019评论 0 3