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