1 / 3
文档名称:

relational model - udc csit.pdf

格式:pdf   页数:3页
下载后只包含 1 个 PDF 格式的文档,没有任何的图纸或源代码,查看文件列表

如果您已付费下载过本站文档,您可以点这里二次下载

relational model - udc csit.pdf

上传人:薄荷牛奶 2016/6/15 文件大小:0 KB

下载得到文件列表

relational model - udc csit.pdf

相关文档

文档介绍

文档介绍:Dr. Byunggu Yu 1 RELATIONAL MODEL Schema and Relation Instance ????A relation schema is a list of attribute names (user defined domain names), . Account = (branch-name, account#, balance). However, for various reasons, a relation schema is often represented by a set (not an ordered list) of attributes. ????A relation instance is a subset of a Cartesian product of a list of domains. ., account(Account): "account" is a relation instance on "Account" schema. The relation instance "account" is a subset of D1 × D2 × D3, where D1, D2, and D3 are the domains of "branch-name", "account-name", and "balance", respectively. ????A tuple is an element of a relation instance. If there are n attributes, each tuple of the relation instance is an ordered n- tuple. Thus, each tuple is an n-ary relationship between n attribute values. A relation is, in fact, a set of such relationships. ????"relation" often means "relation instance" Dr. Byunggu Yu 2 ????"database" often means "database instance" ????Recall the three-level database (Lecture Note#1). In the logical level, database schema is a set of relation schemas and database instance is a set of relation instances. Note, in relational data model, relation schema consists of atomic domains. A dom