1.3.02. Access across relations

  • Relational model allows multiple relations to exist within one database schema
  • Relations can be accessed individually or together (joins).
  • Referential integrity
    • Relations relating
  • Pulling data out of single relations
    • Select and project
  • Pulling related data out of
    • Multiple relations using Join