2.1.17. SQL Tables

  • Relations are bags, not sets
    • e.g. projection of non-key attributes
  • Set cannot contain duplicate item/repetition
  • Duplicates exist in bags and be:
    • SELECT DISTINCT (eliminated)
    • SELECT ALL (ignored/kept)