Relational Databases


Relational database is a structured database in which information is stored in tables where columns represent typed data fields and rows represent records.

  • often referred to as tabular schema
  • Software that maintains relational databases is often referred to as a relational database management system (RDBMS)
  • Tables are created with fields
    • each row is a record of data that represents the data of that table
  • have two main design components:
    • field name
    • data type
  • Structured query language (SQL) is the language used to query and manage data in a relational database