MySQL 数据库系统设计实现与管理第六版课后习题答案Part 2 Review Questions and Exercises.doc

MySQL 数据库系统设计实现与管理第六版课后习题答案Part 2 Review Questions and Exercises.doc

  1. 1、本文档共61页,可阅读全部内容。
  2. 2、原创力文档(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
  3. 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载
  4. 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
Word可编辑 PAGE PAGE 19 Word可编辑 SOLUTIONS TO REVIEW QUESTIONS AND EXERCISES FOR PART 2 – THE RELATIONAL MODEL AND LANGUAGES (CHAPTERS 4 – 9) Solutions to Review Questions and Exercises TOC \o "1-3" \h \z Chapter 4 The Relational Model 3 Chapter 5 Relational Algebra and Relational Calculus 6 Chapter 6 SQL: Data Manipulation 22 Chapter 7 SQL: Data Definition 32 Chapter 8 Advanced SQL 42 Chapter 9 Object-Relational DBMSs 52 Chapter 4 The Relational Model Review Questions 4.1 Discuss each of the following concepts in the context of the relational data model: (a) Relation A table with columns and rows. (b) Attribute A named column of a relation. (c) Domain The set of allowable values for one or more attributes. (d) Tuple A row of a relation. (e) Intension The structure of a relation together with a specification of the domains and any other restrictions on possible values. Extension An instance of the tuples of a relation. (f) Degree The number of attributes in a relation. Cardinality The number of tuples in a relation. Each term defined in Section 4.2.1. 4.2 Describe the relationship between mathematical relations and relations in the relational data model? Let D1, D2, . . . , Dn be n sets. Their Cartesian product is defined as: D1 ? D2 ? . . . ? Dn ? {(d1, d2, . . . , dn) | d1 ??D1, d2 ??D2, . . . , dn ??Dn} Any set of n-tuples from this Cartesian product is a relation on the n sets. Now let A1, A2, . . ., An be attributes with domains D1, D2, . . . , Dn. Then the set {A1:D1, A2:D2, . . . , An:Dn} is a relation schema. A relation R defined by a relation schema S is a set of mappings from the attribute names to their corresponding domains. Thus, relation R is a set of n-tuples: (A1:d1, A2:d2, . . . , An:dn) such that d1 ??D1, d2 ??D2, . . . , dn ??Dn Each element in the n-tuple consists of an attribute and a value for that attribute. Discussed fully in Sections 4.2.2 and 4.2.3. 4.3 Describe the differences between a r

您可能关注的文档

文档评论(0)

Kaiser + 关注
实名认证
内容提供者

该用户很懒,什么也没介绍

1亿VIP精品文档

相关文档