Junior — Middle
What does the term 'relational database' mean and why is it called that?
sobes.tech AI
Answer from AI
A relational database is a type of database in which data is organized into tables (relations). Each table consists of rows and columns, where rows represent records and columns are fields with specific data types.
The term "relational" comes from the concept of "relation" in set theory and mathematical logic, introduced by Edgar Codd. He described a model where data is stored as relations (tables), and operations on them are performed using relational algebra.
Main advantages of relational databases:
- Clear data structure
- Ability to use SQL for queries
- Support for data integrity and relationships between tables
Example of a "Users" table:
| ID | Name | Age |
|---|---|---|
| 1 | Ivan | 30 |
| 2 | Maria | 25 |