Junior — Middle
How is data stored in relational database systems?
sobes.tech AI
Answer from AI
In relational database systems, information is organized into tables consisting of rows and columns. Each table represents an entity (e.g., users, orders), and columns are attributes of that entity.
Main organization principles:
- Rows — individual records (instances of the entity).
- Columns — fields with a specific data type.
- Primary key — a unique identifier for a record.
- Foreign keys — references to records in other tables to establish relationships.
- Normalization — the process of structuring data to reduce redundancy and ensure integrity.
Example of a "Users" table:
| user_id (PK) | name | |
|---|---|---|
| 1 | Ivan | ivan@mail.com |
| 2 | Maria | maria@mail.com |