Summary
This chapter explains the difference between table-based data modeling in relational databases and JSON/dictionary-like data storage in non-relational databases.

General domain of usage
Database management systems

## Overview
**Relational database management systems (RDBMS)** offer an intuitive **user interface**, making them accessible even to those with limited experience. They organize data into tables that interrelate.

**Non-relational database management systems**, on the other hand, provide a specialized interface tailored primarily for developers. They store data in distinctive formats, not in tables. Of these formats, **JSON (JavaScript Object Notation)** stands out as the most prevalent.

Store data in various formats, like JSON.

For illustration, consider two datasets named "**student**" with the fields: **id**, **name**, **surname**, and **age**. Below is how these datasets might be represented in both relational and non-relational database contexts:

**Data in non-relational databases** often resemble **dictionary-like structures**, akin to those in Python. Below is an example showcasing this relationship:

Here, we have student data associated with the group **BG1**. Unlike relational systems, there's no direct linkage present. The non-relational system (or NoSQL DBMS) is responsible for identifying this association.

We'll dive deeper into the intricacies of relational databases as we progress in this course.

Which database management systems (DBMS) uses tables?

Which database (DB) model uses different object formats?

Which database management systems (DBMS) use different object formats?

A focused introduction to relational databases for beginners. This course covers the essential concepts: how relational databases differ from non-relational ones, the entity-relationship model, types of relationships, primary and foreign keys, and the basics of normalization. Learners will gain a solid foundation in how data is organized and structured in relational database systems, preparing them for practical SQL and further database studies.

Difference between Relational and Non-relational Databases

Overview

Main Differences

1. Which database (DB) model uses tables?

2. Which database management systems (DBMS) uses tables?

3. Which database (DB) model uses different object formats?

4. Which database management systems (DBMS) use different object formats?