course content

Course Content

Relational Database and Normalization

Difference between Relational and Non-relational DatabasesDifference between Relational and Non-relational Databases

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.

Main Differences


Relational DatabasesNon-relational Databases
Store data in tables.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.

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?

question-icon

Which database (DB) model uses tables?

Select the correct answer

question-icon

Which database management systems (DBMS) uses tables?

Select a few correct answers

question-icon

Which database (DB) model uses different object formats?

Select the correct answer

question-icon

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

Select a few correct answers

Everything was clear?

Section 1. Chapter 2