## 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.

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?

This course delves into the theory behind relational databases. You'll learn what they are and see how they differ from non-relational databases. Throughout the course, we'll walk you through the ins and outs of database design and familiarize you with various types of relationships. Additionally, you'll explore the concepts of normalization and normal forms, equipping you with the knowledge to craft efficient and optimized databases.

This section dives into the world of relational and non-relational databases, teaching you how to visually represent database structures.

We'll dive deep into relational databases, giving you a thorough understanding of essential concepts. This includes topics like foreign keys, various ON DELETE options, and the different types of relationships.

Ready to build a database? This section will hone your skills, emphasizing the importance of a well-structured database for peak performance. Here, you'll grasp the fundamental principles of crafting user-friendly databases.

Relational Database and Normalization

Difference between Relational and Non-relational Databases

Overview

Main Differences