- 1、本文档共45页,可阅读全部内容。
- 2、有哪些信誉好的足球投注网站(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
数据库系统基础教程第四章答案.doc
Solutions
Chapter 4
4.1.1
4.1.2
a)
b)
c)
In 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 i.e. concatenate all values. SQL allows a query like %Junius% to search the multiple values in a column alias.
4.1.3
4.1.4
a)
b)
c)
The relationship played between Teams and Players is similar to relationship plays between Teams and Players.
4.1.5
4.1.6 The information about children can be ascertained from motherOf and fatherOf relationships. Attribute ssNo is required since names are not unique.
4.1.7
4.1.8
a)
(b)
4.1.9
Assumptions
A 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 (e.g. cs157-3 spring 09).
4.1.10
Given 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 4.6 can be easily into converted equivalent relationships.
您可能关注的文档
- 安全双重预防体系体系建设方案.doc
- 烛之武退秦师导学案(教师版).doc
- 安全技术比武试题(答案版)2018.8.6.doc
- 父母对幼儿寄语大全(共9篇).doc
- 山西省县乡医疗机构常见病种双向转诊指南.doc
- 物业管理一年四季与每月重点工作概览.doc
- 市政工程——污水管道清淤施工方案.doc
- 市政工程保障措施.doc
- 特种合金材料15CrMo、12Cr1MoV管道焊接施工方案.doc
- 市政工程外观、实测实量评定表格.doc
- 2021-2022学年湖南省常德市安乡县四年级上学期期中语文真题及答案.pdf
- 2023-2024学年河南省南阳市社旗县四年级上学期期中数学真题及答案.pdf
- 2022-2023学年云南省曲靖市四年级下学期期末数学真题及答案.pdf
- 2021-2022学年河南省周口市鹿邑县二年级下册月考语文真题及答案.pdf
- 2018年河南焦作解放区教师招聘考试真题及答案.pdf
- 2019年江西公务员行测考试真题及答案-乡镇.pdf
- 2019中国石油报社应届高校毕业生招聘试题及答案解析.pdf
- 光大银行招聘应届毕业生能力素质测试笔试真题及答案.pdf
- 2024年广西百色教师招聘考试模拟题及答案.pdf
- 2021-2022学年浙江绍兴诸暨市五年级上册语文期末试卷及答案.pdf
最近下载
- 锅炉电脑控制器使用说明书1.doc
- 华西crrt治疗基本信息与标准处方.pdf VIP
- 原神家具负荷表及计算器说明书(多功能小鹏).docx
- 2024-2030年中国橡胶木行业前景深度评估及发展趋势预判研究报告.docx
- 第六讲 中国特色社会主义的创立、发展和完善(解析版).docx VIP
- MITSUBISHI三菱MDS-E EH系列使用说明书.pdf VIP
- 幼儿园中班彩虹泡泡龙课件.pptx
- 5000吨废旧地膜及滴灌带等塑料制品回收加工再利用项目.docx
- 2023年广东省八年级上学期物理期中考试试卷四套附参考答案.docx VIP
- 静脉导管常见并发症临床护理实践指南解读ppt.pptx
文档评论(0)