《Database System Concepts Course Introduction》ch02.pptVIP

Chapter 2: Relational Model Chapter 2: Relational Model Structure of Relational Databases Fundamental Relational-Algebra-Operations Additional Relational-Algebra-Operations Extended Relational-Algebra-Operations Null Values Modification of the Database Example of a Relation Basic Structure Formally, given sets D1, D2, …. Dn a relation r is a subset of  D1 x D2 x … x DnThus, a relation is a set of n-tuples (a1, a2, …, an) where each ai ? Di Example: If customer_name = {Jones, Smith, Curry, Lindsay} customer_street = {Main, North, Park} customer_city = {Harrison, Rye, Pi