欧美三区_成人在线免费观看视频_欧美极品少妇xxxxⅹ免费视频_a级毛片免费播放_鲁一鲁中文字幕久久_亚洲一级特黄

the relationship's existence.

系統 2232 0

Understanding Relationship Existence


Existence describes the relationship between a pair of entities from the perspective of the child entity. Fundamentally, it asks the question, "Is a foreign key value always required in the child entity?" The possible answers are:

Existence
Meaning
Optional
A foreign key value is not always required in the child entity. However, if a value does exist, then the foreign key value must be found in the primary key of the parent.
Mandatory
A foreign key value must exist in the child entity and the foreign key value must be found in the primary key of the parent.

To illustrate the use of existence, let's take the example of Order and OrderStatus. If you set the relationship existence to optional, then Orders could exist without being assigned an OrderStatus. Thus, you may or may not know whether any given Order is fulfilled, cancelled or on back order, which would certainly complicate business operations and probably lead to poor customer service. In this example, it probably is desirable to set existence to mandatory. However, you must enforce the specification of this information, both through your information systems and business practices.

Relationship Type Settings
  • Identifying Relationships: Are always mandatory.
  • Non-Identifying Relationships: Can be mandatory or optional. In the IDEF1X notation, optional non-identifying relationships are notated with a hollow diamond at the parent end of the relationship line.
  • Non-Specific Relationships: Cannot be enforced in non-specific relationships because we cannot resolve many-to-many relationships.
Effect on Cardinality

Relationship existence also has implications for relationship cardinality. If a relationship is mandatory, then the cardinality must be in the form of one-to-something. If it is optional, then the cardinality would be in the form of zero or one-to-something.

Enforcing Existence in the Physical Design

ER/Studio carries the meaning of relationship to the physical design. To enforce relationship existence rules, it defaults the foreign key columns propagated by a mandatory relationship to NOT NULL. Optional relationships propagate foreign key columns that can be NULL.

the relationship's existence.


更多文章、技術交流、商務合作、聯系博主

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號聯系: 360901061

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。

【本文對您有幫助就好】

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長會非常 感謝您的哦!!!

發表我的評論
最新評論 總共0條評論
主站蜘蛛池模板: 五月婷婷综合激情 | 超碰97最新 | 国产精品视频播放 | 亚洲国产一区二区三区四区色欲 | 亚洲午夜精品A片久久不卡蜜桃 | 亚洲天天干 | 亚洲一在线 | 免费的黄色一级片 | 国产专区在线播放 | 天天摸夜夜摸夜夜狠狠摸 | 日韩欧美福利视频 | 欧美很黄视频在线观看 | 久久视频在线视频 | 色播在线永久免费视频网站 | 日韩精品免费视频 | 久久久久久久久久综合情日本 | 91免费在线播放 | 国产五月色婷婷六月丁香视频 | 久九精品| 性少妇videosexfreexx入片 | 色聚网久久综合 | 国产 日韩 欧美 亚洲 | 99成人| 久久久精品在线观看 | 在线观看视频一区 | 一区二区国产在线观看 | 污污小视频在线观看 | 看片免费黄 | 99精品国产免费久久国语 | 亚洲国产精品日韩高清秒播 | 色香首页 | 521色香蕉网站在线观看 | 天天看天天摸色天天综合网 | 欧美成人免费高清网站 | 国产成人视屏 | 精品毛片 | 免费视频97碰碰碰在线观看 | 欧美中文字幕一区二区三区亚洲 | 巨大乳女人做爰视频在线 | 十六以下岁女子毛片免费 | 六月伊人|