- 1、本文档共51页,可阅读全部内容。
- 2、原创力文档(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
Solutions
Chapter 4
c we assume that a phone and address can only belong to a single customer (1-m relationship
represented by arrow into customer).
d)
In d we assume that an address can only belong to one customer and a phone can exist at only one
address.
If the multiplicity of above relationships were m-to-n, the entity set becomes weak and the key
ssNo of customers will be needed as part of the composite key of the entity set.
In cd, we convert attributes phones and addresses to entity sets. Since entity sets often
become relations in relational design,
we must consider more efficient alternatives.
Instead of querying multiple tables where key values are duplicated, we can also modify
attributes:
(i) Phones attribute can be converted into HomePhone, OfficePhone and CellPhone.
(ii) A multivalued attribute such as alias can be kept as an attribute where a single column can
be used in relational design . concatenate all values. SQL allows a query like %Junius% to
search the multiple values in a column alias.
a)
b)
c)
The relationship played between Teams and Players is similar to relationship plays between
Teams and Players.
The information about children can be ascertained from motherOf and fatherOf relationships.
Attribute ssNo is required since names are not unique.
Professor only works in at most one department.
A course has at most one TA.
A course is only taught by one professor and offered by one department.
Students and professors have been assigned unique email ids.
A course is uniquely identified by the course no, section no, and semester . cs157-3 spring 09).
that for each movie, a unique studio exists that produces the movie. Each star is contracted to
at most one studio.
But stars could be unemployed at a given time. Thus the four-way relationship in fig can be
easily into converted equivalent relationships.
The o
您可能关注的文档
- 整体竣工验收保证方案.pdf
- 整体性期末考前专项练习.pdf
- 敲击检测技术交底.pdf
- 数轴上的动点问题(一)学生版.pdf
- 数码相机租赁协议书.pdf
- 整体装配式附着升降脚手架专项施工方案.pdf
- 数的运算(北师版)(含答案).pdf
- 数码摄影入门知识.pdf
- 数的认识复习卷.pdf
- 整体介绍海康威视智能交通应用方案.pdf
- 科普版英语四年级上册:Lesson10 Let’s say hello to her 教案设计.docx
- 人教pep六年级上册英语学案:Unit1 How can I get there Part A .docx
- 人教新起点版四年级上册英语-Unit 2 On the Weekend-Lesson 3 A Sad, Bad, Terrible Day教学设计 .docx
- Unit 6 Work quietly Period 3 (教案)2023-2024学年英语五年级下册.docx
- 二年级下册数学教案-第4章《认识万以内的数》-苏教版.docx
- 部编版语文二年级上册23《纸船和风筝》(说课稿).docx
- 一年级下册数学教案-100以内数的认识练习六1-苏教版.docx
- 防病毒感染用一次性卫生面罩市场发展前景分析及供需格局研究预测报告.docx
- 抛光用布项目品牌策略.docx
- 残障者用助行架商业机会挖掘与战略布局策略研究报告.docx
文档评论(0)