Relational Databases Notes

Relational Databases

Key Concepts

  • Relational Database: Contains two or more tables.
  • Flat File Database: Contains a single table.
  • Primary Key: A unique field used to identify each record in a table and establish connections between tables.

Key Differences

  • Flat file databases cannot create relationships with other tables.
  • Relational tables can create relationships with other tables using primary keys.