Difference between revisions of "Databases"

From Suhrid.net Wiki
Jump to navigationJump to search
Line 5: Line 5:
 
* Each tuple (row) has a value for each attribute
 
* Each tuple (row) has a value for each attribute
 
* Each attribute has a type (or domain)
 
* Each attribute has a type (or domain)
 +
* All queries return relations (tables), so it can said to be compositional or closed.

Revision as of 22:40, 7 December 2013

Relational Databases

  • Set of named relations (tables)
  • Each relation has a set of named attributes (columns)
  • Each tuple (row) has a value for each attribute
  • Each attribute has a type (or domain)
  • All queries return relations (tables), so it can said to be compositional or closed.